SSIS script object

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » SSIS script object

SSIS script object

Rate Topic

Display Mode

Topic Options

Author

Message

Positive

Posted Thursday, December 17, 2009 6:16 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, March 26, 2010 8:23 AM
Points: 13, Visits: 37

Hello,
I added a script object (VB.Net) and am trying to add a vbscript but the Design Script button does not open up the script editor screen.

Not sure what set up I need to do.

+ive

Post #836074

kenambrose

Posted Tuesday, December 29, 2009 2:24 PM

Valued Member

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:13 AM
Points: 70, Visits: 413

This are a number of issues that can cause this problem. When it happened to me, I fixed the problem by updating to the latest sql server service pack.

A couple of other possibilities are:

Your computer does not have all the required dlls successfully registered.

The script code that SSIS is trying to open contains > 1 function or event procedure with the exact same name. To test, open the dtsx in notepad, and search for that problem.

There is a good thread at

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/20f4e39e-d937-436d-8066-27d34e57e30d/

that covers many of these issues.

ken

Post #840072

« Prev Topic | Next Topic »

Permissions