dbTalk Databases Forums  

DTS export

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


Discuss DTS export in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Harbinder Bansal
 
Posts: n/a

Default DTS export - 05-16-2005 , 01:25 AM






Hi, I have strange problem in that I'm exporting data into a text file -
which works fine but it is generating an additional blank record at the end
of the file. This file is being fed into another program which doesn't like
additional line. I've tried changing the "row" delimiter but still have the
same problem. Any know how to fix this?
Any help would be much appreciated.



Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: DTS export - 05-17-2005 , 12:58 AM






There shouldn't be an extra line generated. Have you checked the
source? Have you let it create a new file for you instead of reusing an
existing one?

"Harbinder Bansal" <harbinder.bansal (AT) blueyonder (DOT) co.uk> wrote


Quote:
Hi, I have strange problem in that I'm exporting data into a text file -
which works fine but it is generating an additional blank record at the end
of the file. This file is being fed into another program which doesn't like
additional line. I've tried changing the "row" delimiter but still have the
same problem. Any know how to fix this?
Any help would be much 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.