Is it possible to create a DTS package using Microsoft Sql server management studio

Is it possible to create a DTS package using microsoft sql server management studio. if yes? How can i do it.

Any help is appreciated.

Regards,

Karen

I'm not sure if it is possible to create a DTS package in SSMS but it is possible to edit and maintain existing DTS packages. The SQL Server 2000 DTS Designer Components are part of the 2005 Feature Pack.

http://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en

I would highly recommend using SSIS for any new development.

|||

Thanks a lot for your answer,

Cause i have couple of spread sheets which i need to import to database from a web based application, and i not sure as how can i import the values from the excel spread sheet to the database..

regards,

Karen

sql