Thanks for your feedback. I am intending to come up with the next part of Booster Kit as Booster Kit - Part II. I have know this tool when I...

Serious Apollogies Jamie ! 😀

There are 3 typos in this article

1) I have mentioned "She" for Jamie Thomson, instead of "He".

2) In the complexity measure section, it should be "allocating" instead of "allocation"

3)...

Thanks for drawing my attention towards this thing. I do agree with your advise.

I mentioned it's a sample document ("sample of one such document"), and sections of it would have...

I didn't get the meaning. If you would like to see something in this kit, or something that you didn't think belongs to this kit, please add your feedback. In...

I agree. When one has the leisure of purchasing licenses of 3rd party tools, one can always do that.

I have just tried to list tools that incurrs no cost.

Also using...

I came to know that just before 1 month. But this article was submitted long before that. My apollogies for the same. Pardon me Jamie, you can beat me up...

I would recommend scheduling one top-level package and not all the packages independently. By this way, you can also track and audit the execution of different packages (for ex. by...

Isn't importing using a wizard a manual process ?

Not just Union All, there are other components that would have the same issue in case of duplicate column names. Its a better practice to keep column names unique as...

Step 1: copy the entire data from your spreadsheet

Step 2: Use the option of Edit Top 200 rows by right-clicking the table in SSMS

Step 3: Paste the data, and ensure...

Try this : http://www.sqlshare.com/Media.aspx?vid=34#

--Siddharth

I have followed a different approach for the same requirement, but that was for loading delta to data warehouse.

I suggest that create a Master Package, and then execute all the...

I have seen this behavior in BIDS 2008 when your machine starts running low on RAM. The solution that work for me is to close BIDS and reopen again, and...

Also verify that this package is not called by two Execute Package Tasks at the same time. It might be that you are using more than one Execute Package Task...