Excel Data not seen in Source Preview - 03-18-2005 , 08:25 AM
I have a DTS package where in i am pushing data from Excel to Sql server
When i look at preview of the source (i.e Excel ) in Transform Data link ,
the data from the excel is not shown in VIEW DATA grid.
What could be the reason ?
Re: Excel Data not seen in Source Preview - 03-18-2005 , 09:22 AM
Are you using a query or a labeled section within the excel spreadsheet?