Technical Article

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 […]

You rated this post out of 5. Change rating

2005-11-24 (first published: )

453 reads

Blogs

How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database

By

I have recently had the privilege of working with multiple clients who have been...

KDA: Echoes of Deception - Onboarding

By

I’ll walk through the KDA UI and tackle the first challenge before diving into...

Kusto Detective Agency - Intro

By

While I mostly write about SQL Server, I have a soft spot for Kusto....

Read the latest Blogs

Forums

https://officialsprinklezshop.com/Sprinklez Peanut Butter Jelly Milkshake Strain

By favouritechemist

Website: https://officialsprinklezshop.com/ Buy Sprinklez Strain From Official Sprinklez Shop. 100% Trusted, Top notch quality product...

https://officialsprinklezshop.com/Sprinklez Pink Magic Strain |Gleamy Dream Cake

By favouritechemist

Website: https://officialsprinklezshop.com/ Buy Sprinklez Strain From Official Sprinklez Shop. 100% Trusted, Top notch quality...

https://officialsprinklezshop.com/Sprinklez Pink Magic Strain |Gleamy Dream Cake

By favouritechemist

Website: https://officialsprinklezshop.com/ Buy Sprinklez Strain From Official Sprinklez Shop. 100% Trusted, Top notch quality...

Visit the forum

Question of the Day

The Monitor Server

What does the monitor server do in log shipping?

See possible answers