BULK INSERT failing-Can't find the file

Enthusiast ,
Apr 29, 2019 Apr 29, 2019

Copy link to clipboard

Copied

I created some code that takes a CSV and BULK INSERTS it into an MS SQL database.

This is on Windows Server 2017. MS SQL 2017. CF 2016. SQL Server is separate from the CF server and connected with an internal 192.x.x.x. IP

The code works perfectly on my local development box, but when I run it on the server the CFQUERY BULK INSERT fails, 'the system can not find the path specified'

The file is there, I've also tried multiple locations. I can only presume this is a permissions issue. (CF is running on it's own user account with admin rights).

I'm somewhat stuck. I presume all of the permissions are made by CF?

Update:

Resolved. I was using the wrong password for the CF account

Solution: Create the same user account on the SQL box that is used for CF to run under, and then write to \\SQLServerIPS\c\ . I was using the wrong password, problem resolved.

Views

413

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct Answer

Enthusiast , May 01, 2019 May 01, 2019
I was looking to mark it as correct but could find an option, I guess the initial post can't be the right answer which makes sense.Reposted belowResolved. I was using the wrong password for the CF accountSolution: Create the same user account on the SQL box that is used for CF to run under, and then write to \\SQLServerIPS\c\ . I was using the wrong password, problem resolved.

Likes

Translate

Translate
Adobe Community Professional ,
May 01, 2019 May 01, 2019

Copy link to clipboard

Copied

Please copy the answer to a new post and mark the ticket as correctly answered. It will help someone else in future.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Enthusiast ,
May 01, 2019 May 01, 2019

Copy link to clipboard

Copied

LATEST

I was looking to mark it as correct but could find an option, I guess the initial post can't be the right answer which makes sense.

Reposted below

Resolved. I was using the wrong password for the CF account

Solution: Create the same user account on the SQL box that is used for CF to run under, and then write to \\SQLServerIPS\c\ . I was using the wrong password, problem resolved.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines