November 18, 2011 at 6:10 am
I rather new to BIDS.
Have a package that pulls data from production system into an Access database for enduser consumption.
I would Like to do a check of data in system to data just dumped into Access. Advice appreciated.
(Which task and how could it be done?)
I have created two sequence containers - that each populate a variable - now I want to compare those counts and throw up a error if they don't match.
Good bad - any suggestions?
November 18, 2011 at 6:53 am
I would compare the values of those two variables in a script task.
http://www.programmersedge.com/?p=1350
You can throw an error there:
Make sure the variables are scoped correctly so that the script task can find them.
What kind of data checks, aside from this one, would you like to do?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply