I think Anthony meant "custom triggers" - Winnie the Pooh's mates were not that hot when it came to database theory, customised or not 😀

There is another possibility. If your...

How is this question related to SQL Server?

Anthony pretty much laid it on a plate for you and still - no DDL. I'm out.

raghuldrag (7/20/2012)

---

accountno transaction amount date

==========================================

A-123 Cr ...

OK, I thought about this a bit harder.

How about this?

(@LoopRecordCountPrimary+@LoopRecordCountSecondary)==0

emmadcst (7/19/2012)

---

I had been using SQL but not very sure about this query. Will have to look into this further. We had been tracking time for business purposes as required...

It's in Visual Studio. While editing a package, select the 'Project' menu item and then...

I must be missing something (seems too obvious), but surely something like this?

(LoopRecordCountPrimary > 0) || (@LoopRecordCountSecondary > 0)

May I suggest that you try implementing this (your SQL code) as an SSIS expression, rather than by using parameters. It's worked for me in the past ...

Yeah, you'll be needing a SQL/XML ninja for that explanation:w00t: I only found that function today while hunting for a solution to your problem and I haven't yet got to...

Out of interest, can you explain why you need this?

Should be easy enough via some dynamic SQL - not sure it will be possible otherwise.

There should be no issue at all if you go down the path you suggest in your last sentence. You are not updating data, merely reading it.

In this case, as far as I can see, a UDF is your most straightforward solution. I quite like this one:

create function dbo.StripHTML( @text varchar(max) ) returns varchar(max) as

begin...

debanjan.ray (7/17/2012)

---

Hi,

While inserting into destination table through SSIS, some times I am getting a peculiar error. Some times few rows are rejected without any reason. While re-executing those DFTs those...

Between the source and destination, are you doing any lookups?