Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SSIS and Import/Export (2008)  Slowly Moving Dimensions defaults

Author  Topic  clufus Starting Member 1 Post Posted - 2009-11-23 : 14:23:06 I have start and end dates on my tables. I have default of 12-31-9999 for end date My problem is that the slow moving dimensions defauls in the read of current rows "where start date is not nul and end date is null" i can edit it, BUT on a rebuild of the SMD it resets. Any way to overide this at the package or better the project level? Thanks in advance