No announcements
Found 3200112 threads
-
6 VotesSSIS excel data source numeric values returned as null
I alter the ConnectionString for my Excel Source in SSIS using VS 2017.Answered | 17 Replies | 42777 Views | Created by Odin_dark - Friday, May 8, 2009 10:30 PM | Last reply by JDLF - Monday, June 25, 2018 8:42 PM
-
0 Votes
Getting Null values on output of Excel Source
chek todds answer are youusing IMEX = 1 in your connection string , is it like ..... you may need to use it Provider=Microsoft.Jet.OLEDB.4.0;Data ...Answered | 7 Replies | 4177 Views | Created by MikeG973 - Monday, March 29, 2010 8:37 PM | Last reply by Nik - Shahriar Nikkhah - Tuesday, March 30, 2010 4:24 PM -
0 Votes
NULL values being loaded from Excel File using SSIS
Half of the columns are showing correct values while others are showing as NULL value when i click on Preview in Excel Source.Answered | 4 Replies | 7882 Views | Created by Ved_Prakash_ - Friday, December 12, 2014 10:41 AM | Last reply by Vaibhav.Chaudhari - Friday, December 12, 2014 11:11 AM -
0 Votes
Excel Source in SSIS 2008
I found that the information in the blog post here was able to resolve this for me.Answered | 7 Replies | 6276 Views | Created by JoJo_1 - Friday, January 13, 2012 4:31 PM | Last reply by Grambo25 - Tuesday, January 24, 2012 9:30 PM -
0 Votes
Excel data source returning null in INT column
Hi KajooYou must put the IMEX=1 property inside the double quotes.Answered | 8 Replies | 5167 Views | Created by Kajoo - Wednesday, January 21, 2009 11:24 PM | Last reply by Mr. Wharty - Wednesday, January 28, 2009 12:25 AM -
5 Votes
Excel Source on SSIS 2008 brings null values (IMEX=1 not working!)
It kept bring everything back as null ignoring the last row value.Answered | 15 Replies | 39568 Views | Created by Fernando Moyses - Tuesday, April 20, 2010 12:50 AM | Last reply by Pablo Gcode - Wednesday, August 19, 2015 8:20 PM -
1 Votes
Inserting null values and NO values null
Excel source can return null values when text and numbers are mixed in one column.Answered | 1 Replies | 5598 Views | Created by SBolton - Friday, April 16, 2010 8:00 PM | Last reply by Miloslav Peterka - Friday, April 16, 2010 8:49 PM -
0 Votes
Excel Source Connection nulling out column it things is a Date
Extended Properties="EXCEL 8.0;HDR=NO;IMEX=1 I even did not set HDR=YES but it still worked for me.In my Data Flow task ...Answered | 5 Replies | 3757 Views | Created by Bill Ennis - Wednesday, June 30, 2010 5:47 PM | Last reply by Bill Ennis - Thursday, July 1, 2010 4:19 PM -
0 Votes
SSIS Excel source Data type change errors
If it’s Excel 97-2003, SSIS uses Jet to access the Excel files.Answered | 12 Replies | 9749 Views | Created by SomeNothing - Thursday, December 16, 2010 12:51 PM | Last reply by KJian_ - Friday, December 24, 2010 5:12 AM -
0 Votes
SSIS import from Excel and cells with dates
Do I got correct that IMEX=1 should make ALL SSIS fields as DT_WSTR ?Answered | 10 Replies | 11895 Views | Created by Fedor Gulin - Thursday, April 28, 2011 3:53 PM | Last reply by Nik - Shahriar Nikkhah - Wednesday, May 4, 2011 3:18 PM -
0 Votes
SSIS excel datatype issue
thanks for reply .. could you please explain me how to set IMEX = 1 in connection string ?Answered | 4 Replies | 3669 Views | Created by Rajashakar - Tuesday, April 21, 2015 12:23 PM | Last reply by Visakh16 - Wednesday, April 22, 2015 5:48 AM -
0 Votes
Import date from excel file to SSIS Excel Source
Under ConnectionString append IMEX=1 at the end, This forces mixed data to be converted to text.Answered | 4 Replies | 2803 Views | Created by Husain Sadiq - Wednesday, January 25, 2012 10:05 AM | Last reply by Husain Sadiq - Wednesday, January 25, 2012 12:20 PM -
0 Votes
Sql 2008 SSIS, Importing Excel 2003 Spreadsheets, silent errors
When typing the Extended Properties for the OLEDB Connection Manager, for Xlsx files, it should be "Excel 12.0 Xml;HDR=YES;IMEX=1".Answered | 7 Replies | 6013 Views | Created by edm2 - Wednesday, September 11, 2013 12:03 AM | Last reply by Elisberg - Wednesday, October 9, 2013 7:59 AM -
1 Votes
Excel Source stopped working in SSIS
To test my luck, I installed Visual Studio Community Edition 2019 and added IS,AS extensions and tried to work with Excel Source, it is showing up sheet names without us ...Answered | 14 Replies | 17737 Views | Created by CarloDB - Wednesday, September 18, 2019 10:50 AM | Last reply by Kameswara Sarma Uppuluri - Friday, October 11, 2019 11:06 AM -
0 Votes
Importing Excel into SQL 2008
However, when I preview it in BIDS, the data shows the IDNUMBER for JOHNSON, JAMES as NULL.Answered | 2 Replies | 5161 Views | Created by MattTheZergling - Wednesday, January 12, 2011 9:08 PM | Last reply by Nik - Shahriar Nikkhah - Wednesday, January 12, 2011 9:28 PM -
0 Votes
Ignore NULL Values in Excel
In Data access mode select sql command and use the following query select EmpId,Ename,Sal from [sheetname$] where EmpId is not ...Answered | 3 Replies | 7199 Views | Created by KIRAN KUAMR - Tuesday, June 21, 2011 3:52 AM | Last reply by Sathish Kumar s - Tuesday, June 21, 2011 6:52 AM -
0 Votes
SSIS 2008 Import Excel 2007 file - metadata error
And still add IMEX=1 to the connectionstring.Answered | 2 Replies | 3765 Views | Created by kayluhh - Wednesday, July 11, 2012 7:41 PM | Last reply by Koen Verbeeck - Thursday, July 12, 2012 6:17 AM -
1 Votes
Excel Source reading issue
Hi Rajesh, If I understand correctly, the first column in Excel contains mixed datatypes (strings and numbers), the string values are shown as NULL in ...Answered | 2 Replies | 1278 Views | Created by Rajesh S Hegde - Wednesday, December 10, 2014 11:31 AM | Last reply by Katherine Xiong - Thursday, December 11, 2014 11:49 AM -
0 Votes
ssis replace NULL value
1:(location=="B"?Answered | 4 Replies | 6252 Views | Created by MS308 - Thursday, August 12, 2010 4:03 AM | Last reply by Sudeep Raj - Thursday, August 12, 2010 9:34 AM -
0 Votes
My date column showing null values when pulling from Excel
Check your excel source if it has valid date data for DateCol2.Answered | 2 Replies | 3125 Views | Created by Spartaa - Wednesday, September 12, 2012 1:40 PM | Last reply by Spartaa - Wednesday, September 12, 2012 5:11 PM - Items 1 to 20 of 3200112 Next ›
No announcements
