September 20, 2010 at 5:05 pm
Hi i have ActiveXScript task that is in old DTS
it is not working with SSIS
Can some body help to resolve
'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************
Function Main()
Dim oCmd, sSQL, oDom
''' If MSXML 4.0 is not installed this will not work!
Set oDom = CreateObject("Microsoft.XMLDOM")
Set oCmd = CreateObject("ADODB.Command")
oCmd.ActiveConnection ="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AdventureWorks;Data Source=(local)"
sSQL = "<?xml version=""1.0"" ?>"
sSQL = sSQL & "<sql:query xmlns:sql=""urn:schemas-microsoft-com:xml-sql"">"
sSQL = sSQL & "select employeeID as EMPID "
sSQL = sSQL & " ,title as TITLE "
sSQL = sSQL & "from HumanResources.Employee "
sSQL = sSQL & "for xml auto,elements "
sSQL = sSQL & "</sql:query>"
oCmd.CommandText = sSQL
oCmd.Dialect = "{5D531CB2-E6Ed-11D2-B252-00C04F681B71}"
oCmd.Properties("Output Encoding") = "utf-8"
oCmd.Properties("Output Stream") = oDom
oCmd.Execute , , 1024
oDom.Save "C:\Documents and Settings\shirish_jani\Desktop\XMLReport\New Folder\export.xml"
Set oDom=Nothing
Set oCmd=Nothing
Main = DTSTaskExecResult_Success
End Function
September 20, 2010 at 7:54 pm
September 21, 2010 at 9:00 am
so what is the changes that i need to apply with this
once i take new activexscripttask from toolbox
September 21, 2010 at 9:03 am
September 21, 2010 at 10:00 am
i got error Function not found
September 21, 2010 at 10:16 am
September 21, 2010 at 10:41 am
still i am not able to resolve it
do i need to use in script task
or what are the changes i need to do
please help me
September 21, 2010 at 10:50 am
September 21, 2010 at 10:58 am
but by running ssis it says function not found
September 21, 2010 at 10:59 am
September 21, 2010 at 11:03 am
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at ActiveX Script Task [ActiveX Script Task]: Function not found.
Error at ActiveX Script Task: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
------------------------------
September 21, 2010 at 11:04 am
jani_shirish (9/21/2010)
TITLE: Package Validation Error------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at ActiveX Script Task [ActiveX Script Task]: Function not found.
Error at ActiveX Script Task: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
------------------------------
What did you specify for "EntryMethod" property ? Did you enter Main ?
September 21, 2010 at 11:10 am
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at ActiveX Script Task [ActiveX Script Task]: Function not found.
Error at ActiveX Script Task: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
September 21, 2010 at 11:10 am
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at ActiveX Script Task [ActiveX Script Task]: Function not found.
Error at ActiveX Script Task: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
September 21, 2010 at 11:11 am
TITLE: Package Validation Error
------------------------------
Package Validation Error
ADDITIONAL INFORMATION:
Error at ActiveX Script Task [ActiveX Script Task]: Function not found.
Error at ActiveX Script Task: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
Viewing 15 posts - 1 through 15 (of 26 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy