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 |
|
mani99
Starting Member
13 Posts |
 Posted - 2011-08-15 : 13:05:16
|
| Hi,I hope someone can help me with this problem. I need to restore a database back up each day and need to create a script which puts the file name of the latest back up into a variable.For example, the file name could be <name>+<datestamp>.bak, I need the script to put the complete name of the latest back up into a variable.I hope there is a straight forward way of doing this, although I cant seem to find a solution.Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mani99
Starting Member
13 Posts |
Posted - 2011-08-15 : 14:04:48
|
| Thanks for the reply. Not sure that's quite what I need. I just need to get the name of the file into a variable in SSIS which I can then use to perform certain tasks. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Getting the latest file name from a folder