dbTalk Databases Forums  

Error creating flat file - no CRLF

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Error creating flat file - no CRLF in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
cs_hart@yahoo.com
 
Posts: n/a

Default Error creating flat file - no CRLF - 09-15-2008 , 01:09 PM






I am trying to export the results of a query to a flat file. When I
run the package I get all the rows in a single record - there are no
CRLFs.
On the Configure Flat File Destination panel, the Row delimiter and
Column Delimiter selections are disabled.

I don't know if this has anything to do with it, but on the help
below, it states that the first field on the panel is titled "Source
flat file" - on my panel is is "Source Query"
http://msdn.microsoft.com/en-us/libr...4(SQL.90).aspx

Any help appreciated.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.