Hello,
I've written a DTS to copy selected objects (stored
procs/tables/functions etc - data from tables also) over from a source
database to a destination database. I'm using 'Copy SQL Server Objects Task'
to do the actual transfer. The problem is that I need to get this DTS from
the development region to a client site (different network - different server
names).

I save the package as a .DTS file and try to import it onto the client's
server - when I change the source and destination server/database names, all
the objects that I had selected (checked) become unchecked.

Is there another way to do this?
Thanks!

Hi Bob,

Its going to be happen because you are changing the ServerName & DBName. SQL
Server will repopulate the objects according the new instance.

You can work around by changing the connection properties run-time using
ActiveX Script Task. I guess you have same object name ( ie. tables, SPs ext
) on both the server ( Source as well Destination ).

It will be look like...

Function Main()
dim Con, pkg

set pkg = DTSglobalvariables.parent
set Con = pkg.connections("your sql connection name")

Con.datasource = "newdatasouce"
Con.Catalog = "newdatabasename"
Con.UserID = "UserID"
Con.Password = "pwd"

Main = DTSTaskExecResult_Success
End Function



--
Knowledge is not Power !!!
But When its acted upon then its Power !!!


"Bob" wrote: