Hi Thom

so what is the best practice here?

Windows authentication and running the package with a service account or a user executing the package in SSISDB? I’m happy to say I...

Hi Thom

we will be getting data from SQL server, excel files, csv files, oracle database and unstructured data from a PII database. So how do I make sure that the...

Hi Eric

I’m asking a security question about how SSIS keeps the source data secure? SSIS we’ll use packages and connection managers to access the data sources and extract and load...

Thanks Sue

I’ll try them tomorrow

Glad I made you laugh because there are a lot of people crying in my office lol

Kal

Hi Sue

This database is linked to an edms using share point and filestreaming so finding the query might not be straight forward

What do I do here if...

Yeah but the database is also using Filestreaming so i dont know if that will affect it also
What else can i do?

Kal

I stand mistaken ??

Kal

Ssms 2017 only comes as a 64-bit if I’m not mistaken

The 86 bit are the redist.

Sorry Sue

We tried to recreate the same error and we didn’t find...

Hi Sue

This was a domain account with admin rights but I’m guessing the local admin account should work it was a service which was locking the VS isolated shell....

Hi Erik / Sue
I had one of my colleagues in the systems team look at it and we actually got it to install.
Here is what we did:

Hi Sue / Erik
It failed again:

[1AAC:2724][2018-08-14T13:57:58]e000: Error 0x80070643: Process returned error: 0x643
[1AAC:2724][2018-08-14T13:57:58]e000: Error 0x80070643: Failed to execute EXE package.
[2404:2448][2018-08-14T13:57:58]e000: Error 0x80070643: Failed to configure per-machine...

Hi Erik
I am trying to install SSMS now after installing the 2017 distr
Which files were you talking about?

Kal

Hi Sue and Erik

I’ll try it tomorrow with the 2017 redistributable and see what arises.

Kal