Nice job Theo;
I had created a procedure to check the current patch version,all available patch version, and the suggested Service pack version, but it used an internally contained CTE full of...

what you want is a case statement to pick one column or the other base don the value.
here's a complete working example based on what you posted. see how...

look specifically at the path in that Package.ConnectionManagers[StaffExport], 
is it using a mapped drive, and not a unc path? ie the path should be \\servername\sharename\filename.txt, and not the T:\sharename\filename.txt
mapped...

I have a DBA_Utilities database that I keep tables  in place for randomization. So for example i have a MovieStars database that is a cross join of Real Movie Starts...

Analysis server allows windows connections only, you are correct.
i those situations, we've added consultants to have a domain name on our network, and they connect via citrix to establish...

I've done this with a Common Language Runtime (CLR)that was unsafe(due to windows.forms) so i could create an RTF object and get the MyObject.Text from it.
if you google, you...

the executable you want is dtexec.exe. that executable can launch a dtsx package from the  command line, and you do not need to make any modifications to your package.
mine...

this recent article and the follow up in the forum has a nice code example of getting all reports and all their parameters;
so you could use this and get...

excel changes your data to what it thinks is best, it does not 100% maintain actual values.
does your data have any FLOAT or REAL data types? since those are...

if the localdb is not sharable, then the local instance has to push data to the central server, instead of the central server pulling from the laptop.

so an...

there's a couple of layers to work at here.

for LocalDB to be accessible to anyone other than the user that created it, it has to be started and...

wouldn't it be better to calculate a checksum or binary checksum for the list of columns to test instead?
the space used would be substantially smaller, right?, then you could...

could it be that some TSQL was pasted into a job step? the ansi settings in a job are NOT the same default settings as when you runt he code...