InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 00:26:38 GMT20http://www.sqlservercentral.com/Forums/Topic1370711-148-1.aspxIt is solved..i made change in the connection stringData Source=<path\xlsx filename>;Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties="Excel 12.0;HDR=YES;IMEX=1";Thanks to allRegardsSqlstudFri, 12 Oct 2012 03:04:31 GMTsqlstudhttp://www.sqlservercentral.com/Forums/Topic1370711-148-1.aspx[quote][b]Phil Parkin (10/11/2012)[/b][hr]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).[/quote]Thanks Phil...I added IMEX=1 to the connection string..But it displayed the error in OLEDB Source asError: 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.RegardsSqlstudThu, 11 Oct 2012 02:30:48 GMTsqlstudhttp://www.sqlservercentral.com/Forums/Topic1370711-148-1.aspxYour 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).Thu, 11 Oct 2012 01:12:44 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1370711-148-1.aspx[quote][b]sqlstud (10/10/2012)[/b][hr][quote]Well it sort of depends on what you want. You currently have a datetime column but obviously "DECLINED" isn't going to work there. If you want to keep your datetime datatype (which I strongly recommend) then you probably need to make that NULL. If you want to maintain the data exactly as it is excel you will have to change to a varchar column.[/quote]Thanks Sean..I have changed the datatype to Varchar....Please find the attachement.While make a preview in OLEDB Source the data in the date column is displayed as NULL. But in excel sheet, it is "DECLINED".Could you please give me the solution?RegardsSqlStud[/quote]I am with Sean - it's 100 times better to keep your dates in a datetime column and do something else with the DECLINED info - perhaps create another column to hold 'status', or whatever, and use that.Thu, 11 Oct 2012 01:10:46 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1370711-148-1.aspx[quote]Well it sort of depends on what you want. You currently have a datetime column but obviously "DECLINED" isn't going to work there. If you want to keep your datetime datatype (which I strongly recommend) then you probably need to make that NULL. If you want to maintain the data exactly as it is excel you will have to change to a varchar column.[/quote]Thanks Sean..I have changed the datatype to Varchar....Please find the attachement.While make a preview in OLEDB Source the data in the date column is displayed as NULL. But in excel sheet, it is "DECLINED".Could you please give me the solution?RegardsSqlStudWed, 10 Oct 2012 23:15:10 GMTsqlstudhttp://www.sqlservercentral.com/Forums/Topic1370711-148-1.aspx[quote][b]sqlstud (10/10/2012)[/b][hr]Hi,I have table "Trial1" One of the columns is DATERECEIVED DATETIME NULLLoading data from Excel to staging table using ssis 2005.Datareceived column contains data as below17/12/201018/12/2011DECLINEDNULLI need to load the data as it is. But thing is that, datatype is datetime..We can modify the column as varchar...But i need to know whether is it possible to load the data whatever present in the excel?RegardsSqlStud[/quote]Well it sort of depends on what you want. You currently have a datetime column but obviously "DECLINED" isn't going to work there. If you want to keep your datetime datatype (which I strongly recommend) then you probably need to make that NULL. If you want to maintain the data exactly as it is excel you will have to change to a varchar column.Wed, 10 Oct 2012 08:15:47 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1370711-148-1.aspxHi,I have table "Trial1" One of the columns is DATERECEIVED DATETIME NULLLoading data from Excel to staging table using ssis 2005.Datareceived column contains data as below17/12/201018/12/2011DECLINEDNULLI need to load the data as it is. But thing is that, datatype is datetime..We can modify the column as varchar...But i need to know whether is it possible to load the data whatever present in the excel?RegardsSqlStudWed, 10 Oct 2012 00:37:54 GMTsqlstud