SQL Server Integration Services

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 …

SSIS Date Part Expressions Read More »