| Kevin Lang 2005-06-10, 8:58 pm |
| Take a look at using global variables and the dynamic assignment task. The
dynamic assignment task will assign values to object properties at run time
based on a variety of sources.
The source could be a a global variable, an .INI file, a query, etc. These
sources could reside on each server with the appropriate values. This works
well for all connection strings. You should never have to edit the package
once it makes it out of Development.
Good luck with this!
"Sean Aitken" wrote:
> Hi,
>
> We are trying to simplify our lives a bit and be able to develop a DTS
> package in dev and have it pushed to test and stage, with the minimal
> amount of modification to the packages.
>
> It seems that the client 'alias' option works well for SQL connections,
> however, when we have a file export task, the target filename contains
> the name of the target server. We would like a way to make that
> dynamic... WITHOUT creating a thousand mapped drives.
>
> Any ideas?
>
> Best regards,
> -Sean
>
|