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...

if you want to avoid a script task,i would think you could use foreach loop pointing to the directory, with a filter like "MyFile_*.txt"  for the pattern identify the records,...

id want to see the execution plan and know what indexes are on the table.

i don't know if the STGeoFromText is slowing things down, if i have the...