DTS Packages

DTS Package completes successfully but doesn't run batch file

I have a DTS package that creates and XML file and then FTP's that file to a location. I run the package manually and it works fine. I've created a job for it, run the job and it completes successfully, but go to look and the ftp from the batch file doesn't run. Obviously a permissions issue but...

Migrating DTS packages to SSIS

What is the tool that migrates DTS packages to SSIS, and how effective is it?

Troubleshooting a DTS job failure on SQL Server

I have a DTS job that failed on my SQL Server, but it doesn't have a failed message in the job history. I checked out our DTS package log, and it is empty. How can I troubleshoot this DTS job failiure?

Import SQL Server 2000 DTS package to new box

Hi, I am building the new SQL 2000 SP3 server on Windows 2003 R2, in my old box there were alot of DTS package which is I need to import, my question is what account should I import it as to avoid the security right? in my old box I have 3 admin account only one own the DB whoever, DTS package were...

SQL Server 2005 Upgrade Advisor in a cluster/SAN environment

I installed the SQL Server 2005 Upgrade Advisor so I can analyze our SQL Server 2000 instance and DTS packages. Even though SQL Server 2000 is up and running, it does not recognize our instance when I go to the pull-down, nor does it recognize it when I key in the instance name. We are running on...

Executing DTSX from VB.NET 2003

We converted form SqlServer 2000 to 2005. We had dts packages which were used to import Excel data into the database. We re-created new dtsx packages to replace the old dts packages where they sit on a local drive. Our VB.NET 2003 application used to be able to run the old dts packages but we...

Memory could not be written

I keep getting the following error when I try to Close/Modify the DTS package or close the SQL 2000 (by x-out) on the remote workstation which has Windows XP OS. Application popup: mmc.exe - Application Error : The instruction at "0x4173d22a" referenced memory at "0x02241e90". The memory could...

DTS

Posted - 10/28/2008 : 18:52:31 -------------------------------------------------------------------------------- I am trying to schedule a DTS package . But its says nothing, no error displays and finally it does not execute and hence a job is not created . But when I execute it...

Run scheduled job on SQL Server

we do integrate SQL SERVER woth Oracle database, and its usually work withour problems. the last two days the intgration is not working and the following error displayed in the job history. Cannot create COM Server to load and execute DTS Package. Error -2147221008 (800401F0): CoInitialize has...

Migrating from SQL Server 2000 to SQL Server 2005 on DTS packages

Could someone help me with a SQL Server 2000 migration to SQL Server 2005 on DTS packages? I have a Dynamics GP integration that uses the DTS package, but I don't know SQL or DTS packages well enough.

Spooling Oracle Output via SQL DTS

I am able to execute a stored procedure that resides in a database on an Oracle server via a DTS Package on a SQL Server. I would like to be able to spool the output to a .log file on a different server. Is this possible using DTS?

How to mark a DTS package as complete even if it errors.

I want to be able to mark a DTS package as though it completed, even if a particular task within it errors off. In other words, if a task errors off just because a file doesn't exist, I will email myself (which I know how to do) but I want the package to exit and mark it as 'complete'. The reason...

Extracting information with a DTS package from a database in SQL Server 2000

We currently use a DTS package to extract data from the database and export it in either an XLS file or a TXT file. We now need to be able to export it as an XML file, and SQL Server 2000 DTS functions do not appear to support this directly. How do you recommend we proceed?

DTS Package Schedule runs only once, Status shows executing

Hi, I have set up a DTS Package and schedule it to run every 2 minutes (to prove it will run regularly). Unfortunately the package only runs once. The process only takes a few seconds. The job status shows "Executing Job Step '1 DTS Package1'" Is there something I'm missing? Gabs

Export XML from SQL Server 2000

We currently use a DTS package to extract data from the db and export it in an XLS file, or in some cases a TXT file. We now need to be able to export as an XML file. Since SQL Server 2000 DTS functions do not appear to support this directly, can anyone give us guidance on how to proceed?

Moving a DTS package to SQL Server 2005

I would like to move a DTS package created in SQL Server 7.0 to SQL Server 2005, as we are in the process of migrating the server. Can anyone offer me advice?

Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it

Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it? Hey i have Zip file which i want to extract using the sql script or using DTS Packages. and also want to run the Batch file from DTS Packge. its possible or not ? and yes then how ?

Copying DTS packages from SQL Server 2000 to SQL Server 2005

I am in the process of migrating from SQL Server 2000 to SQL Server 2005. We have several hundred DTS packages. Converting to SSIS will take many months, so we are planning to run the DTS packages under 2005. Is there an easy way, or a utility, to copy the DTS packages from one server to another?