Luis Cazares (10/24/2016)

---

If you have the logic for today's age, you have the problem solved. You just need to change the way you approach your solution. In six months, they'll...

Thom A (10/24/2016)

---

If you are using your above logic, ensure you change your Current DOB logic as well. Otherwise, you'll notice that some other current ages will be wrong (such...

Thanks guys for the advice and solutions. I'll take into consideration the pre 1900 and post 2100 dob's but I think for right now it's ok.

Thanks again.

this seems to be working so far - but I'm still testing:

datediff(d,dob,dateadd(month,6,getdate())) /365.25

Thanks for your response,

yes one of my dimensions has a null value which I dont think is in the 'fact' table...how do I navigate to the fact table to check...

mbhandari (11/14/2012)

---

As you mentioned, tsql started and completed event will gather too much data that it will often be hard to analyze and get to what we are looking for....

Will performance be affected by a significant amount by utilising this job? Thanks

ok found the solution here:

http://onlytalkingsense.wordpress.com/2006/08/13/ssis-executepackage/

there is scripting solution to seperate out all the error messages returned by the main error message, it's quite simple to modify the code to suit your needs

http://agilebi.com/jwelch/2007/05/05/handling-multiple-errors-in-ssis/

I'm happy to parse the string, but where and how map do I pass the system variable to the user variable.

I tried doing it in package explorer by adding...

what i did was change the source from a variable to direct input and left the input blank and then built the expression. Now it emails the error message, but...

yes in onError event handler of the data flow task. Thanks

Dave Brooking (4/26/2012)

---

I have no idea what you are trying to accomplish with this, but you should be abe to use the statement

CASE [ApprovalID]

when '35CD3B40-DD5B-4231-9FF4-C4549BBAD6CF' then (select FirstName from user...

Thank you all for you're assistance, I think I'll need to redesign the query as what I want do I dont think is possible within a case statement, I think...

Hi thank you, the languagre is t-sql 2005