Technical Article

RE: DTS Question

  • Reply

I would use a combination.  Run the execute task to run your pre-queries.  Use the data driven task to run the query that outputs to the file.  The data driven task is well documented elsewhere.  You should have no trouble finding out how to do this.


Technical Article

RE: Changing SA password breaks DTS packages

  • Reply

I did restart the physical machines after the password has changed. I also looked thru all the connections within DTS packages and did not find any reference to SA. I ended up spending all day re-saving the packages and rescheduling them. I have to change the passwords again in 45 days and it will be […]



Hyperconverged storage tuning tip for SQL Server


We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022


Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight


This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs


Can someone explain where non - clustered index is stored?

By yourjobismine

I am learning non-clustered and clustered indexing. When reading this article,involve%20any%20extra%20lookup%20step. came across this...

Null value when checking unused indexes

By Bruin

I'm using this query to check if I have any unused indexes.. One of...

Retrieve Password from CyberArk using powershell

By Alone

Hi, I am new to Powershell script and i have to create a power...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers