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

can't you just add another WHEN THEN?

case 
    when icd.ECCN is not null
  then icd.ECCN
  when sola.ECCN is not null 
  then sola.ECCN 
else 'missing' end 
AS TESTVALUEECCN

we need Details. the actual DDL of your current table, a couple of fake sample rows of data, and the DDL of your destination tables.
with that, we can provide...

performance wise, SQL server can insert millions of rows in about the same time as a single row or small number of rows,
so breaking up an operation into multiple...