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

447 reads

Blogs

Basic JSON Queries–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Daily Coping 30 Nov 2020

By

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

Building a Raspberry Pi cluster to run Azure SQL Edge on Kubernetes

By

A project I’ve been meaning to work on for a while has been to...

Read the latest Blogs

Forums

Operand type clash: text is incompatible with datetime2

By AMCiti

Dear Group: I am not sure what is causing this, and having a terrible...

Can I clone a database across servers?

By SQL Guy 1

Hi all, I have a database that resides on server A and I need...

Costing per database

By TJ_T

Hi, I am just checking to see if anyone has ever did a costing...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The TUF File

See possible answers