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


Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers


Welcome back to my Power Platform Quick Tips series! In this second episode we...

Simple-Talk Article…Understanding Azure Storage Options


Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...

T-SQL Tuesday #120 – Recap


The wrap up post for T-SQL Tuesday #120. 9 bloggers contributed this month. The post...

Read the latest Blogs


Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Performance issue SSIS package from Oracle server

By alex.palmer

Hi We have a performance issue pulling data from an Oracle server into a...


By sabbir9

https://livegameit.com/the-rsm-classic-live/ https://livegameit.com/the-rsm-classic-2019-live/ https://livegameit.com/the-rsm-classic-golf-live/ https://livegameit.com/the-rsm-classic-golf-2019-live/ https://livegameit.com/rsm-classic-live/ https://livegameit.com/rsm-classic-2019-live/ https://livegameit.com/rsm-classic-golf-live/ https://livegameit.com/rsm-classic-golf-2019-live/ https://livevsh.com/the-rsm-classic-live/ https://livevsh.com/the-rsm-classic-2019-live/ https://livevsh.com/the-rsm-classic-golf-live/ https://livevsh.com/the-rsm-classic-golf-2019-live/ https://livevsh.com/rsm-classic-live/ https://livevsh.com/rsm-classic-2019-live/...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers