Update:

I have been able to solve this (after coming back to it after a little while) by using the dts.Events.FireCustomEvent method.

The method's signature is: eventName as string, eventText as string,...

took a bit of a stab at this one. did a little research on the internet and found all three terms cropping up with regards to an algebrizer (what...

I will probably get somewhere between 4-5 hours of solid "work" out of an 8 hour day. However, the time when I am not heads-down coding, testing, documenting, etc,...

to assign sql results to variables, you need to set the result set to single row and in the resultset tab add in the two variables to which you wish...

I'm not sure CTEs are the best solution here. Perhaps using a temp table or a table variable to hold the row or rows you require. Make your...

have you got any sample data you can post?

(see here for an article by Jeff Moden on a good way to post data: http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url])

Tom

have a look a this script for a generic audit trigger:

http://www.nigelrivett.net/SQLTriggers/AuditTrailTrigger.html

perhaps this addresses your issue?

Tom

you need to specify what you are comparing changedate - 5 with. at the moment, the query is saying that changedate - 5 should give either a true or...

when you say task do you mean the multicast transformation? it doesn't really matter where, but i would have it as the last step before the data destination. ...

sorry, no, i'm a bit tied up at the moment to knock something together.

which aspect are you struggling with?

yes. to separate the out the row identifiers use a multicast transformation in the data flow task and send just the identifiers (whatever makes up your primary key) to...

are you on bids sp1?

http://www.windows-tech.info/15/6014868d7d02fe0a.php

i have added the pic as an attachment here

hmm, perhaps your company blocks flickr?

if you send me your email address (you can pm if you'd rather) then I can send the picture as an attachment.

Tom

i get the following in the properties tab when i click on a variable:

if you click on that button the expression builder should open up