Tag Archives: SSIS

Cannot load script for execution after migrating your SSIS Package to a new SQL Server version

You are migrating your SSIS Packages from an old version SQL Server to a new SQL Server version, it worked perfectly fine before but once it was deployed on the new environment you get an error similar to this one. Message Executed as user: YourDomainYourUser. Microsoft (R) SQL Server Execute Package Utility Version 13.0.1601.5 for… Read More »

How to create Data driven report subscriptions in SQL Server Standard Version

I guess you are here because you are looking for a solution that will send your SSRS reports via email to a dynamic recipient list related to your data in your SSRS report.  In SQL Servers Business Intelligence and Enterprise Edition this feature is included but if you use a lower edition like Standard and… Read More »

How to Archive SharePoint List Items to SQL Server

You might have reached the threshold of a SharePoint List and you’re afraid to increase the limit as you might affect the performance of you server.  Now you are thinking of other solutions and one thing came to mind, why not archive the data? Well that is a good idea but how are you going… Read More »

Transfer Users from one SQL Server to another including SID’s the easy way

Before I wrote an article regarding this one but it seem that was the hard way of doing it.  See the article here http://www.macaalay.com/2012/10/11/how-to-synchronize-loginsusers-between-mirrored-servers/ , but recently I was playing with SSIS in Visual Studio and found out that there is an easy way of doing it without complicated scripting and can all be achieved in… Read More »