VSTSC's Community Server

This post covers accessing web services in an SQL Server 2008 SSIS package, in particular the web service provided by Reporting Services 2005 in both MSRS 2005 and MSRS 2008.  I have a need to generate reports on a schedule and/or on an event driven basis from Reporting Services based on a number of outside conditions.  I could use ...

Introduction This post is part of a series titled An Introduction to the SSIS Expression Language. In this post, I demonstrate the SSIS Expression Language and Dynamic Property Expressions. To build the demo project described in this article you will need SSIS 2005 and the AdventureWorks sample database (which can be downloaded at ...

Introduction This post is part of a series titled An Introduction to the SSIS Expression Language. In this post, I demonstrate the SSIS Expression Language and the Conditional Split Transformation. To build the demo project described in this article you will need SSIS 2005 and the AdventureWorks sample database (which can be downloaded at ...

Introduction This post is part of a series titled An Introduction to the SSIS Expression Language. In this post, I demonstrate the SSIS Expression Language and the Derived Column Transformation. To build the demo project described in this article you will need SSIS 2005 and the AdventureWorks sample database (which can be downloaded at ...

Introduction This post is part of a series titled An Introduction to the SSIS Expression Language. In this post, I demonstrate the SSIS Expression Language and Variables. To build the demo project described in this article you will need SSIS 2005 and the AdventureWorks sample database (which can be downloaded at ...

Introduction The SSIS Expression Language is one of the steeper slopes on the SSIS learning curve. Many database professionals have never been exposed to the syntax. In this series, I provide examples that demonstrate common uses for the SSIS Expression Language. The examples are built in SSIS 2005. Why? Not everyone has access to SSIS 2008 at ...

This is the second part in a very short series covering dtexec and how to see exactly what package it is executing.  Last time we covered how to see what dtexec was doing using PowerShell and WMI.  This was great for checking all the different packages that might be running on a server at any given time.  What we will cover this ...

dtexec.exe is the program that is executed to run dtsx packages in SSIS 2005.  This executable is called if you call a Integration Services package through SQL Server Agent or through the command line directly.  The problem I am trying to solve today is to know what package dtexec.exe is running.  When you run an SSIS package you ...

Introduction A few months back I received an email from a nice lady who was beginning to work with SSIS. She was trying to use SSIS to automate metadata collection in her enterprise and she had made a good start in the package she attached to the email. She had a few questions so I opened the package and began poking around some to answer ...

My latest SSIS 101 article - SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers - is live at SQL Server Central today! Enjoy! :{> Andy