"Toff McGowen" wrote:

> Hello
>
> I have a DTS package that loads an Sql Server Database with data from MS
> Access datasource. The package works fine but I want to be able to change
> either the source or destination connection or both (for reuse purposes) and
> still have the package run.
>
> Note that regardless of the connection the schemas remain the same.
>
> My problem is that the DTS task seems to use the full path to the db
> including server. For instance locally a destination connection table might
> be referenced as aaa.dbo.MyTable1 whereas if i try to point the connection
> at another instance of the database on a different server the reference for
> the connection might be bbb.dbo.MyTable1.
>
> How do i abstract out the server name in eitheer/or both the
> source/destination connection? I want to be able to load clients tables with
> data by using the same DTS package and just changing the connection
> properties.
>
> Thanks
>
> TM
>
>
>

"John Bell" <jbellnewspo***@hotmail.com> wrote in message
news:85674B0C-13A0-481D-A7D3-241AD7824971@microsoft.com...
> Hi
>
> Check out:
> http://www.sqldts.com/default.aspx?201
>
> Global variables can be passed from the command line.
>
> John
>
> "Toff McGowen" wrote:
>
> > Hello
> >
> > I have a DTS package that loads an Sql Server Database with data from MS
> > Access datasource. The package works fine but I want to be able to
change
> > either the source or destination connection or both (for reuse purposes)
and
> > still have the package run.
> >
> > Note that regardless of the connection the schemas remain the same.
> >
> > My problem is that the DTS task seems to use the full path to the db
> > including server. For instance locally a destination connection table
might
> > be referenced as aaa.dbo.MyTable1 whereas if i try to point the
connection
> > at another instance of the database on a different server the reference
for
> > the connection might be bbb.dbo.MyTable1.
> >
> > How do i abstract out the server name in eitheer/or both the
> > source/destination connection? I want to be able to load clients tables
with
> > data by using the same DTS package and just changing the connection
> > properties.
> >
> > Thanks
> >
> > TM
> >
> >
> >