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?

INSERT and INSERT INTO are identical - INTO is there only as a readability aid.

There is no simple way of doing this.

I can think of three possibilities:

1) Output each row as a single column - you'll have to concatenate all the columns and add...

That does not look like a data conversion. After removing the quotes, I think you may need one of these.

simoniainsmith (7/13/2012)

---

Thanks for the reply.

Field is coming in as string, because if I set the column to DT_R8 then blank values which are quoted "" which causes a failure.

Hence why...

Have you defined the column as double precision in your flat file source?

If so, why do you talk about 'converting' to DT_R8?

Yes, but the Foreach loop (or some other technique) will still be required to take care of the varying file name ...