Migrating DTS packages that use mainframes source to SSIS
I am trying to migrate DTS 2005 packages to SSIS. The packages that has SQL data source is migrating around 60% but the packages having mainframes (AS400/DB2) data source is migrating only 10% what is the reason? and How to get this problem resolved?

Answer Question   |  April 12, 2010  6:26 AM
AS400/DB2 source, DTS Migration, DTS package, DTS packages, SQL Server Integration Services, SSIS, SSIS 2005

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 [...]

Answer Question   |  June 12, 2009  3:22 PM
Batch files, DTS Package Errors, DTS packages

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

Answer Question   |  April 8, 2009  8:25 PM
DTS packages, SQL Server, SSIS, SSIS Package

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?

Answer Question   |  February 4, 2009  6:40 PM
DTS, DTS packages, SQL Server DTS

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 [...]

Answer Question   |  January 16, 2009  10:40 PM
Data Transformation Services, DTS packages, Import DTS packages, SQL Server 2000, SQL Server 2000 import/export, SQL Server 2000 migration, Windows Server 2003

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 [...]

Answer Question   |  December 4, 2008  3:22 PM
Cluster, DTS packages, SAN, SAN/CLuster Environment, SQL Server 2000, SQL Server 2005, SQL Server 2005 Upgrade Advisor, Windows Cluster

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 [...]

Answer Question   |  December 16, 2008  8:26 PM
DTS, DTS packages, DTSX, Excel import/export, Microsoft Excel, SQL Server 2000, SQL Server 2005, SQL Server upgrades, VB.NET 2003

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 not be “written”. Please help !!! Thanks.

Answer Question   |  November 14, 2008  5:34 PM
DTS packages, SQL Server 2000, SQL Server errors, Windows XP

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 immediately it is executing so . What is the problem here .Any suggestions .

Answer Question   |  October 29, 2008  11:55 PM
Data Transformation Services, DTS packages, SQL Server DTS

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 not been called. Process Exit Code -2147221008. The [...]

Answer Question   |  October 27, 2008  6:20 AM
COM server, Database interoperability, DTS packages, Error 2147221008, Oracle interoperability, Runtime Errors, SQL Server 2000, SQL Server errors, SQL Server interoperability

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.

Answer Question   |  December 9, 2008  7:57 PM
DTS packages, Dynamics GP, Microsoft Dynamics GP, SQL Server 2000, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server migration

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?

Answer Question   |  October 16, 2008  4:09 PM
DTS packages, Oracle, Oracle Output Via SQL, SQL Server, Stored Procedures

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 [...]

Answer Question   |  September 18, 2008  8:33 PM
DTS packages

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 [...]

Answer Question   |  August 31, 2008  3:52 PM
DTS packages, SQL Server 2000, XML

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

Answer Question   |  August 21, 2008  5:43 AM
DTS, DTS packages

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 [...]

Answer Question   |  August 19, 2008  6:36 PM
DTS packages, SQL Server 2000, XML

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?

Answer Question   |  September 9, 2008  4:15 PM
DTS packages, SQL Server 2005, SQL Server 7.x

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 [...]

Answer Question   |  July 17, 2008  8:27 AM
Batch files, DOS Batch, DTS packages, SQL scripts

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 [...]

Answer Question   |  June 24, 2008  7:11 PM
DTS, DTS packages, SQL Server 2000, SQL Server 2005