• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

DTS Packages and SQL Server 2005 Express Version

Hello Experts,

Can anyone tell me how to open an existing SQL 2000 DTS package in SQL Express 2005? If I can't open them can I at least run them against an instance?

Thanks,

Jack
0
JackW9653
Asked:
JackW9653
  • 3
  • 2
1 Solution
 
nito8300Commented:
Support for SQL Server 2000 DTS Packages in SQL Server 2005 Express Edition

SQL Server 2005 Express Edition does not include Integration Services or support for SQL Server 2000 DTS packages.

To run existing DTS packages on a SQL Server 2005 Express Edition server, you must leave the SQL Server 2000 client tools or the DTS redistributable files on the server, or reinstall them. SQL Server 2005 Express Edition does not include the DTS runtime.

To edit existing DTS packages on a SQL Server 2005 Express Edition server, you must use SQL Server 2000, or edit the packages remotely from a server running SQL Server 2005 Workgroup, Standard, Enterprise, or Developer Edition. SQL Server 2005 Express Edition does not include SQL Server Management Studio or BI Development Studio.

To migrate existing DTS packages to SQL Server 2005 Integration Services, you must use SQL Server 2005 Standard, Enterprise, or Developer Edition. Other SQL Server 2005 editions do not include the Integration Services Package Migration Wizard.

The Import and Export Utility that is included with SQL Server 2005 Express Edition is not the SQL Server Import and Export Wizard and does not use Integration Services.
0
 
nito8300Commented:
text taken from: http://msdn2.microsoft.com/en-US/library/ms143706.aspx

hope this helps,
Nito
0
 
JackW9653Author Commented:
Thanks for the information Nito. I have 8 SQL 2000 DTS packages that handle importing and exporting to our core application from an external application. We have been requiring customers to purchase a server with Small Biz Server 2003 Premium (with SQL Server 2000) and a workstation that access the SQL table for reporting functions. We were hopeful that for some of our smaller customers that we could cut the hardware costs in half by putting everything on a high powered XP Pro workstation and use SQL Express. But if I understand what I read in the article that cant be done with the 2005 Express Edition. The DTS packages do not need be designed in Express, but they need to be bundled with the database. Any ideas?  
0
 
nito8300Commented:
You could develop stored procedures to do your export/import of the data. Not sure how complex your DTS's are but if you're doing simple copy data from you table to the other you can easily run do the same steps with SQL

INSERT INTO server.database.dbo.table1
SELECT FIELD1, FIELD2, FIELD3
FROM server1.database.dbo.table1

Hope this helps.
0
 
JackW9653Author Commented:
The DTS are fairly complex, the data is coming from a remote UNIX via FTP in various comma delimited files and delineated with the 5th character in the filename. Application logic determines which package is called and then an acknowledgement file is sent back to the UNIX and log files are created. All of this is bundled into the DTS package and some triggers on the tables. So rewriting all of that is pretty much out of the question. Thanks for all of your help. Do you know if DTS packages get saved with a database during a backup?
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now