• This reply was modified 1 year, 5 months ago by  Oscar_Boots.
• This reply was modified 1 year, 5 months ago by  Oscar_Boots.

Ok, I'll try the links.

Cheers.

Thanks for the advice

Thanks Ant-Green,

Ok, to ask a dumb question to clarify, I should install VS (either 2019 or 2022) I then go to manage extensions & download/install the SSIS/RS/AS packages.

I should then...

I don't understand your reply?

Ok, Now here's an SQL Server script that does what I need:

Can anyone help me get this to work using Postgres?

Props to Reto Egeter for the script below.

            
May 9, 2021 at 8:58 am
            
#3881104

            
            
                                                
        

Thanks for the bump.

I can add a bit more about my issue that may help the Forum understand my issue.

If I wanted to search a Database for a Column Name,...

Hi Phil,

That's exactly what I was looking for!

I did find the Profiling Node in SSIS which gave me similar stats to what you extracted in Python.

I also like the idea...

Hi Phil,

I don't have a specific file in mind, it's more a process of how to check that all records went through SSIS and all came out the other side.

What...

Thanks,

I have read & done this already & the current issue is accessing SSIS via the Tools >> Extensions because it doesn't appear in the available choices from File >>...

Thanks But I can't find it from that link?

I've just gone around & around in circles but I can't find what I need to download this file.

Can you give me...

Thanks Jeffrey,

I've got almost evrything I need apart from SSIS.

I've gone to Tools >> Extensions & Updates & found SSAS & SSRS & downloaded them.

I then search for 'microsoft integration'...

Hello Jeffrey,

Ideally, I want to get Visual Studio (with SSAS/RS/IS) to use with SQL Server 2016 as this version is used in a course I'm doing.

The install is just on...

• This reply was modified 4 years, 2 months ago by  Oscar_Boots.

Hi kaj,

Totally agree, I have it installed but Notepad served the purpose this time.

Thanks Peter

Thanks Scott, I'll give it a try.

Peter