Monday, October 26, 2015

Another configuration story

After struggling to get the SSIS working, talking to several people a blog entry came to rescue and saved the day:

https://msdn.microsoft.com/en-us/library/ms137789.aspx

During a SSIS instlalation I never had issues with configurations, I usaually install everything using an Administrator account. I had a local account and run the executable as Administrator, the SSIS was installed and the instance created. The problem was when using the local account to access Management Studio the SSIS instance was unavailable, using the installation account and running as administrator did the trick.
The SSIS instance was registered under the adminstrator priviledges and was unable to be accessed outsider the administrative group. The configuration was required to allow the instance to be accessed from Management Studio

Friday, October 23, 2015

Linq to SQL

Since I have been battling to figure how to use linq in the correct form and to speed up my coding, the following link is a life saver (and brain saver as well);

http://www.codeducky.org/sql-queries-in-linq/

Downgrade SSIS 2014 to work on 2012

The answer to all of my complanig was just around the corner :)

The featured blog does not only provides a solution as well a nice simple comand line utility to execute the replacements:

http://vaniecastro.com/2015/02/26/how-to-downgrade-sql-server-integration-services-2014-packages-to-2012/

Here is the list also referenced of replacements:

https://msdn.microsoft.com/en-us/library/dn592136(v=sql.105).aspx