jaegd


Will the Microsoft.SqlServer.VSTAScriptTaskPrx assembly effectively replace MicrosoftSqlServer.ManagedDTS assembly for script tasks

There are a number of script tasks which use ManagedDTS (e.g. new Application() + associated function calls) that no longer work with Katmai. For example, I've used tasks which build and configure packages thesmselves, since certain tasks' properties do not support expressions.

In reading mattm's blog post on this issue http://blogs.msdn.com/mattm/archive/2007/06/05/katmai-script-tasks-which-use-the-ssis-object-model.aspx the workaround is to compile the script task into a custom assembly. Would reflection also work here, so that you could effectively pull in a assembly qualfied type




Re: Regarding ManagedDTS assembly

Matt Masson - MSFT


I'm not quite sure about the implementation details of the fix, but it doesn't seem likely that the VSTAScriptTaskPrx assembly will replace ManagedDTS in Katmai.

I don't know enough about using reflection here - the main problem arises from the two assembly's objects sharing the same namespace. If you can pull in the types without causing a conflict, then it should work. If it ends up working for you, please post back and let us know.

Thanks,

~Matt







Re: Regarding ManagedDTS assembly

jaegd

The answer is yes, accessing Microsoft.SqlServer.ManagedDTS (the Katmai version) via reflection does "get around" the namespace clash, for what that's worth.