I appreciate the help, but there are still two records, instead of PID / PNAME being in the same row in column Profile Details

I made the changes to the registry, but still the same error message.  Thank you for suggesting it though..

If I go into the "Command Line" tab for the Job Step, I see this:  "/FILE "\"\\dev01\Integation Packages\Status_Data_Import.dtsx\"" /CHECKPOINTING OFF /REPORTING E".  This isn't anything I set, nor does it...

If you can use VS to import the data - why do you need to use the import wizard?  BTW - the import wizard is not going to use a...

Technically yes, I can open them in Visual Studio, but I cannot use this option at this time, as I am connecting to an Excel *.xlsx file, but unfortunately I...

To the first point, there's a good reason you can't kill a ROLLBACK -- because that could corrupt your db.

To the second point, that should be a...

Actually, overall, this is one of the best places I have worked.  I have been remote long before COVID.  I won't find anything close to the salary anywhere near where...

Please understand, I am not trying to be rude here, but we have done all that analysis and presented the evidence to the 3rd party team as to the causes...

We have something like that running that captures all queries being executed on the server.

My apologies, but I "mostly" understand.

To a team that only knows the name "DB1" to which to push the data, we would do the following:

1).  Create two databases.  DB2, DB3.

2). ...

Phil:

"So there's no chance that one of the files could contain bad data?"

To answer that question, I cannot say there will "never" be bad data, but as long as this...

I understand the risk.  This is a stop gap until I can rework the SQL Job to avoid it.  The reason it would fail is due to server load and...

We get files that need to be imported daily into our SQL Server because we do not have direct connections to import the data.  The import of each file is...

Jeff:

Thank you for that.  It provides some of the information, but I guess what is really needed is a way to tie those logs to a certain user / login. ...

Thank you everyone for all the help / suggestions but I found the issue.  For some odd reason, my "main" table didn't have the correct column counts.  I counted numerous...