export

Technical Article

Import Multiple Packages to SSIS server

  • Script

We cannot import multiple packages on the SSIS server. So, loading 100 packageS from  file location will be a tedious task for a DBA. We can solve this issue by making use of the DTUTIL utility. The DTUTIL utility can also import one package at a time, but we can write the batch file using the […]

You rated this post out of 5. Change rating

2021-09-27 (first published: )

1,344 reads

SQLServerCentral Article

Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules

  • Article

Being able to get information and save it on a Excel as a report can be a common and tedious task. What if we could join dbatools and ImportExcel PorwerShell modules to accomplish this in a easier and fast way? We will see how to export roles and its' member and save that info on a multi spreadsheet Excel file with handy tables ready to be explored.

5 (2)

You rated this post out of 5. Change rating

2020-06-30

5,935 reads

Blogs

Extended Events in Azure Data Studio

By

I know I can use extended events (xevents) in Azure SQL DB when in...

Azure Workbooks

By

I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...

SQL Prompt Tips–Using $surroundtext$ in a Snippet

By

A user on the SQL Community Slack was asking about what the $surroundtext$ variable....

Read the latest Blogs

Forums

data security for a data warehouse

By pietlinden

I'm working with someone whose client says "Yes, we have a data warehouse. But...

AI Tools

By plycons

Not quite sure where to post this or how quite to ask as its...

Review of DB Activity

By HeadScratcher

Hi Folks,   I have been tasked with reviewing all the activity on a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers