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.

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:

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:

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:

Charles,

Sure, we've the schedule to migrate all DTS to SSIS but the run DTS in
SQL2005 is the work arround solution. However, I have one more question; may
I execute the DTS in Windows Command Prompt, even the DTSs are moved to SQL
2005? If so, how to execute?

Thank you very much.

Stanley

"Charles Kangai" wrote:

Use dtexec.exe to execute SSIS packages. Here is a sample command line:

Dtexec /File "c:\MayPackages\ImportWordDocs.dtsx"


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: