Because of privacy issues regarding the SSN, I would never recommend using it as a PK. When used as a PK, it will exist as in FK in multiple...

I'd like to add the warning about grabbing files instantly--sometimes the complete file is not available. I've seen that happen. Setting the check for 15 minute intervals still...

Change the empty string to some unused date (eg 1/1/70) then convert to null after import.

Finally, a word of warning; your BI is only as good as your data. The reports you generate will likely become a nightmare really quickly if data completeness/quality is...

Had a case just yesterday where having the FKs in place led us to find that a customer hadn't provided information on 5 zip codes for a process that had...

Yes, setting the delay validation to true will work. Not only on large packages but also for data readers to certain types of sources.

VB Script has been included in SSIS 2005 only for backwards compatability. It has been deprecated and accorading to MS will be removed from the next version. According...

That's an interesting idea with the NOCHECK constraint. Doing that will allow you to take advantage of 2005s ability to file non conforming ones to a type of UNKNOWN...

Maybe I should have...

During ETL, loading Facts we always do a lookup with the dimensions to ensure that data gets filtered. In other words fact tables will contain only that data whose...

No, that's not all I want to do. I run several that way. What I want to do is take a date output parameter, update two variables, and...

I know no one replied on this forum, but did you find anything? I'm trying to do the same thing but have had no success.

I understand your point about the data cleansing. Why should it be necessary? One, it will help analysis services when you import the tables because it will see...

I have found with Excel 2003 is that is works well without the special additions, but it lacks features such as the drill through ability that a lot of users...

You could also script an ADO recordset and move through each row, applying what you need to record by record.