I tested the C# code/ ran it i cant close the script editor because the error is there. I also resolved this:

These are the sort of values in the Excel:

The Data Tools are installed. I opened VS and then i opened the file folder and then select the package. This method worked for me.

I believe i did?

@[User::Var_Period_loop_Start] == 1  ? "01": 
@[User::Var_Period_loop_Start] == 2  ? "02": 
@[User::Var_Period_loop_Start] == 3  ? "03": 
@[User::Var_Period_loop_Start] == 4  ? "04":...

Here is the complete use case of the package(it runs with no errors):

• This reply was modified 10 months ago by  yrstruly.

1. The error was because two variables sort of overlapped each other and that lead to the ETL seeking file "\BRACS Data Masterfile Actuals - P01 - LY - LY.xlsx"...

1. The error was because two variables sort of overlapped each other and that lead to the ETL seeking file "\BRACS Data Masterfile Actuals - P01 - LY - LY.xlsx"...

The script does not give an error:

#region Help:  Introduction to the script task/* The Script Task allows you to perform virtually any operation that can be...

The code was not created by me. I am just investing some one else's code, this person is leaving us soon. I just want to make sure that the code...

I am trying to achieve this:

@Mr. Brian Gale See Fact file for financial data.

Thank you. Some sample data attched.

Thank you @Ed B and @jeff Moden.

I have attached sample data in Excel. My data sits in Postgres, but I have converted it to T-SQL for better understanding.

(1)...

@jeff Moden   Thank you for the feedback.

Table has a column Account Numbers that i could make unique, but Table B, the same account Number is duplicated because it...