Good websites for Custom Components

Hi,
I am pretty new to SSIS, so I really appreciate the help!
I have been building a few packages for the ETL in a mini data warehouse and
I have come across a few tasks that are very common. These include things
that, ensuring the business/natural key(s) are unique, or ensuring
many-to-one hierarchies are not violated. These kinds of tasks would be used
over and over again in almost any ETL project with different inputs.
Does anyone know of some good websites were users share their custom
components? I would like to avoid building this kind of thing if someone else
has done it already.
Thanks
There are a couple of sites that share some custom SSIS components.
http://www.sqlis.com/
http://www.sqlbi.eu/
However I feel I should add that for both the examples that you gave, I
normally enforce at the relational database level using unique
contraints and foreign key relationships.
Regards
Darren Gosbell [MCSD]
Blog: http://geekswithblogs.net/darrengosbell
*** Sent via Developersdex http://www.codecomments.com ***
|||Thanks Darren.
The two you mentioned are two of my favorites at the moment. I just want to
keep looking for more!
As for enforcing these using a relational database...It would be great if I
could do this, but I am going to be doing these kinds of checks on many
different inputs. It would take a LOT of time (both design and run time) to
put all of these into 3NF just to check for these flags. At the same time,
with the type 2 changes, I could only use the built ing relational
constraints if I filtered by "validAt" before importing the flat files into
the database.
Thank you very much for your help!
"Darren Gosbell" wrote:

> There are a couple of sites that share some custom SSIS components.
> http://www.sqlis.com/
> http://www.sqlbi.eu/
> However I feel I should add that for both the examples that you gave, I
> normally enforce at the relational database level using unique
> contraints and foreign key relationships.
> --
> Regards
> Darren Gosbell [MCSD]
> Blog: http://geekswithblogs.net/darrengosbell
> *** Sent via Developersdex http://www.codecomments.com ***
>