"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:
>
> > 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.