Create DTS Package in SQL server 2005 (Ver:9.0.1116).

Hi,
I am using SQL server 2005 (Ver:9.0.1116).
I am unable to find how to create a DTS package from Sql Server Management Studio.
It is showing "DTS 2000 Packages" in the "Object Explorer" of the Sql Server Management Studio.
I want to know how to start a Integration services in Yukon.
As,the DTS 2000 Packages in the Services tree does not Open nor can Import any package.

Thanks!
TechFreakYou need to use the "Business Intelligence Development Studio" to build SQL Server Integration Services (SSIS) packages, not SQL Server management Studio.

Go to: Start-->Programs-->Microsoft SQL Server 2005-->SQL Server Business Intelligence Development Studio

This is all in the documentation (Books Online) so look in there, and in the tutorials, to see how to go about building your first package.

-Jamie|||Yeah Jamie,

Thanx for the concern..

But using "Business Intelligence Development Studio" also it shows an error message as below:

"Could not load file or assembly 'Microsoft.DataTransformationServices.Wizards' or one of its dependencies.The System cannot find the file specified"

In the Yukon tutorials there is no info provided for Integration Services.

-TechFreak|||

Does anybody has a solution for this? I am getting the same error. I have Visual Studio 2005, SQL Server 2005 (Developer Edition) on Windows 2003 machine. I was trying to create an Integration Services Project, but getting the above error. Please help!

Thanks

|||

even i am getting the same error, any help regarding this ?

Thanks

http://techyfreak.blogspot.com

|||You have to be sure that SQL Server Integration Services installed on your PC.
To check go Help -> About Microsoft Visual Studio.

I got the same error after reinstalled MS Visual Studio 2005 from default location
C:/Program Files/Microsoft Visual Studio 8 to D:/Program Files/Microsoft Visual Studio 8
due to insufficient disk space on C.

SQL Server Integration Services just disappeared from installed list.
I was trying repairing VS from CD. Did not help.
I had to uninstall VS from D to C drive again and leave MSDN on D. After I could start Integration project again.
Why this happened I do not know. May be because MS SQL Server 2005 was still on C drive. Not sure.

I hope this help.