Sometimes you need a way to quickly get a list of users that have permissions to all of your SQL Server Reporting Services reports. This is especially true if you have fine grained permissions or use Active Directory roles that are constantly changing. The idea is simple; query the ReportServer database and find who has …
SQL Query to Get Reporting Services Report Permissions SSRS 2012 Read More »
Need a way to upload a generated file to a website using SSIS? The code below uses HttpWebRequest to make page requests, HttpWebResponse to get server responses and CookieContainer to hold the session data. The website required a session cookie along with login credentials. To complicate things even more the cookie was created on one …
SSIS Script Task to Upload a File to a Website using C#, HTTP Post with HttpWebRequest Read More »
If you are diving deep into SSIS you're probably familiar with the fancy string manip needed to get your file names and folder paths to line up with various date structures and formats. Here's a few I've used recently that might come in handy. Feel free to offer improvments and supplements. Month Date Short Year …