Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
parass
Starting Member
3 Posts |
 Posted - 2008-08-14 : 14:14:27
|
| hi,How would I make a use a variable in ssis and use that in the flat file which will be created each hour. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-14 : 14:29:53
|
| Just add the variable to ssis and then use it to map to file name property of the flat file creation task in dynamic properties tab. |
 |
|
|
parass
Starting Member
3 Posts |
Posted - 2008-08-14 : 16:00:13
|
| Thanks for the reply.. I dont see the dynamic properties tab. Please suggest how to find it |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-08-14 : 17:28:06
|
| 1. click on your flatfilemanager in connection managers pane2. click on properties tab in right hand of the screen3. click on expressions and then on that little button [...]4. that opens the property expression editor5. click in column Property and choose ConnectionString6. click in the right column and enter your desired expression...GreetingsWebfredToo Old to Rock 'n' Roll, Too Young to Die |
|
|
|
|
|
|
variable name as output file name