dbTalk Databases Forums  

dts import not right working when import from flat files dependly of computer

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


Discuss dts import not right working when import from flat files dependly of computer in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
.·:m·a·r·l·a:·.
 
Posts: n/a

Default dts import not right working when import from flat files dependly of computer - 04-29-2005 , 07:50 AM






hello everybody

I have some files csv that for some reason are missing the CR LF at the end
of the last line

I have programed a package that read those files and put them into a table

the isue is that dependly of in whcih computer i run the dts it gets or not
the last record

the dts is just as simple as one file source and destination one of the
tables

In my stationary computer it work fine and get everyline

same dts executed from the laptop execute with sucesfully end but it does
not import the last line

the file is already in a network folder, so the acess to it should be also
the same in both cases

anybody has experience the same isue ??

thansk in advance



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.