Darren Gordon


Technical Article

Script ALL DTS packages on server to text files

This VB script allows you to search DTS packages for keywords, etc. It is also useful for quickly locating what server a given package is on. This is very useful for debugging. Example - you want to know the name of every DTS package the touches a certain table. The text files generated contain the […]

4.9 (10)

You rated this post out of 5. Change rating

2006-01-18 (first published: )

5,963 reads

Blogs

FDD 2023 – Session Materials

By

You can find the slides for my session at Future Data Driven summit at...

Quick Filtering in SSMS–#SQLNewBlogger

By

I saw someone limit the databases they see in SSMS, which isn’t something I...

Penetration Testing your SQL Server, Part 1 – The Recon Mission

By

Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...

Read the latest Blogs

Forums

Write https request to azure blobstorage

By Charmer

Hi All, I have been trying to download a csv file which is produced...

High tempdb usage alternatives

By anoop.mig29

Hi We have an stored procedure which runs frequently and  it contain logic in...

high latency in sql server transactional replication

By anoop.mig29

Hi I am new to replication and we have database of size around 2TB...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers