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 - 2004-01-06 : 11:01:13
|
| Kashif writes "hi all,i need to know that how we can pass parameters to a DTS Packages for Source and Destination File.will we use Dynamic Property object ? IF Yes then how we will configure it THE EXACT Senario is i have a table tblIPUMedCatalog which needs to be update every month from an EXCEL OR CSV file.but each time the file has diffirent name. that is IPUJUNF31IPUFEBF31IPUMARF31 ...i want to give this name to my procedure which call DTS to transfer data from this file to tblIPUMedCatalog plz help me on Kashif@online.web.pkThanks in advance" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-06 : 12:26:53
|
| I have used VBScript in the past to get the dynamic name, then rename it to the name that DTS is expecting. sqldts.com has examples of how to have the file name be dynamic without using the approach that I took.Tara |
 |
|
|
|
|
|
Working with DTS