Post reply

[SQL Server Destination [310]] Error: Unable to prepare the SSIS bulk insert for data insertion.

  • October 15, 2009 at 12:10 pm

    #136466

    Hi,

    I have a very basic package which has a tsql statement to do select from table in a OLE DB Source. The destinatino is a SQL Server Destination.

    the Connection Manager use a Provider of Native OLE DB\SQL Server Native Client 10.0

    the servername is localhostameinstance.

    This package always error out at the Pre-Execute.

    The error message is

    [SQL Server Destination [310]] Error: Unable to prepare the SSIS bulk insert for data insertion.

    How to correct this error?

    The source, the package, and the destination are in the localhost.

    thanks.

  • October 15, 2009 at 1:07 pm

    #1066458

    You usually see this error when the destination is not on the same server as the SSIS instance. In your case, everything is on the same node. I don't know why this is not working for you, but I would suggest trying to use the OLE DB Destination instead of the SQL Server Destination.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • May 14, 2014 at 6:49 am

    #1713451

    yes- I had the same issue and by using OLDB Destination resolved the issue.

    My summary of events is this:

    We recently went to virtual servers and my SSIS/BIDS is mapped out to a network drive vs being locak before.

    Now I can not use SQL destination without that error

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply