Hi
I have a DTS package which contains Execute Package Task. The package works smoothly on SQL Server A
Consider following scenario
1. I save main and inner DTS package on Server
2. When I try to execute main DTS package, I get an error that the Package Version ID of inner package is not correct.
3. After this, I update the version id of inner package in Execute Package Task.
With this updated version ID, DTS package runs well on Server B as well

My problem is I have got around 20 inner packages and I need to deploy this on different SQL servers frequently
Is ther anyway to automate the the loading of DTS package from one server to other without bothering version ids of DTS Packages

Thanks
Aji

Have a look at this

Make the Execute Package Task name dependent only
(http://www.sqldts.com/default.aspx?216)

--

----------------------------

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


"Ajit" <anonymous (AT) discussions (DOT) microsoft.com> wrote