opc.three (3/13/2012)
Jeff Moden (3/13/2012)
opc.three (3/13/2012)
If you use SQL Agent, there is no need to introduce an additional programming domain into the call stack. Ditch xp_CmdShell and call bcp from a step with type CmdExec.SSIS would be an equally capable tool to use here as well.
Ditch SSIS for an equally capable tool for this problem. Just use BULK INSERT and be done with it. 🙂
The "Fast Load Option" of the "OLE DB Destination" in SSIS implements BULK INSERT, same API.
Of course it is. But you don't need to go anywhere near an SSIS installation with BULK INSERT. It can all be done in T-SQL along with the rest of the processing.
--Jeff Moden
Change is inevitable... Change for the better is not.