This statement:

ALTER DATABASE [MYDB] SET ALLOW_SNAPSHOT_ISOLATION ON

causes the db to start snapshot processing -- adding 14 bytes to each row and storing any needed row versions in tempdb -- and...

SELECT
    issuedate, replydate,
CASE WHEN replydate IS NULL AND DATEDIFF(DAY, duedate, GETDATE()) > 0 
         THEN DATEDIFF(DAY,...

DECLARE @date1 date
DECLARE @date2 date

SELECT ...
...
CROSS APPLY (
    SELECT dbo.fnGetSeconds(@date1) AS date1_secs,
    dbo.fnGetSeconds(@date2) AS date2_secs    
) AS alias1

...

My preferred approach is to use a CROSS APPLY to assign an alias name to the computation.  That name can then be used in any other clause in the SELECT,...

Should use the new file just fine.  Make sure the new file is present, or you will have no space to write to.

What's happening is this.  Your file has not...

Try SELECT too rather than PRINT, since SELECT can show more chars than PRINT.  Also, be sure to adjust the options in SSMS to show the max chars possible.

I

I have to...

Don't worry about ms, just use seconds.  A few ms diff could be caused by almost anything is and not significant for an SSIS package.

An ORDER BY either has an OFFSET clause or it doesn't.  There is no "sometimes it does, sometimes it doesn't".

In this structure, rather than use 0 for the count, could...

Sorry, thought I changed it to jma.... (which I'll now do in my orig post as well).  But I'm assuming that such a column exists just because or your comments...

Seems like the table must be empty.

Make sure you are in the correct db.

A long shot, but you should always put the schema name on the table anyway, for performance...

Here's my best guess at what you're trying to do.

SELECT 
    JO.jmoJobID, JA.jmaPartID, JO.jmoWorkCenterID, 
    JO.jmoProcessID, JO.jmoOperationQuantity, 
   ...

For a little disk space, you can create staging tables in DB2.  Load to the staging tables.  You then don't need a separate back up of the original tables because...

I believe it's because you're doing "MAX" but the value is a string not a number.  Therefore '9' is greater than '10', or '1', so '9' becomes the MAX value. ...

If they log into SQL initially as themselves, ORIGINAL_LOGIN() might give you their own name rather than the generic name.  It may not, but it's worth a try first.