I don't know what kind of vbscript transformations you're doing. Most I've seen are string manipulations combined with if then logic. This can all be done in SQL.

I'd be interested to see how and why you're building dts packages from within dts packages... I have written stored procedures that build and execute sql, but never packages that build and execute packages. Got an example to share?