Tom Van Harpen (3/10/2009)

---

Sorry,

I have a staging table and the production table. I use a conditional split after a merge join (left outer) to determine if the row exists in...

I'll bet you're hoping that the input file won't get a load of extra columns added any time soon!

Too bad we can't write user-defined functions in the derived column editor...

Please post the full text of the error.

Which component is the cause of the error?

Please post the formulas for the expressions you have used.

--Edit: for those who are too lazy...

I agree with all that, except that this looks like an ActiveX DTS script - is that correct? If it is, a straight rewrite in C# is a waste of...

You haven't really answered the question - please look at it again. There is an article here which may give you some useful information about query analysis.

Or you could execute the SQL Agent job from a batch file instead - something like:

osql -E -Q "msdb.dbo.sp_start_job N'MyJob'"

It seems that Powershell can do it too. See here.

I suggest that you start editing your query manually & testing the results in Management Studio. Query builders can get you only so far.

Not that archaic ... so does C#.NET 🙂

OK, simpler version:

public void Main()

{

...

If possible, I would approach this slightly differently.

1) Set up your trigger to write data to a 'pending' table every time there is an update.

2) Create an SSIS task to...

Not quite.

You know that for some c.chg_ref_num, the filtering works as expected and for others it does not.

The suggestion is to find one that works and one that does not...

Please do this, as suggested already by Ninja's_RGR'us:

What I mean is find a row that is not correctly filtered. Get the input param from that row and run the function...

That is not T-SQL.

That's it? You expect others to take the time to craft a technical response to a question when you are not even prepared...