Thanks to this post: https://prathy.com/2016/06/my-thoughts-on-ssis-2016-ssis-package-parts-2/  it appears that you can use the Package Parts variables in the Package but you have to manually change the scope of the variables once...

Hmmmmmm, thanks for the suggestion. In the end I have no idea what changed.

The SysAdmin reported that at the times when my process would have been attempting to log in,...

Tried that. It was a good idea but I don't get that option from the web installer--SSDT isn't in my pick list. Microsoft's on line documentation states that you have...

Got it. They have VS2010 Professional which doesn't have the compare tool. Bummer.

I'm fully in the integration camp. When Admin (DBA), Dev and Ops are siloed with poor communication you get the situation you describe in your editorial. However, if they are...

I've been contracting for the last several years and it really is a challenge to figure out what each contract is actually looking for. I'm really a SQL Server Developer,...

I'm all for CI/CD because they build development departments that have a functional and well understood deployment process--and a functional and well understood rollback process for the occasional oops. This,...

This blog post was the winner: http://toddmcdermid.blogspot.com/2009/10/quick-reference-ssis-in-32-and-64-bits.html

What a way to waste half a day!

Nice, that is cleaner. I'll update the script.

Thanks, opc.3. I'm sure there are better ways of doing this but reality is usually less perfect. What I came up with is the following:

$fileEntries = [IO.Directory]::GetFiles("E:\datafiles");

foreach($fileName in...

The server and disks are at a co-lo and everything has been purchased. In looking back through the info I have, I don't actually see the size of the RAID5.

The...

OK, you are going beyond my level here. I'll have to assimilate this one bite at a time.

Note that the contract/specs for the server pre-dates my involvement. The box is...

Hmmmm, don't see my customer's name in the post, just the co-lo that probably appreciates the advertising.

My apologies if Guys is considered sexist, I tend to consider it generic but...

Good premise, I, however, have become quite handy at fixing copiers... 😉

Thanks for the link. That looks incredibly on-target for me as I start contracting rather than working as an FTE. Seems no one understands the distinction between SQL Developer and...