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 |
|
Trudye
Posting Yak Master
169 Posts |
 Posted - 2008-03-25 : 09:37:02
|
| Hi Guys, got a question that I'm not sure there is an answer to other than 'No Way'.I have to export a file whose filename must include a sequence number. I have created the table to hold the seq# and the code to increment it. My problem is how do I include the seq# in the output filename. I am using the Flat File Destination tool for exporting. should I be using another tool?Any suggestions?Thanx,Trudye |
|
|
stephe40
Posting Yak Master
218 Posts |
Posted - 2008-03-25 : 15:19:26
|
| I would imagine you are going to have to use a script object to lookup the sequence number, and programatically change the destination file name of your flat file connection manager.- Eric |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-25 : 15:21:36
|
| You can declare 2 variables in your SSIS package to hold the file name & seq#. The filename property fordestination connection will be set to Filename variable + seq# variable. You can use a Execute SQL task to get values of seq# variable. |
|
|
|
|
|
|
Add seq# to filename