Have you considered a pure (ish!) SQL solution?

Haven't got much time right now, but have a look here[/url] & see whether it might be useful.

Please explain what you mean by "registers them in a log table" - are you actually processing the files or just recording their names?

namrata.dhanawade-1143388 (2/8/2013)

---

Hi,

In our SSIS package we have a lot of stored procedures which get called via a SQL task. These SP's sometimes have a union all or joins between lots...

That link is from 2007 - perhaps MS have modified their web site in the last six years ...

johmga26ssn (2/7/2013)

---

I have just read more closely ... I had thought the board was 2 dimensional. Yes, you just need a println() once you have printed the array: it doesn't...

rmatthias001 (2/7/2013)

---

Newbe question. I want to establish a key(either primary or unique) on a table that will receive a bulk load that is the output of an ssis package. Will...

Yes it can.

Please reread Anthony Green's post.

I'd say that your first task would be to get the package transferred to a location which is local to the server.

If you are using an RDP connection, that should...

opc.three (2/6/2013)

---

J M-314995 (2/6/2013)

---

If there is a way to import files using a wildcard character without having to rename the files (using a static file name), I'd sure like to...

Thanks for posting back - glad to help.

OK, I fixed up your sample data to use a proper IDENTITY PK and not to try and insert varchars into the INT bank_id column. Solution below:

IF OBJECT_ID('TempDB..#mytable1','U') IS NOT...

Methew (2/7/2013)

---

i have a table with three fields

id,bank_id,amount

it has alot of data....how i can select last entry for all distinct banks ?

lets say(Below code has not tested)

IF OBJECT_ID('TempDB..#mytable1','U') IS NOT...

You could add another level of nesting:

Expression < 0 ? 0 : Expression

where expression is the entire statement you currently have.

Or - slightly unorthodox - add another derived column transformation...

Great, no problem!