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.
jc50967wAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BrandonGalderisiCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.