Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Create a custom package tu update dimension with SSIS

Hello,

I have created a custom package with SQL Server 2000 (DTS) which is used the MakeDim package. It executes a store procedure. This procedure initializes a dimension source table. Then the package updates the dimension using the source table and the MakeDim package.

Now I want to do the same with SQL Server 2005 (SSIS) but I don't know how I can add MakeDim package in my SSIS package. Indeed, in SQL Server 2000 you just have to register a custom task with the k2DTSMakeDim.dll.

How does it work with SSIS?

thanks for your help,

Romuald

Former Member
Not what you were looking for? View more on this topic or Ask a question