Not sure how much this would help, as I've not done this, but when dealing with the order of dependencies there is the a system procedure ,sp_depends, that...

And you did not rename of Excel sheet ,it is still Page1 ( I dont know if trailing spaces in the name  would make a difference but might as well...

I would also throw in there to check that you or someone else does not have the Excel file open.

In your data you may have sales where State is a column, along with storeName. If you want want to rank your best selling stores you can sum sales and...

I'm glad I'm not the only one that missed the SET as I was thinking SELECT as well. Nice one Steve.

I uploaded some pictures to help illustrate what was mentioned in a prior post. You can right click the database, select the tables you want to script out and what...

I wonder if the SSDs are identical, as in reads/write (throughput? ) per second and such.

This will give you a list of the system views that have information on check, default, and other constraints > 

select * from sys.all_views
where...

Is this a solution that was created on another machine that you are now trying to run on yours? DO you have the Integration service running (not just the SSDT...

Do you know if something was thrashing one of the disks? That is, some process doing some intense read or write? An anti-virus would make sense. If you approach the...

This is a great conversation. I suspected from the time I was a student in college, and later learned, that the tools available in software were not being fully learned...

Heh, No worries at all Jeff. I am impressed that you found this! I had long forgotten about this topic. It is quite a busy world out there, no embarrassment...

Good question. I did not see in the documented link the mention of table variables. Did I miss something?
Thanks

Wrox the publisher has a good book on SSIS that I read some time back. I'm sure they have updated versions on the subject and that would make good reading. 

You can have a extended property that serves as a URL to a Sharepoint site or other shared resource with the actual columns documentation. Hence you at least here create...