August 1, 2015 at 8:48 am
Hi Team,
I have an c# exe (built in .net 2.0 framework) which executes a SSIS package which is built with BIDS 2008.
I am running this exe on windows server 2008 r2 , I am getting below error:
System.IO.FileNotfoundexception: could not load file or assembly microsoft.sqlserver.managedDTS version 9.0.42.....
I re complied my c# projects by adding managedDTS version 10, but still same error:
My Question:
>On the server when I go to SQL Server configuration , I see no Integration services. Is it a a prerequiste to run package from c# ?
> I am askin this because, I can see the ManagedDTS dll's in c:\windows\assembly folder.
Please help on this.
August 3, 2015 at 7:11 am
You can't run a DTS package unless SSIS is installed and running on the machine in question.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
August 4, 2015 at 12:25 am
Integration Services are installed and is running.
August 5, 2015 at 7:45 pm
I think I'd take the source and re-compile using a .NET 4.0 or later framework and at least Visual Studio 2008, if you haven't already tried that... Beyond that, however, I'm lost...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
August 9, 2015 at 12:51 am
This is resolved. Below was the issue.
My c# proj had references of other c# proj's which had MangedDTS dll referenced in them. I first rebuilt them , added there references in the main c# project and rebuilt it.
Now its referencing the correct version of ManagedDts
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply