Very strange SQLServer Connect Failed: 28000

Hi guy,
I'm experiencing a very strange SQLServer Connect Failed.
It's really strange because it happens in a loop.
The first time the loop is executed, there is nothing wrong and the SQL statement is processed, the second time it doesn't work.
You may see it in the picture below.


The error log states:
Failed To Connect SQLDriverConnect Failed: 28000 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.

You may check the log of the first step.
Moreover if the loop stops after a single step, the process is executed correctly.
Can you help me?
Pietro

You might have a situation when the database password has the variable name inside

password = longcat1 and cat1 is variable name

So the first time it works fine but the second time cat1 is replaced with variable value therefore connection fails

Hi Mike,
thank you for your quick response. I've been looking around and I've found out viewing variables that there is a Variable 1 whose value is 2.
At the very first loop step there is a Variable called modupdate that has a value of 1 and it's the only one having this particular value.
The next step appears this one.
It's not declared anywhere: can you give me some hints?
Thank you very much once again,
Pietro

Maybe it is a global variable
/wiki/advanced-etl-processor/getting-started/options/?s[]=global

Please post some screenshots it is very difficult to provide support by guessing

Thank you Mike,
here there are the screenshot of the package that I've created and of the objects inserted there.
Thank you!

Very important thing to understand that
variables are replaced with actual values before execution

Variable value maupudatecreata is 1
SQL is;
select 'maupudatecreata', email from table
Again: variables are replaced with actual values before execution
The actual SQL executed
select '1', email from table
now you have variable '1' and it has some value
SQL server password is abc1dff
1 is replaced with a value
your connection fails

Please reset variables before the loop