Home Forums SQL Server 2005 SQL Server 2005 Integration Services To insert varchar records in datetime field RE: To insert varchar records in datetime field

  • October 11, 2012 at 2:30 am

    #1547941

    Phil Parkin (10/11/2012)

    Your Excel column is holding mixed datatypes, so you'll need to bring in the column as string and add IMEX=1 to the Excel connection string (Google it for details).

    Thanks Phil...

    I added IMEX=1 to the connection string..

    But it displayed the error in OLEDB Source as

    Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Src_Product" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

    Regards

    Sqlstud