How to change big SQL script to DTS packague?

[Jozopiso]

Hi,

i need to change Update script of company recruit database to any kind of DTS packague...i'm absolutely new in this area, so any possibilities and solutions are very aprecciate. Actually i need just idea how to start..

This update script contains all creates,inserts and updates of database...6000 rows.

Thanx

 

[dbomrrsm]

Create a package - create a connection then select a SQL Task and select based on a query then paste your code in.

[blue]DBomrrsm[/blue]

 

[Jozopiso]

I understand all this begining processes...my trouble is to divide, reconstruct that Update script into tasks-objects which are used by DTS. Connection is between access DB and MSSQL, i need to transfer migrating files from Access to MSSQL and run this script using DTS packaques during this migration. Script needs to be reconstruct into DTS desing.

thank you very much for your patience

j.