CODEWITHSUNDEEP
visual-studio-2010.net-4.0ssis
Trond Smaavik
Trond Smaavik

Reputation: 33

Calling .net4 from SSIS

We've done some work on a .net 4.0 project, and are now looing into using SSIS for some tasks. As SSIS is not supported in VS2010, as far as I can see, I'm sort of ok with using VS2008 for SSIS. But how can I call exsiting .net4 code from SSIS at best running on .net 3.5?

Do I have to wrap my c# code to a web service or are there other options?

Upvotes: 2

Views: 422

Answers (1)

Michael Entin
Michael Entin

Reputation: 7744

The version of .NET for an application depends on the main executable. If you use DTEXEC to run SSIS, you get .NET 3.5 because DTEXEC.Exe is configured to use .NET 3.5.

But if you build your own application (a simple console app with functionality similar to DTEXEC) with .NET 4.0 - you get .NET 4.0.

Finally, there is of course a hack to change DTEXEC to use .NET 4.0 - it is controlled by DTEXEC.Exe.Config, which you can edit, but most likely this is unsupported by Microsoft and thus I would recommend against it.

Upvotes: 2

Related Questions