Failed to generate a dynamic flat destination in SSIS package
Posted on 2008-01-28
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.