VSTSC's Community Server

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 may complete with the step without error.    There may be two ...

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 code but I found it to be a bother since I had to put in the location of each ...

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 has more than a few SSIS packages let’s say 70+ it becomes an issue when you go to ...

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 here.  I am going to start off with the basics- Terminology. General iSeries ...

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 not tried it with anything other than the MS OLE-DB driver for DB2.  ...

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 Server.  This can be handled by a derived column transformation checking the source ...

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 SQL Server 2005 sometime earlier this year)  When you try to loop through a ...

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.  This example passes a record set from a child package to the ...

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 to see if I could do this utilizing standard SSIS objects with as little code ...