Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-03 : 07:49:17
|
| Ricardo writes "Hi guys,my question is (and sorry for my english):How can i change the File Name in a DTS Excel Connection with a global variable value. I have a Global Variable called ExcelFile that keeps the file name + complete path (ex: c:\dir1\filename.xls). If the file is moved from that to other directory i steel want to use the same DTS just changing the Global Variable.Is it possible to do it like this?Thanks in advance :)RicardoPortugalPS: MS 2000 SP2 + SQLSERVER 2000" |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
|
|
|
|
|
IS IT POSSIBLE? - Changing Excel File Name in a connection with Global Variables 