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 |