In both solutions - I would move the calculation to a CROSS APPLY:

SELECT  Cust_num
        ,Co_num
    ...

What is the purpose of having a second database that is exactly the same as the primary database?  Why do you need to copy the data to the other database?

A...

How can I use the VARCHAR command only to display the first 20 characters for a comment field that is set for varchar(200)?

I am trying to display the first...

Take a look at the TOKEN function (https://docs.microsoft.com/en-us/sql/integration-services/expressions/token-ssis-expression?view=sql-server-ver15) - it will be much easier using that instead of substring.

Build a variable (name it FileCode) as: TOKEN(@[User::FileName], "_", 3)

Then your expression...

Just a quick note - you may need to embed double-quotes into that string for it to work correctly.  There is a space in the path and it will probably...

You stated that SQL Server has 32GB of memory - did you mean the server has 32GB of memory?  If so - what is the max memory assigned to SQL...

@jeff-moden, Yes, I agree with you that the steps I'm trying to get through Power Query can also be done with T-SQL. The main purpose of this article...

You can do this with an OUTER APPLY instead of a CASE expression:

SELECT *
  FROM TableB  b
 OUTER APPLY (SELECT TOP 1
   ...

I was not able to see the picture before - and since this is a cursor it is definitely a coding problem.  If you can provide the code - then...

This is almost certainly a coding problem - but to be sure we would need to see the code and the execution plan.  The actual execution plan saved as a...

is it just me or does the OP here just think that we "should" answer all his/her questions without he/she showing that he made an effort of googling...

If this file is truly a fixed width file - then every record should be the same length.  However, it looks like this might be a ragged-right type of file...

Thanks Jeffrey! Node4 will not have any other user databases other than reporting DB which would be configured with AG. In case if there is any server issue or...

We might even be able to save those 4 extra characters - depending on the source data.  If we know for sure that we have a minimum length of at...

Just one point - not sure it makes a difference in performance but you can avoid this:

@BitBucket = RIGHT('00000000000000'+CONVERT(VARCHAR(14),Col01),14)

By using this:

@BitBucket = RIGHT(CONCAT('00000000000000', Col01),...