April 11, 2005 at 6:05 pm
I'm trying to create a dts package that will pump data from excel file to sql server using the data transform task. For the source file, I need to specify the path and the file name from the source connection. But this package needs to run several times a week.
For example:
day 1 will pump test1.xls from C:\test1.xls
day 2 will pump test2.xls from C:\test2.xls
day 3 will pump test3.xls from C:\test3.xls
I can't just change the filename in the source connection everytime in the package. So, what can I do to get around with this. Write activeX script? I really have no idea
Please help. Thanks
April 11, 2005 at 7:08 pm
Take a look at the examples over at http://www.sqldts.com
--------------------
Colt 45 - the original point and click interface
April 12, 2005 at 7:49 am
Look into the article
http://www.sqlservercentral.com/columnists/djackson/importingthelatestfileinafolderviadts.asp
Hope this helps,
Shyamala.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply