Welcome to VSTSC's Community Server Sign in | Join | Help

Browse by Tags

All Tags » Random SSIS Info   (RSS)
Monday, November 03, 2008 9:52 AM

SSIS Execute SQL Task and RaisError (Using a OLEDB Connection)

This is a relatively short post about raising an error in T-SQL and having SSIS not recognize that error. If you have an SSIS package that calls a SQL Task and that T-SQL for whatever reason ends up raising an error the SSIS package that called the T-SQL
Posted by steve | 0 Comments
Wednesday, May 28, 2008 5:19 PM

Ordering SSIS packages in Visual Studio 2005 (part II)

Ok the first post on Ordering SSIS packages in Visual Studio received a large number of hits...no comments but a good number of hits so I figured a follow up was due. After my first post I found myself ordering all of my SSIS packages with the order-ssisProj.ps1
Posted by steve | 1 Comments
Friday, May 16, 2008 5:45 PM

Ordering SSIS packages in Visual Studio 2005

Problem: SSIS Packages in Microsoft Visual Studio 2005 are ordered in the order of package creation by default, or more precisely the order they have been added to that solutions/projects folder. What this means is that if you have an SSIS project that
Posted by steve | 0 Comments
Saturday, February 16, 2008 6:45 PM

Connecting to an iSeries for SSIS Users (this pertains to any .Net connection)

There are a number of useful pieces of information to be gleaned from reams and reams of documentation on both sides of the house when it comes to connect SSIS to an IBM iSeries. I will try to present as much of it as I can in an easy to read fashion
Posted by steve | 0 Comments
Thursday, November 08, 2007 10:11 AM

Using the SSIS OLE-DB command on non friendly destinations (iSeries DB2)

At the risk of becoming pigeonholed as the guy who only posts about SSIS and iSeries interaction I have decided to post yet again on this subject area. The information provided below may lend itself to other non SQL server OLE DB destinations but I have
Posted by steve | 0 Comments
Filed under:
Saturday, October 20, 2007 9:23 AM

iSeries TimeStamps to SQLServer using SSIS

Here is a simple enough problem, the IBM iSeries (AS400) allows for a date range that starts at a lower value then SQL Server can handle, but one that SSIS can handle. This can cause a slight issue when trying to import data from an iSeries into a SQL
Posted by steve | 0 Comments
Filed under:
Friday, October 19, 2007 10:01 AM

Looping through iSeries DB2 Data in SSIS (DB2 for the AS400)

This should be a pretty short post. I came across a pretty interesting behavior using the Native OLE DB\Microsoft OLE DB Provider for DB2 when its configured to connect to a iSeries DB instance. (This is the driver provided by MS in an add on pack to
Posted by steve | 1 Comments
Filed under:
Saturday, September 29, 2007 8:39 AM

Passing a values back from a child package to a parent package in SSIS

This is an example of something similar to what I saw Allan Mitchell execute in an SSIS package about a year ago. I didn't think much of it until a few days ago when I needed to pass a bunch of data from a child package back to the calling parent package.
Posted by steve | 2 Comments
Filed under:
Tuesday, September 25, 2007 5:33 PM

Exporting Multi-Record Formated Flat File with SSIS

I recently had to come up with an easy way to create a multi record formatted file as a destination from and SSIS package. While I found a number of helpful tips on how to read from such a file I did not find anything on how to create such a file. I decided
Posted by steve | 2 Comments
Filed under: