Skip to main content

Using Expressions with SSIS Maintenance Tasks and SelectedDatabases

Using Expressions with SSIS Maintenance Tasks and SelectedDatabases

Its been noted by a few people that Expressions cannot be used to configure the Shrink Database Task at runtime. The problem is that the SelectedDatabases property is a collection which cannot be created by an expression. The same problem occurs in most of the Maintenance Task items of SSIS. Maintenance Plan Task components are […]

No!!! Undo, Undo, Undo!!

Or rather, why is there no “undo” in when working with Integration Services packages? This has been something that has me puzzled me since working with Beta 2 of Integration Services. I guess I figured it would be fixed by RTM, and just worked around the issue by regularly checking in finalised changes, and saving […]

SSIS Lookup with value range

SSIS Lookup with value range

Joe Salvatore called out for help on an interesting use of the SSIS Lookup component: Can you lookup a row using a value within a range? Joe specified his criteria as: DataStagingSource.ModifyDate < DataWarehouseDimension.RowExpiredDate AND DataStagingSource.ModifyDate >= DataWarehouseDimension.RowEffectiveDate AND DataStagingSource.NaturalKey = DataWarehouseDimension.NaturalKey Easy! To show how it is done I’ve created a test database “SCRATCH” […]

How to use OUTPUT parameters with SSIS Execute SQL Task

How to use OUTPUT parameters with SSIS Execute SQL Task

Yesterday while trying to get OUTPUT parameters to work with SSIS Execute SQL Task I encountered a lot of problems, which I’m sure other people have experienced. BOL Help is very light on this subject, so consider this the lost page in help. The problem comes about because different providers expect parameters to be declared […]