Menu
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 ?
566
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.
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.
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.
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.
152
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
