Ashish Kumar Mehta

DTUTIL Utility to Copy / Delete SSIS Deployed in MSDB to File System

Use the DTUTIL Command Prompt Utility to Copy / Install / Delete the SSIS Package deployed in MSDB Database to file system

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(27)

You rated this post out of 5. Change rating

2008-07-09

20,205 reads

After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...

Hello, dear blog reader. Today’s post is coming to you straight from the home...

This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...

Comments posted to this topic are about the item Creating a JSON Document I

Comments posted to this topic are about the item Who is Irresponsible?

Comments posted to this topic are about the item Designing Database Changes Before Deployment:...

I want to create a JSON document that contains data from this table:

TeamID  TeamName  City          YearEstablished
1       Cowboys   Dallas        1960
2       Eagles  Philadelphia  1933

If I run this code, what is returned?

SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;