ActiveX Script and DTS.Package

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Greetings,

We have a new SQL 2005 x64 sever that runs an export which uses DTS (from 2000). One of the steps in an ActiveX script which is failing on the line:

Set oPkg = CreateObject("DTS.Package")

We get error 800A01AD when scheduled or interactively. I think this is a 32- vs 64-bit issue as I can run the script manually using c:\windows\syswow64\cscript.exe.

What DLL(s) is responsible for implementing CreateObject("DTS.Package"), from where is it installed and is there a 64-bit version I can register? Client tools, legacy support, SSIS, and SQLServer2005_DTS.msi are installed, FWIW.

This is a 3rd party app, so upgrading the DTS to SSIS is not possible (for us).

Thanks,

ajs
.

Relevant Pages

  • Re: SSIS on 2005 sql server behaves differently than DTS on 2000 sql s
    ... It's been a few years since I made the transformation from DTS to SSIS, but what I remember is that SSIS is quite different from DTS, even though they target the same task. ... 1.The text source file opened with editors like Notepad, Wordpad, Word, ... TotalCMD doesn’t show any delimiter. ...
    (microsoft.public.sqlserver.dts)
  • Re: copy column through active x script
    ... SSIS packages to do data import because, SSIS would not allow me to specify ... DTS 2000 is so much easy to use and import data. ... need to check for invalid characters while DTS package export data from TXT ... Add Flat File connection manager pointing to file. ...
    (microsoft.public.sqlserver.dts)
  • Re: Primary key error handling SSIS
    ... ssis does not appear under the Enterprise Development newsgroup, ... often referred to as dts. ... cannot handle the PK constraint error? ... Are there any better methods than a staging table to cleanse the data? ...
    (microsoft.public.sqlserver.dts)
  • Re: Help understanding SSIS !
    ... SSIS is a very different beast to DTS and some of the thought processes need to be rethought also. ... I have several dts packages that are simply vbscripts that I want to ... I was able to create a package be dropping an Active X script Task ...
    (microsoft.public.sqlserver.dts)
  • Re: Sql 2005 express edition information
    ... > Dunno what SSIS is yet... ... SSIS (SQL Server Integration Services) is the successor of DTS. ...
    (microsoft.public.sqlserver.security)