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 - 2002-03-20 : 09:42:40
|
| David writes "I have a file that is called "File_20020315.xls" The date in the file name changes everyday. How can I make a DTS Package that will allow for the DTS Source file name to change to name of file and current date." |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-03-20 : 10:38:59
|
| I know it's possible, but I don't know how to do it. What I usually do in instead in this senerio is to make two copies of the import file. Copy one with the full name "File_20020315.xls" to a storage directory, then make a copy in a processing directory with generic name like "ImportFile.xls". Then you can over write that file every day. This is also nice if there is a problem and an old file needs to be reimported, you can just copy it from your storage dir to your processing dir, change the name, and fire the package with out any modifications. It's a good idea to delete the file from the processing dir after it's been processed to make sure you do not hit it again if a new file doesn't showup the next day. If none of that sounds appealing, they should be able to help you out over on [url]http://www.sqldts.com[/url].Jeff BanschbachConsultant, MCDBAEdited by - efelito on 03/20/2002 10:39:45Edited by - efelito on 03/20/2002 10:40:13 |
 |
|
|
KHeon
Posting Yak Master
135 Posts |
Posted - 2002-04-23 : 07:39:34
|
| Please see my reply in this thread:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=15151[/url] as I discuss my solution to something similar.Thanks!Kyle HeonPixelMEDIA, Inc.Programmer L2kheon@pixelmedia.com |
|
|
|
|
|
|
DTS Source file name has date in it How to import