dbTalk Databases Forums  

Prob with the Fixed Fields Option in the DTS Flat File as connection(Dest)

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


Discuss Prob with the Fixed Fields Option in the DTS Flat File as connection(Dest) in the microsoft.public.sqlserver.dts forum.



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

Default Prob with the Fixed Fields Option in the DTS Flat File as connection(Dest) - 04-17-2006 , 01:23 AM






Hi all,

I am facing one prob with the fixed fields option in the DTS Flat
File as Connection.

When i am try to run the same task with the option delimeted
fields it is pumping all the data from database to the file,but when i
use fixed fields option some of the data is missing.


I have seen that,when we use fixed fields option the data will be
returned based on the column length and basically i had a prob with the
columns with the type integer,float,.. not with the varchar,char. And
it is happening because the int will take 4 bytes so the dts is pumping
upto only 4 chars but the remaining data is not pumped.

Thanks for any help.
Shiva G


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.