Wednesday, February 15, 2012

execute dts 2000 packgage under sql 2005

hello world,

i read some kb on msde that explain how to do the task in the title, but in sql 2005 client tool i can't see where to execute dts packgage in 2000 mode,

I don't think you can do that with client tools because SSIS(sql server integration services) is a service like the Agent and SQL Server service. I have got you the eval but try and get the developer edition it cost a few dollars online. The first link covers what you are looking for the second is eval software. Hope this helps.

http://www.databasejournal.com/features/mssql/article.php/3615516
http://www.microsoft.com/sql/downloads/trial-software.mspx

|||

Hi,

Do you need to know what problem will happen when you run a SQL Server 2000 DTS package after you upgrade all the SQL Server 2000 instance to SQL Server 2005?

If so, the following KB article will be helpful.

http://support.microsoft.com/kb/919131/en-us

No comments:

Post a Comment