We help IT Professionals succeed at work.

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.
Comment
Watch Question

My GUESS based on the provided message "The product Level is insufficient for componet "Flat File Destination", SSIS Error Code DTS_E_ProductLevelToLow. " is that you are running a version of SQL that doesn't support what you're doing.  Like maybe it requires standard and you're using Express.  Or Enterprise/Standard.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.