How to create a DTS package in 2005

I am 100% new to SQL. I have used Access for ever. I need to know how to take a Access 2003 database and covert it over to SQL 2005. I have no idea how to complete this. I was told to do a DTS package but I do not see any options for this.

Any help would be great!

Thank you

hi,

DTS is now known as SSIS pacakage

you can create a new database in sql management studio

after creating a new database. you can right click the database

and then click on task. then clcik import data.

choose microsoft access as a data source.

near the end of the wizard is an option to

execute immedietely and "save to SSIS package"

clcik the desired option and then click next.

to creat a package manually.

open microsoft visual studio 2005 then clcik on

file>new>project>business intelliegience project>integration service project

enter the project name and click next

regards,

joey

|||Thank you! :-)