Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ashish.johri
Starting Member
10 Posts |
 Posted - 2007-10-09 : 11:13:38
|
| Is there any table where we have source connection and destination connection information about the DTS packages?None of these tables in the msdb have this information.1) sysdtscategories2) sysdtspackages3) sysdtspackagelog4) sysdtssteplog5) sysdtstasklog6) sysdtspackages907) sysdtspackagefolders908) sysdtslog90Regards,Ashish Johri |
|
|
ashish.johri
Starting Member
10 Posts |
Posted - 2007-10-10 : 10:07:27
|
| There should be some table in the DB which contains information about the Source and Destination DB for the DTS package.Regards,Ashish Johri |
 |
|
|
ashish.johri
Starting Member
10 Posts |
Posted - 2007-10-10 : 10:56:11
|
| I have 237 packages in my DB. I need to change the source DB for all of them as the source server is changed now. Plesae let me know how to do this.Regards,Ashish Johri |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-10 : 22:45:30
|
| There is no easy way as I know, and you can't update system tables in sql2k5. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-10-11 : 06:18:26
|
| You should make the packages configurable.I always have global variables for the server and database and these are set via dtsrun or from an ini file.File paths are treated in the same way.The package is saved as a blob (much simpler to save it as a file anyway). It's not actually anything to do with sql server and sql server doesn't know about the package other than it has the blob in a table. Don't be confused by dts being distributed with sql server and the ability to save a package in msdb - it's just a client application.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
ashish.johri
Starting Member
10 Posts |
Posted - 2007-10-11 : 10:22:23
|
| Hi nr could you pls provide me some link which describes how to create the configurable packages?Regards,Ashish Johri |
|
|
|
|
|
|
DTS packages source connection