i want to create a variable in SSIS that contains a date. The format is "/vaftp1/NewFile/data/2014-06-08 02;01;38 (Full).zip" , "/vaftp1/NewFile/data/2014-07-08 02;01;38 (Full).zip", "/vaftp1/NewFile/data/2014-08-08 02;00;42 (Full).zip" this file will dump on ftp site every day and I want to unzip it. so my question is I created a variable "/vaftp1/NewFile/data/"+ (DT_WSTR, 20) (DT_DBDATE) GETDATE()+?????????????()+""(full)"+".zip" but its not working.i don't know want to ignore ??????? . all i want is to get the date + anything(means the time)+(full)+.zip like for word we say (*.txt)to get any thing end by .txt so please help me
asked Aug 08, 2014 at 02:24 PM in Default
This might help. It shows how to gather a list of files in a folder and check a date in the file. You ahould be able to adjust it to suit your situation.
answered Aug 08, 2014 at 03:40 PM
I usually set variables like this with a script task. You'll need to declare two variables, one to hold the template string and one to hold the actual string that you want to use:
User::MyDateStringTemplate = "/vaftp1/NewFile/data/<<-PLACEHOLDER->>(full).zip"
User::MyDateString = "Whatever, it doesn't matter"
Pass MyDateStringTemplate in as a read only variable, pass MyDateString as read/write.
Air code example:
Edit - doesn't like angle brackets for some reason?