May 8, 2019 at 6:14 pm
I have a developer that created and SSIS package that uses bcp. the bcp command is on a process task the working directory is the tools\binn for sql server (2012). the executable is bcp and the arguments are out "business" -c -t~ -T -SXXXX
There are expressions used in the command @[User::TableName] + " out " + "\"" + @[User::ExtractFile] + "\"" + @[User::ProgramArguments] + @[User::DatabaseServerName and it is all in a loop to output various tables
Foreach Loop Container holds the tasks to generate each extract file per type of data
If I take the output that the log says it is executing and execute the bcp command from the command prompt I do not get the error. I am logged in as the same person both when running the command line and when executing the SSIS package.
Any ideas what I may be missing?
May 8, 2019 at 8:11 pm
What error is being returned?
May 8, 2019 at 8:12 pm
What is the exact text of the error message?
Is this something which used to work and has suddenly stopped, or has it never worked?
May 9, 2019 at 11:31 am
Error = [Microsoft][Sql Server Native Client 11.0]Unable to open BCP host data-file
I am able to run the same command from the command prompt without error
May 9, 2019 at 1:56 pm
As you are using an expression to define the Execute Process command, I would suggest that you put a debug breakpoint on the EP task and then check the run-time value of your expression to verify that it exactly matches what you are running from the command prompt.
I have had problems with the EP task in the past, where file paths contained one or more spaces, so keep an eye out for that.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply