none
error in ssis 2008 while transfering the data excel source to sql server destination

    Question

  • while transfering the data excel source to sql server destination

    im getting following error

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


    [SSIS.Pipeline] Error: component "SQL Server Destination" (88) failed the pre-execute phase and returned error code 0xC0202071.

    Plz give me solution

    Sunday, April 25, 2010 4:25 AM

All replies

  • How is the package structured? Have you tried using OLEDB destination?
    Nitesh Rai- Please mark the post as answered if it answers your question
    • Marked as answer by KIRAN KUAMR Sunday, April 25, 2010 12:14 PM
    • Unmarked as answer by KIRAN KUAMR Sunday, April 25, 2010 12:14 PM
    Sunday, April 25, 2010 7:51 AM
  • SQL Server destination component will work only if the package is being executed from the same (physical) server as the SQL Server itself. In other cases, you'll need to use OLEDB Destination instead of SQL Server Destination component.

    Hope this helps.

     

    Cheers!!

    Muqadder.

    Sunday, April 25, 2010 7:53 AM
  • Hi,

    I had taken Excel Source and SQL Server Destination in SSIS 2008

    and while SQL Server Destination is not working in SSIS 2008

     

    THEN How to use SQL Server Destination in SSIS 2008?

    Sunday, April 25, 2010 12:22 PM
  • instead of  SQL Server Destination , use OLEDB destination.
    Let us TRY this |

    http://quest4gen.blogspot.com/
    Sunday, April 25, 2010 12:31 PM
  • Is the desination table (which is being used inside sql server destination component) is on same server where the package is being executed? Kindly replace SQL Server Destination with OLEDB destinaiton  and check how it goes.
    Nitesh Rai- Please mark the post as answered if it answers your question
    Sunday, April 25, 2010 2:14 PM
  • rather than using sql server destination try out with either oledb or ado.net destination...

    the problem might be with conversions also... look at the datatype of the excel and the one which are present in your table... a

    i have tried wid the same scenario but i have got the output...

     


    Priyanka.Sutrave
    Monday, April 26, 2010 5:25 AM