Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Only one column not extracting from Excel source Expand / Collapse
Author
Message
Posted Sunday, March 17, 2013 2:41 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 16, 2014 5:53 PM
Points: 115, Visits: 537
I 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!!
Post #1432027
Posted Sunday, March 17, 2013 5:55 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 16, 2014 5:53 PM
Points: 115, Visits: 537
Help pls guys..
Post #1432049
Posted Sunday, March 17, 2013 11:09 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 8, 2014 4:01 AM
Points: 13, Visits: 305
Hi rockstar283,

Can you make sure mapping is done correctly?
I am sure you might have done this, but still, wanted to recheck.

Thanks,
Satish Chandra
Post #1432077
Posted Monday, March 18, 2013 4:14 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 16, 2014 5:53 PM
Points: 115, Visits: 537
Yup mapping is good..datatypes are good..checked the data in data viewer and see data for other columns but not for this column
Post #1432128
Posted Monday, March 18, 2013 4:26 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, October 16, 2014 5:11 AM
Points: 243, Visits: 2,717
Does 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:
http://microsoft-ssis.blogspot.com/2011/06/mixed-data-types-in-excel-column.html
Post #1432130
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse