DTS Transformation Query

To transfer all the DTS package from one SQL Server to another.Create a DTS package.Select source and destination SQL Servers Create a DataPumptaskGo to disconnected editIn the DTS Data transformation task Set a) DestinationObjectName: [msdb].[dbo].[sysdtspackages] b) SQL Statement : SELECT a.name, a.id, a.versionid, a.description, a.categoryid, a.createdate, a.owner, a.packagedata, a.owner_sid FROM msdb.dbo.sysdtspackages AS A INNER JOIN […]

2005-11-24 (first published: )

448 reads

Blogs

T-SQL Tuesday #137–Notebook Uses

By

It’s actually my month to host T-SQL Tuesday, and I came up with the...

Daily Coping 13 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Converting a SQL Server Docker image to a WSL2 Distribution

By

Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...

Read the latest Blogs

Forums

Sorting in R

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Sorting in R

Oracle sequences: The basics

By Additional Articles

Comments posted to this topic are about the item Oracle sequences: The basics

Bug Management

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Bug Management

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Sorting in R

See possible answers