Duran (5/18/2016)

---

Hi Shawn,

Thank you for getting back, the thing I am not getting here is, after I have ran the code and type in $ChooseDBRole [enter], there is no value...

If the purpose is to use the value being passed out of this function there is no reason to add a variable in the function itself, just let it output...

Unless you just did not copy/paste all of your code you are missing about 45 lines of code to just build out the form. The example you can use from...

You need to review how you are calling the packages, and under what account it is running. If you are using Windows Authentication then whatever account is calling the package...

If SQL Server Browser is running, and the machine...

KlaasV (5/11/2016)

---

Bom dia Laerte

To add the assembly I usually go with Import-Module SQLPS, but there are also three versions of that module on my PC. How do I know which...

There is nothing similar to how you manage connections with .NET. I am not sure on the SSAS, PowerPivot, PowerBI portion as I don't do much with either of those...

ankithimmatlalshah (4/29/2016)

---

Hello everyone,

I've Windows 2012 R2 server with SQL Express 2012.

I would like to setup a package here on this server that will read the

data from CSV file and insert...

Starting point:

Get-ClusterResource | Where-Object -Property ResourceType -EQ "SQL Server Availability Group" | Select-Object Name

Option 1: Just add -ExpandProperty to your select-object:

Get-ClusterResource | Where-Object -Property ResourceType -EQ "SQL Server Availability Group"...

The IIF function you will primarily use to control the flow of steps in a batch...

The pricing is published for all of the vendors you listed, and each one at most have a calculator that you can use to determine what it will cost you.

The...

Take a look at this script:

Manipulating SSIS Packages using PowerShell

[/url]

The above script utilizes XQuery in PowerShell so it can be more readable and offer more flexibility.

Provide a sample configuration file so we can see the structure of your XML to what node you are trying to modify.

SQLTougherGuy (4/4/2016)

---

Hello SSC friends,

I have been tasked with creating a dynamic SSIS config file for several packages. I will need to pass in different environment variables for FTP sites and...

Config files are still used with SSIS 2012,...