<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Data Warehousing
»
Integration Services
»
Only one column not extracting from Excel...
Only one column not extracting from Excel source
Rate Topic
Display Mode
Topic Options
Author
Message
rockstar283
rockstar283
Posted Sunday, March 17, 2013 2:41 PM
SSC Journeyman
Group: General Forum Members
Last Login: Thursday, May 30, 2013 4:32 PM
Points: 84,
Visits: 386
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
rockstar283
rockstar283
Posted Sunday, March 17, 2013 5:55 PM
SSC Journeyman
Group: General Forum Members
Last Login: Thursday, May 30, 2013 4:32 PM
Points: 84,
Visits: 386
Help pls guys..
Post #1432049
SatishChandra_SQL
SatishChandra_SQL
Posted Sunday, March 17, 2013 11:09 PM
Forum Newbie
Group: General Forum Members
Last Login: Yesterday @ 2:40 AM
Points: 6,
Visits: 217
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
rockstar283
rockstar283
Posted Monday, March 18, 2013 4:14 AM
SSC Journeyman
Group: General Forum Members
Last Login: Thursday, May 30, 2013 4:32 PM
Points: 84,
Visits: 386
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
Scott Murray-240410
Scott Murray-240410
Posted Monday, March 18, 2013 4:26 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Yesterday @ 8:58 AM
Points: 161,
Visits: 2,234
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 »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
