dynamic file name in DTS
-
I am trying to create file name on fly in DTS using excel spreadsheet.
To do that iam setting the file name as given below but its just taking one name all the time.
conn.datasource = ID_mmddyyyy_filename
Can any one suggest what could be the problem? I spent more then an hour for such a silly thing but could not find any solution.
Thanks in advance.
-
Take a look at the article over here http://www.sqldts.com/default.aspx?200
This is for text files, but the Excel connection works the same. Just replace the part that reads '("Text File (Source)")' with the name of the connection you're trying to modify.
EG: Set oConn = DTSGlobalVariables.Parent.Connections("MyExcelFile")
--------------------
Colt 45 - the original point and click interface
-
Is this a question about DTS or SSIS? It seems strange that you would post a quetion about DTS in this forum that's all.
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply