July 22, 2005 at 7:08 am
Hey All,
I have a DTS Package that imports data from 3 separate .xls files
into some working tables in DTS.
Because we have 3 environments at work (dev, qa, prod), we use dynamic properties with an ini file for making it easy to move the packages along between "departments".
Anywho. I have several entries in the ini file, 3 of them point to the excel files I will be importing. When I change the data source for one of the excel files to point to its specific entry in the ini file, it changes the data source for the other two excel files automatically.
Any thoughts or pointers?
Cheers
http://twitter.com/widba
http://widba.blogspot.com/
July 22, 2005 at 9:37 am
Zach,
Take a look at this site and see if it helps:
http://www.sqldts.com/default.aspx?103
Good Luck,
Darrell
July 22, 2005 at 10:49 am
Well,
I haven't seen anything there that would work (first place I checked this am).
I guess I will have to setup several dynamic properties for each excel file, it just seems like it shouldn't be necessary.
Cheers
http://twitter.com/widba
http://widba.blogspot.com/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply