sql server dts: Unable to prepare the SSIS bulk insert for data insertion -- sql server dts

Unable to prepare the SSIS bulk insert for data insertion

Mark
8/30/2007 11:31:15 AM

sql server dts:

I have a client that is getting the error "Unable to prepare the SSIS bulk
insert for data insertion". The Sql Server is the same server as the SSIS
package and I have
changed my connection type from SQL Server to OLE DB with still get the
error.. Both myself and my client are System Admins. I created the package
and it works fine for me. I ran the profiler and do not see any errors, but
the package keeps failing whenever I do not run it. We have tried both
Windows and SQL Server Auth. Any idea how to troubleshoot this?

Re: Unable to prepare the SSIS bulk insert for data insertion

jhofmeyr NO[at]SPAM googlemail.com
8/31/2007 7:34:55 AM

[quoted text, click to view]

Can you provide more details about the package? What task are you
using to do the insert? Where is the data being pulled from? At what
point is the package failing (sounds like it's during the validation
phase, so before it actually starts executing the package?)

Worst case scenario, try deleting and recreating the package.

Good Luck
J