Groups | Blog | Home
all groups > sql server dts > april 2006 >

sql server dts : Unable to load multiple Excel file


Kavi
4/5/2006 11:51:01 AM
Hi
I was trying to load a few excel files into the database. I was using the
ForEach Loop functionality using the SQLIS 2005. I followed this article that
explains the load of text files
http://www.sqlis.com/default.aspx?55

I made the transformations by using a static Excel file. Then when I use
the Expressions as specified in the link to the Excel File, the name of the
file disappears. So when you execute the package, it fails to upload the
Sheet.

Is there an issue loading multiple Excel files?. We were able to load
multiple text files in the same directory. It's only when loading the Excel
files. Any ideas ?
Thanks
Allan Mitchell
4/5/2006 12:52:08 PM
Hello Kavi,

Yes there is. I have reported this (I think).

Bug with XLS source and expressions... The ExcelPath property needs to be
defaulted to a valid path OR turn on DelayValidation on the respective DataFlow
task.


I know of a few others who have had this issue


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]

AddThis Social Bookmark Button