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
 SSIS and Import/Export (2005)
 Output to Raw File destination problem

Author  Topic 

matnyc2000
Starting Member

16 Posts

Posted - 2007-07-05 : 15:24:30
Hi,

I'm trying to output the results of a query straight into a raw text file. The problem I'm facing is that the tool seems to write some unwanted characters at the top of the file and within it. For example, I get the name of the column that was used as input at the top of the text file:

[] [] <<name of column>> [] []

I need to have a clean file containing strictly the results of the query.

Any ideas?

matnyc2000
Starting Member

16 Posts

Posted - 2007-07-05 : 16:00:08
Ended up using flat file destination instead with delimited width and works fine, no extra codes or text.
Go to Top of Page
   

- Advertisement -