SSIS Activex Script Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

SSIS Activex Script Error

Author

Topic

sourvil
Starting Member

14 Posts

Posted - 2009-02-08 : 04:32:33

Hi my friends,
I want to extract an xml file to database. And my code was running well in Sql 2000 dts.
When i migrate it to Sql 2005 .dtsx, my code does not work! And i can't solve the problem.

Here is the only beginning part of the script (because i commented out other codes and still getting this error) :
-----------------------------------------------------------
Function Main()
Dim objXMLDOM
Dim objNodes

SET objXMLDOM = CreateObject("MSXML2.DOMDocument.4.0")

objXMLDOM.async = False
objXMLDOM.validateOnParse = False

objXMLDOM.Load "C:\testorder.xml"

SET objNodes = objXMLDOM.selectNodes("Orders/Order")

Main = DTSTaskExecResult_Success

End Function
-----------------------------------------------------------

Error :
-----------------------------------------------------------
[ActiveX Script Task] Error: Retrieving the file name for a component failed with error code 0x1C147788.
-----------------------------------------------------------

Please help,

Regards..

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-08 : 07:21:26

http://support.microsoft.com/kb/316005

sourvil
Starting Member

14 Posts

Posted - 2009-02-08 : 07:36:23

Hmm thank you very much for help, i searched it on google and solved my problem by installiing "Msxml 4 sp2" and changing

SET objXMLDOM = CreateObject("MSXML2.DOMDocument.4.0")

to

SET objXMLDOM = CreateObject("MSXML2.DOMDocument.6.0")

And it worked, but now i have another problem at the same script task. Script is below, and i think i should also install another .dll or anything for "ADODB.Connection"?

-----------------------------------------------------------------------------------------------------------
Function Main()

Dim objADOCnn

SET objADOCnn = CreateObject("ADODB.Connection")

objADOCnn.Open "PROVIDER = SQLOLEDB;SERVER=10.10.1.10;UID=sa;PWD=123test??;DATABASE=testdb;"

Main = DTSTaskExecResult_Success

End Function
-----------------------------------------------------------------------------------------------------------

Regards..

sourvil
Starting Member

14 Posts

Posted - 2009-02-08 : 07:43:41

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources