Comments by a.g.s.maxwell (Top 2 by date)

a.g.s.maxwell 20-Jul-12 3:57am View

I realised that in my situation, the Bulk Insert Task will be calling the insert command from the server that the DB is on, not from the server running the SSIS package. The file only existed on the package server, not the DB server.

a.g.s.maxwell 19-Jul-12 10:51am View

I have the same problem in an SSIS package when using the Bulk Insert Task Editor to import data from a text file to a SQL Server table. The txt file exists, is local, is readable and writable and I am still getting this error.

Anyone have any ideas??

Advertise
Privacy
Cookies
Terms of Use
Last Updated 1 Jan 1900

Layout: fixed | fluid