Hi Craig Farrell,

Thanks for your response.

I got a oracle table to migrate into sql server.

Oracle Table:

column name:start date

Datatype: Date

Value: 30-OCT-09

i am trying to implement same in sql server...

HI,

i am having the same problem when moving data from oracle to sql.

Could you please post the method solve this issue.

Thank Q

Try to install the backward compatability on sql server 2005,you can able to see the DTS packages in the 2005.