Embedded 2000 Package Question/Issue

Hi All,

I am facing with a very intersting question here.

I have an embedded DTS 2000 package inside my SSIS 2005 Package. This DTS 2000 package just execute a transfer from a DB2 server to the 2005 server. Its a very simple transfer, without any transformation ( just column to column ).

Well, when I edit the DTS 2000 and save it, the package size increases about 100/200kb. It sounds like the package version ( the same as we have in the 2000 environment ). But i dont know how deactivate this "auto-increase".

Anyone can help me with this auto-increase? or just explain me what is happening?

Today I have packages with 9mb and just 3 or 4 embedded DTS 2000 packages inside.

Thanks in advance.

Thiago

Hello All,

Any answer?

After 3 months migrating DTS packages to SSIS packages we have some packages with 16mb of size. The SSIS packages which has incorporated 2000 packages, increase size every time we change anything on the 2000 package.

We are considering redesign those packages but we want to make sure that we are not missing any configuration.

Thanks for your attention.

Regards,

Thiago

|||DTS 2000 keeps every version you've saved, so it keeps growing each time. Unfortunately, unlike Enterprise Manager in SQL 2000, SSIS provides no easy way to manage the versions and cleanup the old versions. I've opened a bug for this issue in product defect database.

As a (long) workaround, you may save the DTS package as a file (right click the DTS designer surface, select Save As - this will save the latest version only), then switching the task to use this file instead of embedded package, finally use "load DTS 2000 package internally" in task editor. This way you'll get rid of all the old versions of DTS 2000 package.