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.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 xfer text command

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.

Thanx
Trudye
   

- Advertisement -