September 13, 2008 at 10:19 pm
Comments posted to this topic are about the item Adding a timestamp to files in SSIS - SQL School Video
Brian Knight
Free SQL Server Training Webinars
September 16, 2008 at 4:56 am
Brian,
Great video! Thanks!
Mark
September 17, 2008 at 2:15 am
Brian,
I'm enjoying these videos, and learning some great stuff, keep them up.
Howard
September 18, 2008 at 1:30 am
Warning! Brian does point out that this technique may be no good if the file name needs to be known at a later stage in the package becuase the time will have changed (eg you need FTP or email the file somewhere), but doesn't explain how to fix this. My solution (I'm no expert though, so there might be a better way), is to create a package-level string variable, and at the start of the package use a script to set the value of the variable to be the required path and file name (including the time stamp). This variable can then be used to create the file and then subsequently for an FTP or email (or whatever) task.
Cheers - Graham
September 18, 2008 at 6:58 am
Brian did show us how to just user the date part for the file name and in most cases that would probably surfice, however, some packages may run into the next day so setting a package variable a the start would be a good idea.
September 18, 2008 at 7:34 am
You're right! If the package runs at 11:30PM and then tries to archive the file at 12:30 AM using my expression would fail for the archive, saying it can't find the file. One way around that is to lock in the expression on a variable instead using the EvaluateAsExpression property on the variable then tie that variable to the file name or by using a Script Task.
Brian Knight
Free SQL Server Training Webinars
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply