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!

Here's one way, I think

update it

set Add1 = s.Add1

,Add2 = s.Add2

from dbo.items_test it

join dbo.Staging1 s on it.Location = s.Location

and it.ProdCode = s.ProdCode

and it.Customer = s.Customer

where it.Date_Effective =...

Jason-299789 (2/6/2013)

---

Phil,

It was aimed as more of an example of how to generate the basic data (ie a Sequential date), so that you can then start adding on the...