Skip to Content

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

Create a custom package tu update dimension with SSIS


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,


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