Hi,

"1 - Setup Project Parameters - flag them as Sensitive (in SSIS Catalog EVERYTHING should be Project Parameters).

2- setup Package parameters - only for the Sensitive parameters. set these as...

Thanks

DontSaveSensitive - If I set this, do I need to give the passwords every time I load the package to VStudio and run it?

EncryptSensitiveWithPassword - how would this show in...

Ed,

Thanks, this 'Microsoft Connector for Oracle' worked for me fine

https://www.microsoft.com/en-us/download/details.aspx?id=105811

('ODAC 19c' also brought the Oracle OleDb choice to the the OldDB list but itdid not work for me)

Ville

Hi again,

Now I downloaded ODAC 19c from https://www.oracle.com/database/technologies/net-downloads.html

I took both 32 and 64 bit versions.

Like said, the VStudio is 64 bit. That makes me think the 64 bit...

Ah...of course, that didn't cross my novice SSIS mind, thanks

Have you ever been in the situation that you need to keep the Data Flow as Delay validation = True because...

Hi Phil,

I now tried to accomplish this in one of the packages.

Here is what I did and what happened.

Get the Value_date from another Sql server

'Execute Sql Task' to get the...

Hello Thom,

No there are no linked server definitions between these two servers and there will not be either.

Like said, I'd like to read one value (from a parameter table) of...

Phil...

Thank you

Now I have my SSIS Project/Solution created!

Why I wasn't able to do so before - maybe I just did not know to write SSIS in the search bar

Ville

Hi there Phil and Tom

Like I show in the attachment, I have 'SQL Server Integration Services Projects 2022' and 'SSDT' (which I understood is not what I am looking for)

I...

Hi again,

I found even better solution...?

TRY_CONVERT returns 0 from some of the decimals with comma but try_parse seems to be consistent...

TRY_PARSE(REPLACE(Value, ',', '.') AS...

Hi,

no, but just did. Thank you, that opened my blind spot...

In this particular CSV file I returned Value instead of REPLACE(Value, ',', '.') from the first...

Hi,

yes, that is what happens..but what then? What can i do?

isNumeric not reliable..how can i the find what Value might cause this?

v

Hi,

yes I agree, it is not a hashbytes problem. instead Informatica removes the two trailing zeroes when inserting the row to db. Why..? Remains a mystery.

ville

Hi,

OK. Binary(16) would solve the problem. There is only one minor problem...there is a big DataVault solely based on varbinary(40) fields - too big a job to start...

Hi,

yes so it seems...

The difference is that in my case the insert goes through Informatica ETL tool. There is something with the Unix ODBC API or...