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.
| Author |
Topic |
|
SergioM
Posting Yak Master
170 Posts |
 Posted - 2014-10-13 : 12:21:18
|
| I have a temporal component to one of the tables in my database. I am trying to store all of the prices & inventory that were given to me over a period of time. In order to keep the db from growing astronomically, I only want to insert new information where the current data is different from the previous data. In plain SQL I would create a stored procedure, query the last row & compare the data then decide. Is something similar possible in SSIS?-SergioI use Microsoft SQL 2008 |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-13 : 12:57:56
|
| use the Slowly Changing Dimension transformation |
 |
|
|
SergioM
Posting Yak Master
170 Posts |
Posted - 2014-10-14 : 10:09:55
|
quote:
Originally posted by gbritton
use the Slowly Changing Dimension transformation
Awesome! I just started reading about it and it's exactly what I needed. Also, I had built a temporal db to the best of my ability, but using this forced me to do it the right way. Very useful!-SergioI use Microsoft SQL 2008 |
|
|
|
|
|
|
Check before import in SSIS?