> Hi,
>
> under sql server 2000, do you know how I can access via vbscript to
> the dts code and make programmatically some changes ? what are the
> usefull api's ?
>
> for example, I want to change database properties
>
> of course, I can write the dts the correct way in order to handle
> different server/databases
>
> my question is related to the amount of dts I already use and need to
> changed every time I deploy then from dev to prod
> I believe it should be more simple to write a 20/50 lines of vbscript
> instead modifying more then 100 dts by hand
> This should be possible since somebody has written a tools to
> move/export a dts from one server to another one.
>
> many thanks
>