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: )

446 reads

Blogs

Power BI Monthly Digest – August 2020

By

In this month’s Power BI Digest Matt and I will again guide you through...

Daily Coping 14 Aug 2020

By

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

Setting default values for Array parameters/variables in Azure Data Factory

By

(2020-Aug-14) Setting default values for my parameters or variables in Azure Data Factory (ADF)...

Read the latest Blogs

Forums

Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

Location Data Privacy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Location Data Privacy

TextBox Property>Action>GotoURL for Multiple Values?

By jbalbo

Hi I am using two stuff commands in my query. One gets the date...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers