March 2, 2014 at 9:46 pm
Hi' am trying to create an ssis package with dynamic csv file as output. and out format containts query output.
sample file name:
Unique identifier + query output + systemdate();
The expression is looking like this.
@[User::FilePath] + @[User::FileName] + ".CSV"
-- user filepath is a variable from ssis package. File name is the output from SQL query. using script task i have assigned the values to @[User::FileName] .
when i debugged the script task the value getting properly but same variable am using for Flafile destination. but its not working.
if any one knows this scenario. please help.
Malleswarareddy
I.T.Analyst
MCITP(70-451)
March 4, 2014 at 11:48 pm
Have you placed this expression in the flat file connecion manager.
March 12, 2014 at 4:06 am
yes. Is not working. If any body knows samples . please let me know.
Malleswarareddy
I.T.Analyst
MCITP(70-451)
March 12, 2014 at 4:21 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply