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,