Link to home
Start Free TrialLog in
Avatar of jc50967w
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)MONTH( 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.
ASKER CERTIFIED SOLUTION
Avatar of BrandonGalderisi
BrandonGalderisi
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial