I agree with everything Craig has stated.

If I am looking at this thread correctly, one of your challenges is loading into a final target table while that target...

Also, find out if you are going to be expected to administer the instance as well. All too often I see other folks get thrown into the fire. Nevertheless, I...

Although I am not totally clear on the end goal here, would an execute SQL task embedded in the OnError event handler of either the data flow task (local to...

Exactly!

Also, the BIDSHELPER tool on CODEPLEX extracts out these extended properties from the relational database and lands them into an SSAS solution--a very convenient and time saving tool! However, this...

Extended properties are indeed the glue that holds together the BUSINESS component of our "metadata repository".....as it is just one component of a bigger master data strategy. The biggest challenge...

I was burned by this 8 years ago.....never again. Caffiene-deprived, Xanax induced, secondhand THC inhalation.....whatever the state (j/k on the chemical reference--maybe). What is amazing to me is how an...

Many ways to accomplish this--especially if you know the folder names before hand. You can use an execute sql task to update a variable(s) which contains connection information. These...

I second that suggestion.

Are there any dependencies amongst the 12 packages (i.e. parent/child packages), and does an end user have control over passing any optional parameters? I...

This can only be used with the legacy components of SSIS (package deployment model) and not the SSIS Catalog (Project Deployment Model) in SQL 2012 and forward, right?

I am so glad SQL Server finally caught up to Oracle on making itself more ANSI-99 compliant in the area of "row based window frames". I always theorized MS intentionally...

Our data warehouse got a compression ratio of 68% using page compression. The best compression ratios are usually with star schemas with all (or close to all) integer surrogate...

Not a bad tool to have when flexibility trumps all other design objectives. Thank you for taking the time to contribute. 🙂

Somewhere your algebra 2 teacher is smiling......

I wonder what the performance difference would be if these operations were done in the CLR vs T-SQL:

a. In 2008

b. In 2008...

All solutions presented are acceptable and contain technical metadata.

If you want "quick and dirty" and need to port code to another RDBMS someday, then I would use INFORMATION_SCHEMA.COLUMNS as...