March 24, 2010 at 5:57 am
Hi I have a problem with adding variable arguments in SSIS process task.
I want to transfert a file from a directory to another(sftp). but the name of the file is not static. we have to create each day another file with the date of the day. like NAME_24032010
i can't add a variable argument .
What i try to do exactly :
WINDOWS COMMAND WITH PASSWORDS \\FileDirectory\+
"PARTOFNAME_"+RIGHT("0"+(DT_STR,2,1252)DAY(getdate()), 2)+RIGHT("0"+(DT_STR,2,1252)MONTH(getdate()), 2)+(DT_STR,4,1252)YEAR(getdate())+".csv"
While i execute statically it works :
WINDOWS COMMAND WITH PASSWORDS \\FileDirectory\NAME_24032010.
can anyone help me ???
March 24, 2010 at 7:24 am
Where are you trying to do this? Directly in the property field?
To use variables in your arguments, you must set the argument through an expression.
See the the third tab Expressions in the edit window.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 24, 2010 at 3:57 pm
Try using your SQL as part of expression and Use that Variable as your source in OLE DB source/ execute SQL task.. That way you will be able to see your complete SQL and Validate it at the same time..
March 26, 2010 at 1:47 am
divyanth (3/24/2010)
Try using your SQL as part of expression and Use that Variable as your source in OLE DB source/ execute SQL task.. That way you will be able to see your complete SQL and Validate it at the same time..
That just doesn't make any sense. This thread is about the SSIS Execute Processing Task.
Unless you're trying to say to 'debug' the variable expression through an OLE DB source or Execute SQL Task. In that case, I think BIDSHelper provides more elegant solutions.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply