jc50967w
asked on
Failed to generate a dynamic flat destination in SSIS package
Hi, experts,
I am working on a SSIS pacakge. Source is DB2 and Destination is a Flat File. I want to dump daily data (Yesterday's data) into the flat file, and name the flat file with Yesterday's date at same time, for example, today's file name is Data_2008-01-27.txt (for yesterday's data). In another word, The flat file name should be changed dynamically when the package runs daily.
the error message I got after I ran the dtexec in DOS command window for test purpose is followings:
"The product Level is insufficient for componet "Flat File Destination", SSIS Error Code DTS_E_ProductLevelToLow. "
The code I uesed as flat file connect string to connect and generate file name in Flat File Connection Manager is followings:
@[User::flatFileDir]+"Prov _Portal_"+ (DT_STR,4, 1252)YEAR( DATEADD( "dd", -1, getdate() ))+"-"+(DT_STR,4,1252)MONT H( DATEADD( "dd", -1, getdate() ))+"-"+(DT_STR,4,1252)DAY( DATEADD( "dd", -1, getdate() ))+".txt"
The code above is correct when I evaluated the Expression. but I saw NO file created in the directory of my application server during the test.
I am working on a SSIS pacakge. Source is DB2 and Destination is a Flat File. I want to dump daily data (Yesterday's data) into the flat file, and name the flat file with Yesterday's date at same time, for example, today's file name is Data_2008-01-27.txt (for yesterday's data). In another word, The flat file name should be changed dynamically when the package runs daily.
the error message I got after I ran the dtexec in DOS command window for test purpose is followings:
"The product Level is insufficient for componet "Flat File Destination", SSIS Error Code DTS_E_ProductLevelToLow. "
The code I uesed as flat file connect string to connect and generate file name in Flat File Connection Manager is followings:
@[User::flatFileDir]+"Prov
The code above is correct when I evaluated the Expression. but I saw NO file created in the directory of my application server during the test.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.