June 28, 2013 at 7:14 am
Hi All,
I have been looking for a solution for this to see if someone has encountered it before and I am on the verge of giving it up...
We have SSIS packages(specifically Script Task) that have been created in VS2008 and with a .net 3.5 compatibility for the Script task. Can I run this packages using the dtexec in a 2012 server? Currently I am unable to do so on one of my test servers..
What i understood from looking up online on Tech net is this :
For 2012 :
"The scripting engine has been upgraded to VSTA 3.0, which gives us a Visual Studio 2010 shell, and support for .NET 4. and the Script task in SSIS 2008 is using .Net framework 3.5, so that there have some incompatibilities "
However that being said we have QA server where this ran just fine. It gave warnings that the package needs to be migrated; but it worked just fine.
I checked the config of both the server where this packages are run. The CMD file invokes the right location of dtexec with the right provider of SQLNCLI11 C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\dtexec.exe
Both have 3.5 and 4.5 installed.. Am i missing something here? If anyone can provide any insights that would be great..
Again..converting the package to the new 2012 is currently not an option and is a last resort..But since it runs on a QA server, I am just baffled :crazy:
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply