Is it possible to write to a file in the ActiveX props in DTS? I was
thinking of the FileSystemObject, but am not sure. I've looked on
sqldts.com, and see that I can create, delete, move, check attributes, etc.
But I dont see any way to write to a file. Possible?


TIA, ChrisR

Sure you can write to s file using VBScript and the FSO but why?

What about the DataPump task does not do it for you?

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"ChrisR" <noemail (AT) bla (DOT) com> wrote

Its was a very, very long story, but I just found a workaround anyways.
Thanks.


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Chris, let us know the work around you used it might be a helpful tip.

"ChrisR" wrote:

The problem was that I was getting ugly characters in my text file. Becuase
of that I couldnt use the Data Pump and was looking into FSO to remove the
ugly guys. However, I renamed my file to have a .txt extension and the
characters are no longer seen in SQL.


"Leonard" <Leonard (AT) discussions (DOT) microsoft.com> wrote