Re: SQL 2005, DTS, problems, problems, problems, etc..

Hello Roz,

In defence of the Legacy framework I am not having the same problems as yourself. That does not mean though that it is not painful for you. Personally I will not be opening too many 2K packages in 2K5. I will be using the Execute 2000 Package task and leaving it at that. I will also not be doing too many upgrades, I will redo them from scratch do I can ensure best practices and therefore quality in the 2K5 version of the package.



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Is anyone else out there having problems with SQL 2005
opening/editing/saving SQL 2000 DTS packages...even with the Backward
compatibility/2000 DTS Components installed? Specifically, after
installing these two downloads, I can Open a DTS 2000 package, but
when opened, the icons/graphics are displayed crazily. Even after
"cleaning up" (ie remapping columns, editing source/destination
connections); when I try to save the newly edited package, I get a
"The DTS host failed to open or save the package properly" error
message.

The benefit of continuing to use DTS 2000 packages in SQL 2005 is
greatly appreciated, but I'm not too certain all the bugs were
addressed and resolved. Microsoft, if you're listening, please
respond with a "solid" solution on how to get this resolved. I've
bent over backwards trying to sell my company on this upgrade, but so
far we've encountered nothing but roadblocks, and I've got major eggs
on my face. With the great help of Allan Mitchell; I've been able to
navigate the rough edges, but it shouldn't be this way. Just to add,
my staff and I are very versed in SQL Server, are certified MCDBAs;
and aren't just venting misguided frustrations here. Our
problems/issues are valid and legitimate, so I'd strongly appreciate
some help.

Hopeless and Semi-Helpless in San Antonio,

Roz



.

Relevant Pages

  • Re: DTSRun and Batch file
    ... >> install the DTS DLLs on the local machine. ... So the DTS package is running ... >> user to start a SQL Agent Job that runs the package. ... Darren Green (SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: Error when running SQL 2000 dts Package in SQL Server 2005
    ... Lotus SQL Driver works fine. ... created a package in SQL 2000 and trying to call it in SQL 2005'S Legacy Data ... I am able to create a new table using this DTS ... OK so if this fails when you use the package in an Execute DTS 2000 Package ...
    (microsoft.public.sqlserver.dts)
  • Re: Scheduling DTS Packages on 64-bit SQL Server
    ... My understanding is that DTS components are not available for 64-bit SQL ... > I found the following comment on Microsoft's website in regards to scheduling> a DTS package on a 64-bit SQL Server installation. ... do I need> to buy a 32-bit copy of SQL Server to store my packages on to be able to> schedule them? ...
    (microsoft.public.sqlserver.dts)
  • Error invoking a DTS package remotely
    ... I ran into a problem invoking a DTS package from a different machine. ... invoke the package from another machine with only sql 7 on it. ...
    (microsoft.public.sqlserver.dts)
  • RE: Sheduling DTS-Packages in SQL2005
    ... If you have downloaded and installed the SQL 2005 Legacy Components (should ... also be on the install medial) you should be able to manage, edit, and run ... To schedule the package, create a stored procdure wrapper that executes the ... T-SQL syntax for executing DTS.) ...
    (microsoft.public.sqlserver.dts)