I need to verify these procedures if its right or not ?

Can you check on this ?

I need to write a procedure so that when I have to update the...

Hi

Data structure is already there in the picture.

Hi Guys,

These are the interview questions i faced in Msbi.
Please help me?

I had done doing that by manually starting SQL Server from SQL Server Configuration Manager, but it didn't work for me.

Please check the Screenshot.

Help me on this.

I'm facing lots of...

TCP/IP and Piped Protocol is already enabled.

All the Services are ON except SQL Server and SQL Server Agent.

I'm able to connect to Integration and Reporting Services, but cannot connect to...

TCP/IP and Piped Protocol are already enabled.

All Services are ON , except SQL Server and SQL Server Agent.

How to enable the port on firewall ?

How to check through Command Prompt...

I Started SQL Server Browser Manually.It got started, but trying to connect to SSMS once again and still getting the same error .

I'm able to connect to Integration and Reporting...

SQL Server Browser service is disabled .

How to check that ?

Hi,

Please check the attached screenshots (Both).

The Aliases are blank totally.

Hi,

You can pass the file name through expression builder of the execute process task. You should already have a variable in SSIS that would store the filename.

Please check the screenshot.

Thanks Cadavre

I got it.

Thanks Cadavre 🙂

Its working .