SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Only one column not extracting from Excel source
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rockstar283
Yak Posting Veteran

89 Posts

Posted - 03/17/2013 :  16:42:59  Show Profile  Reply with Quote
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!!

James K
Flowing Fount of Yak Knowledge

3575 Posts

Posted - 03/17/2013 :  19:39:43  Show Profile  Reply with Quote
What method are you using? SSIS or something else? What is the data in the Excel sheet like? If it is a numeric and non-numeric data, you could try setting IMEX=1 (intermixed).
Go to Top of Page

rockstar283
Yak Posting Veteran

89 Posts

Posted - 03/17/2013 :  19:55:53  Show Profile  Reply with Quote
Help pls guys..
Go to Top of Page

bandi
Flowing Fount of Yak Knowledge

India
2206 Posts

Posted - 03/18/2013 :  03:34:11  Show Profile  Reply with Quote
Can you post screen shot of that import/export wizard's edit mappings dialog box and also datatypes of respective columns?

--
Chandu
Go to Top of Page

rockstar283
Yak Posting Veteran

89 Posts

Posted - 03/18/2013 :  06:15:19  Show Profile  Reply with Quote
I am not using I/E wizard mate..its just excel source and oledb destination..I have made sure that the datatypes and mapping are correct but the data viewer,after the source, is not showing data for this column but showing data for other columns properly
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000