Link to home
Start Free TrialLog in
Avatar of earwig75
earwig75

asked on

Create dynamic file name for flat file destination

I want to create a file name for each day that contains a date in my flat file destination with SSIS on MS SQL 2008. Something like 09192012_filename.txt. I want the file to be named dynamically each day.

Can someone walk me through this?

Thanks.
SOLUTION
Avatar of Saurabh Bhadauria
Saurabh Bhadauria
Flag of India 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
ASKER CERTIFIED SOLUTION
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
SOLUTION
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