Hi all,

Need help in upgradation from SQL Server 2000 to 2005.

I have migrated the DTS packages to SSIS.

My package loads from flat files (data files) to my database.

I am using...

hi..

Mine is a tab delimted file.

Yep We can do by changing the source data or by changing the column ' s datatype.

I have tried this but i dont have the...

hi

Thanks for the reply...

But can you suggest any changes which can be done without adding conversion stage.

Can't change the design...:(

Any idea how this can be done????

Thank you

Archana

hello paul,

Thank you for the lead.I did went through the forum and the link.

Also i would like to know if there is something similar for SSIS?

And what are the other...

hello all..

i am just doing a study about data migration .i am interested to know about

migrating from oracle to sql.

what are pitfalls to look out for?

as in what are...