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?