Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DTS - use global variable value for Excel file name
Message
 
To
28/05/2008 14:09:06
Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada
General information
Forum:
Microsoft SQL Server
Category:
Scripting
Environment versions
SQL Server:
SQL Server 7.0
Miscellaneous
Thread ID:
01319943
Message ID:
01320083
Views:
15
This message has been marked as the solution to the initial question of the thread.
Hi,

Perhaps the article entitled "Looping, Importing and Archiving" can shed some light on a technique of reading file names from a GV.

Also, "Read File Tranformation" may contain some pointers.

Again, these will not address your situation specifically, but you may be able to glean some techniques from them and adapt them accordingly.

HTH
Vince
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform