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

Would You Pass the SQL Server Certifications Please? What Do You Mean We're Out?

By

I have held various certifications through my DBA career, from CompTIA A+ certification back...

PASS Summit 2020 Mental Health Presentation Eval Comments

By

I first starting presenting on mental health last December in Charlotte, NC on mental...

PASS Summit 2020 Mental Health Presentation Eval Comments

By

I first starting presenting on mental health last December in Charlotte, NC on mental...

Read the latest Blogs

Forums

SQL Server Mirroring - Principal cannot set endpoint to Mirror

By arshishb

I followed the below guide & I am stuck on the very last step...

Virtual SQL - Standard vs Enterprise, per-core

By lanky_doodle

Hi, I understand that licensing all the Cores in a physical host with Standard...

Can I download Shapefiles for all countries from somewhere?

By pietlinden

I'm trying to get my head around the Geography/Geometry methods in SQL Server... are...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers