SSIS package throwing "the type initializer for 'System.Data.SqlClient.SqlConnection'

SSIS package throwing "the type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception"

I'm running SSIS package which references an assembly which calls a WCF web service. Everytime i run it, i get this weird
"the type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception".

So i decided to check on app.config setting in the following files located in C:\Program Files\Microsoft SQL Server\90\DTS\Binn folder.

a) DTExec.exe.config

b) DtsDebugHost.exe.config

c) dtshost.exe.config

It has nothing to do with these configurations.

Solution

Try installing Microsoft .Net Framework 3.0 (in my case) and it solve my issue.




Comments

Post a Comment

Popular posts from this blog

The specified initialization vector (IV) does not match the block size for this algorithm

Image
If you're getting  exception when trying to assigned key to a symmetric key and getting error message below :- The specified initialization vector (IV) does not match the block size for this algorithm And your code probably look like something below :- Then you need to go into debug mode and start looking into the supported size for IV as shown in diagram below :- As you can see, IV is 16 bytes, so you need to provide 16 bytes. The same goes for Key field too, if you're adding anything to it. As long as you provide a valid key size, then we're good and you're code will be ready.
Read more