Error while executing an SSIS package ActiveX Script in SQL Server 2008 SSIS
Hi All, I am abiggner in SSIS and i try to create an ActiveX script and add a function in the package and execute it. It throws me the below error message. Can someone help me how to work with this error and what is the reason for getting this error message while exeucting a ActiveX script. Below is my script used in Script: function Main() Dim Stuff, myFSO, WriteStuff, dateStamp dateStamp = Date() Stuff = "SSIS Text ActiveX Task" Set myFSO = CreateObject("Scripting.FileSystemObject") Set WriteStuff=myFSO.OpenTextFile("D:\Learning\SSIS Learning\Practice\Apr 14\Chapter18_ActiveX\ActiveX.txt", 8, True) WriteStuff.WriteLine(Stuff) WriteStuff.Close SET WriteStuff = NOTHING SET myFSO = NOTHING End function Error Message thrown is as below: Error at How many Tables [ActiveX Script Task]: User script threw an exception: "An error occurred while adding the managed SSIS type library to the script host. Verify that the DTS 2000 runtime is installed.". Error at How many Tables: There were errors during task validation. (Microsoft.DataTransformationServices.VsIntegration) Thanks KotiKotig
April 29th, 2010 8:28am
I think its related to the libraries and that too its not a .net script. you have to rewrite it into a .net script. debug it to find the exact bottleneck : open the script editor and create a breakpoint ( click on the left border of the first line or right click and select insert breakpoint) run your ssis package --> it will open the script editor in debug mode --> press F11 to go to the next line --> if its rising error in one particular line--> then add a quickwatch and find the problem. finally when you know how to debug then you can resolve yourselves. Please mark the post as answered to help others to choose the best. chandra sekhar pathivada | www.calsql.com (SQL Server Community Website)
April 29th, 2010 8:37am
I am getting the same error. I am sorry. I didnt get you, can you please explain me again. I am using ActiveX Script Task by the way. Package validation error Error at ActiveX Script Task[ActiveX Script Task]: User script threw an exception: "An error occured while adding the maanged SSIS type library to the script host. Verify that the DTS 2000 runtime is installed".
June 8th, 2011 2:27pm