InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 02:21:42 GMT20http://www.sqlservercentral.com/Forums/Topic1432027-364-1.aspxDoes the Waiting column have mixed data types, some numeric, some text? You many be running into an issue where SSIS thinks the data should be one type and in reality it is not.Maybe check out:[url=http://microsoft-ssis.blogspot.com/2011/06/mixed-data-types-in-excel-column.html]http://microsoft-ssis.blogspot.com/2011/06/mixed-data-types-in-excel-column.html[/url]Mon, 18 Mar 2013 04:26:27 GMTScott Murray-240410http://www.sqlservercentral.com/Forums/Topic1432027-364-1.aspxYup mapping is good..datatypes are good..checked the data in data viewer and see data for other columns but not for this column :(Mon, 18 Mar 2013 04:14:09 GMTrockstar283http://www.sqlservercentral.com/Forums/Topic1432027-364-1.aspxHi rockstar283,Can you make sure mapping is done correctly?I am sure you might have done this, but still, wanted to recheck. Thanks,Satish ChandraSun, 17 Mar 2013 23:09:22 GMTSatishChandra_SQLhttp://www.sqlservercentral.com/Forums/Topic1432027-364-1.aspxHelp pls guys..Sun, 17 Mar 2013 17:55:51 GMTrockstar283http://www.sqlservercentral.com/Forums/Topic1432027-364-1.aspxI am trying to extract the data out of an excel file with 3 columns Success, Failure and Waiting. The data from Success and Failure is getting extracted perfectly, but no data is being extracted from the excel file. The data types of source and destination are matching. I tried different file with the same structure..but still no data is being extracted from the Waiting column.Can anyone please help.Thank you!!Sun, 17 Mar 2013 14:41:59 GMTrockstar283