• 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?

    JHM5 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error when using Microsoft OLE DB for Oracle in DTS Package

    I have a DTS package that use the MS OLE DB provider for Oracle. The DTS package executes stand alone; but when placed in a schedule job, it won't run. This was working; but quit after I had detached some databases to copy them. After re-attaching them, the jobs would no longer run. I have logged...

    Randym1,740 pointsBadges:
  • 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...

    Bjet55 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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...

    MISProg5 pointsBadges:
  • Call DTS from java

    Please help us whether we can call DTS directly from Java.Solution which we got as below:-1. Create dts2. Create job in which we have to call dts3. Call job from stored procedureIt pretty lengthy process and we are not sure how error handling can be done in this scenario.Request all to help with...

    yyogesh10 pointsBadges:
  • 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?

    Jwalini5 pointsBadges:
  • SQL DTS package scheduling

    When a DTS package is scheduled to run at a specific time of day, is it done through the use of a stored procedure or a job?

    Gic5 pointsBadges:
  • 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...

    Bleeb45 pointsBadges:
  • My DTS package runs normally, but hangs when run as a SQL Job

    Hi, I'm trying to run an Ms Access .mbd file through a MS SQL 2003 Server. The package runs normally and works when I start the job, but simply hangs when I run the package as a a scheduled job. I've designed a DTS local package as follows:...

    Dring575 pointsBadges:
  • Migrating DTS packages to SSIS

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

    SQL Server Ask the Experts2,585 pointsBadges:
  • Creating DTS package for Linked Server database

    There is a linked server database for which packages are to be created using DTS wizard. Please can anybody help me by telling how to create packages. Thanks

    TaraKeshwari5 pointsBadges:
  • 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...

    Bjet55 pointsBadges:
  • 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...

    BClawson10 pointsBadges:
  • 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.

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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 a...

    Trig15 pointsBadges:
  • 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...

    Metro1725 pointsBadges:
  • 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...

    Kmadani35 pointsBadges:
  • 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?

    Broskek5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following