hey sarg3 i think it can be easily done by turning on the flag in flat file source editor where u haqve an option return nulls if you check ...

hey george what do u mean by that ,....when u open the package in vs it gets executed is that so....if so plz let meknow where can i set that...

hey micheal how coudl i know the performance ....is it the time it gets executed or is there any other aspects which i need to consider...plz let me know...

hey patrick if u need to add an additional column other than from the excel u can use derived column ...if u go tit tast fine if not let me...

hey antaress can i know the setting which allows the record to get imported because i know two option one to redirect the error rows and the other to ignore...

try using the same import /export wizard setting the destination to oledb provider for oracle and set the servername ...but i am not sure regd this...jus provide me sample rows...

is allow drop shio the first column of the table and plz post me some sample data.... u can mail me to kurraraghu@gmail.com if it contains something which cannot be...

allow_drop_ship column has the error with truncation ...so if you want to see the rows which makes you cause the error jus go to the source and click on error...

hey if that is the case could you please post me some sample rows so that i can have a look and let you know...what ever may be the source...

try changing the odbc datatype to nrachar(max) or make sure that both the datatype match ...bcoz here when the source column is of lenght 50 and you have a...

[DataReader Source [1482]] Error: The "component "DataReader Source" (1482)" failed because truncation occurred, and the truncation row disposition on "output column "ALLOW_DROP_SHIP" (1684)" specifies failure on truncation. A truncation error...

actually they are ragged right format and i dont the exact width so thats the reason ic ouldnt set it exactly

thkz look up i tried it the same way it worked for certain rows then i got this error

SSIS package "Package1.dtsx" starting.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase...

dude i got a problem here again in my first row it has values as

asbabs 1221 dd323 00 3232 fdfd

dsadsd 3233 dfd32 00 3321 dsd n

dcfcdc...

Thkz Dude....