Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSIS loses file reference when opening script task

We use a custom audit assembly (C#) for logging several kinds of actions within SSIS in script tasks.

We post build the custom assembly in the GAC (for runtime) and to the public assemblies area of the IDE (VS2008) for design time file referencing. After the postbuild is done the custom assembly is available for use in runtime and for designtime in the .NET tab of the file reference popup.

However, after re-opening the script task, the file reference is gone in the list and the script doesn't compile.

How's that possible ?

like image 566
Patrick Peters Avatar asked Oct 14 '11 12:10

Patrick Peters


People also ask

What is DTS in SSIS Script task?

The Dts object is an instance of the ScriptObjectModel class. ScriptTask. Defines the classes for the Script task, which lets developers write custom code to perform functions that are not available in the built-in tasks provided by Integration Services.

What is the difference between Script task and Script component in SSIS?

The Script task is configured on the Control Flow tab of the designer and runs outside the data flow of the package. The Script component is configured on the Data Flow page of the designer and represents a source, transformation, or destination in the Data Flow task.

How do I change the script language of script task in SSIS?

To set the default script language for Script tasks and Script components, use the ScriptLanguage property on the General page of the Options dialog box.


1 Answers

Seems liks a bug in SSIS, but I have a workaround here:

Just click Save All instead of just closing the popped up IDE C# editor.

like image 152
Patrick Peters Avatar answered Sep 19 '22 18:09

Patrick Peters