Re: Migrating DTS Local Package from test to production environments v7.0

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 07:17:56 -0000

Moving between environments can be problematic if you do not do some
thinking up front. A connection may be pointing to a test server,test
database or using a login that does nto exist anywhere else. You need to
think of this up front. In 2000 you have the Dynamic Properties task which
let's you set just about every property in your package retrieving the value
from an external source (INI File, Query, Constant etc).. This means your
package couldn't care less where it is so long as it can read the
configuration information it is happy. In 7 I use a workaround as we have
no DP task. I create a database table which the values I want. I create an
aliased server on the server called DTSSettings which points to wherever the
environment's configuration server happens to be. I then use a DataPump
task to load the values into Global Variables. I then use the Global
Variables in property assignments. We have loads of examples of changing
stuff in a package at www.SQLDTS.com

Hope this helps. 

-- 
----------------------------
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Ted" <myitpro@att.net> wrote in message
news:Os1gzSz%23DHA.3496@TK2MSFTNGP10.phx.gbl...
> In a class I took there were some warnings given about creating a DTS
> package in a test environment and then moving it to a production
> environment.  Sadly, I can't find my notes anymore! :-(
>
> Does anyone know the subtleties of doing this migration?  I have a client
> I'm going to tomorrow who is having this problem and I'd like to fix it
real
> quick for them.
>
> Ted
>
>

Relevant Pages

  • Re: SQL 2000 - Connection Error with DTS Packages
    ... After I changed all SQL Server 'Database Connection' steps in each of my DTS ... Package" option when you right click a DTS package name in ME. ...
    (microsoft.public.sqlserver.dts)
  • Re: curious problem in production
    ... >> trying to insert into the same sql server database. ... >> if it fails in calling the production environment. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: curious problem in production
    ... >> trying to insert into the same sql server database. ... >> if it fails in calling the production environment. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Scheduled DTS package fails
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... There is no file associated with the package. ... package simply copies data from one database to another database. ... The account the agent runs under is different from the account that created ...
    (microsoft.public.sqlserver.dts)
  • Re: Scripting a SQL database
    ... Virtually everything SQL Server Enterprise Manager does can be ... To run the generated script in ASP, ... You can also create a DTS (Data Transformation Package) ... that you'll want to select the "copy database objects and data" ...
    (microsoft.public.inetserver.asp.db)
Loading