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-07-07 : 10:54:47
|
| Hi Guys, I have a question. Can you use the transfertext command in .Net. Here is my problem:I would like to export a file from a pkg. with a filename that contains a sequence number (i.e. OUTnnnn.TE.txt) where nnnn is the sequence number. I am very new to SQL Server and SSIS and I’m not sure how to accomplish this. If it is not doable in SSIS then I’ll have to export the file, import it into Access, and do a transfertext using a table that stores that latest seq. #? That I can easily do because I know VBA but I would like to use SSIS if it’s possible and not too complicated.ThanxTrudye |
|
|
|
|
|
xfer text command