SQL Developer Ramblings

Download Source Files: Here As promised in my first post , I’ve now put together an new example of how to use the the SQL MERGE statement, along with new TABLE Data Type to upsert a dimension table in a data warehouse completely within data flow.  In the previous example I used the control flow along with and recordset object to illustrate how to pass the data into a stored proc, however the call to the stored procedure was in the control flow. In this post I will use a script destination component to call the stored proc.

Download Source Files: Here This is the first of four posts looking at how to generate and save SSRS reports from within SSIS.  In this post I will look at creating the stored procedure to retrieve the report information, and creating and deploying the sample report to the report server. The Second post will look at a method of calling to the report server and generating reports in the control flow of SSIS.  We’ll look at how to connect to the web service, pass parameters and save a report to disk. The third post in this series will show how to do the same thing in Data Flow, but instead of writing the reports out to disk I’m going to save the reports in a binary format straight to the database.  The fourth post in this series will show you how to use SSIS to retrieve the binary files saved in SQL server and render them back to disk.  I’ll also illustrate in this example how you can attach the files to an email and send them. I hope that at the end of thi...