need to import & map data , is a cursor the best way?

[bebblebrox]

Hello,

I have a ton of data that i need to import from one table to another database where the data will be split across multiple tables. additionally, the data needs to converted because whereas in the one table a column may be text, on the insert an id for that text value will be inserted.

In Oracle, I would use a cursor. Is this how I should proceed in SQL Server? I realize that cursors generally = bad, but since this is a one time shot, I'm not overly concerned with the load it will put on the server.

 

[JayKusch]

Sounds like a job for DTS

Thanks

J. Kusch