Hi

I created a new project in BI of SQL Server 2005, a DTS package importing
tables from SQL Server 2000, From BI i am able to execute, works fine. If
i goto Management studio i coultn't find DTS package.

How to execute DTS package developed as project in BI in stored procedure.

I am new to SQL Server 2005, In SQL Server 2000 i used to execure dtsrun
using command shell.

Any one help me

thanks

You have created the package on the developer workstation only. The server
does not yet know about it. The project and package(s) need to be deployed
and installed on the server. For instructions of how to do this, please look
at the Integration Services tutorial at
http://msdn2.microsoft.com/en-us/library/ms365338.aspx

Charles Kangai, MCT, MCDBA

Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm



"Kalyan" wrote: