Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > BOOK: Professional SQL Server 2000 DTS
Reload this Page program to edit dts package code in sql server 200
|
BOOK: Professional SQL Server 2000 DTS
This is the forum to discuss the Wrox book Professional SQL Server 2000 DTS (Data Transformation Services) by Mark Chaffin, Brian Knight, Todd Robinson; ISBN: 9780764543685
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2000 DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 25th, 2006, 12:33 PM
Registered User
  
Join Date: Jul 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default program to edit dts package code in sql server 200
Hi,
   In my company we have 1000 of packages, now we need to Modify them, I need to replace @@Identity with Scope_Identity() in every packages. (packages have more than 1 nodes). So I need a program which will open the package 1 by 1 and go through the 1 by 1 node and replace it.
Can some one plz help me?
Thanks
Sandipan





Similar Threads
Thread Thread Starter Forum Replies Last Post
Connect Seagate Crystal Report with SQL Server 200 abypvarghese SQL Server 2005 6 June 23rd, 2006 03:10 AM
Problem with AGGREGATE FUNCTIONS in SQL SERVER 200 vikiboye SQL Server 2005 1 February 20th, 2006 12:07 PM
generate XML from SQL server 200 table sasidhar79 SQL Server DTS 0 August 2nd, 2005 04:47 PM
problem 2 connecting SQL Server 200 using ASP.NET nagen111 ADO.NET 5 February 16th, 2005 01:26 AM
Moving a DTS package to another server boson SQL Server DTS 3 January 3rd, 2005 10:06 AM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.