|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > DTS - Pointing existing package at a new database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DTS - Pointing existing package at a new database
|
|
| Richard 2002-11-11, 4:23 am |
| I have to do a few thousand transformations in DTS.
Both source and destination are SQL 2000 but there are many transformations
to be done (change of datatype, combining multiple columns into one,
splitting one colum into many, trimming etc....)
I'm setting up the DTS packages on a test version of the old and new
databases, but will eventually run it on the live databases. Is there a way
to save the package, and then to change the databases without having to
recreate all the transformations from scratch ?
Richard
| |
| chris 2002-11-11, 10:24 am |
| Open the package. Go to package/ save as/ pick a new name. You then have
another version to do whatever you want with.
"Richard" <richa@heidmar.co.uk> wrote in message
news:n7Lz9.2233$9R.9896788@newsr2.u-net.net...
> I have to do a few thousand transformations in DTS.
> Both source and destination are SQL 2000 but there are many
transformations
> to be done (change of datatype, combining multiple columns into one,
> splitting one colum into many, trimming etc....)
> I'm setting up the DTS packages on a test version of the old and new
> databases, but will eventually run it on the live databases. Is there a
way
> to save the package, and then to change the databases without having to
> recreate all the transformations from scratch ?
>
> Richard
>
>
|
|
|
|
|