RE: Run and Edit DTS in SQL Server 2005
- From: Charles Kangai <CharlesKangai@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 6 Oct 2006 03:33:02 -0700
Then you need to open BIDS and create a new SSIS package (right-click on SSIS
Packages folder in Solution Explorer and choose New SSIS Package). You then
need to add the Execute SQL 2000 DTS Package task to the Control Flow tab.
Right-click on it, choose Edit, and you will see that the properties are
self-explanatory. Point to your DTS 2000 package. Run the package by pressing
F5. The SSIS package you just created will then go and execute your DTS
package.
I would still recommend that you do the tutorial though. It only takes a few
hours.
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
email: charles at kangai.demon.co.uk
"Stanley" wrote:
Many thanks Charles. Actually, I'd like to run the existing DTS (SQL2000.
version) in SQL 2005 what should I do? As you said, I don't want to migrate
them to SSIS because I need to save the resource at this moment.
"Charles Kangai" wrote:
If you have migrated the package to SSIS, it's no longer a DTS package but an
SSIS package. Therefore you edit it in BIDS, SQL Server 2005 Business
Intelligence Development Studio, not in DTS Designer. You find BIDS in the
SQL Server 2005 program group.
Best way to migrate your packages from DTS is to save them as files first
(Structured Storage Files) from within DTS Designer in Enterprise Manager.
You can then migrate them to SSIS dtsx files. Note that your packages may not
work as intended because the migration wizard cannot do some things, e.g.
ActiveX scripts that make use of the package object model may not work;
Dynamics Properties task is not supported in 2005.
Best thing to do is learn SSIS. A very good tutorial is installed when you
install SQL Server 2005 - you find it in the SQL Server 2005 program group.
It's a good start.
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
email: charles at kangai.demon.co.uk
"Stanley" wrote:
Hi all,
I've migrated my DTSs to Integration Services but I get an error during the
execution. I've tried to trace the error and edit the DTSs but cannot get in
(no edit menu shown).
Would you tell me where can I get in the edit screen of the DTS?
Many thanks.
- Follow-Ups:
- RE: Run and Edit DTS in SQL Server 2005
- From: Stanley
- RE: Run and Edit DTS in SQL Server 2005
- Prev by Date: Re: SQL 2000 - Connection Error with DTS Packages
- Next by Date: RE: Run and Edit DTS in SQL Server 2005
- Previous by thread: Re: How to Install DTS client without EM in 2000
- Next by thread: RE: Run and Edit DTS in SQL Server 2005
- Index(es):
Relevant Pages
|
