 | |
ActiveX Script and DTS.Package
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
ActiveX Script and DTS.Package -
05-19-2008
, 04:59 PM
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
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 |
#4
| |||
| |||
|
|
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 |
#5
| |||
| |||
|
|
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 |
#6
| |||
| |||
|
|
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 |
#7
| |||
| |||
|
|
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 |
#8
| |||
| |||
|
|
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 |
#9
| |||
| |||
|
|
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 |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.