Look harder at the word 'this' 🙂

You may find this interesting.

So, in effect, you're trying to build a file-status table in memory and then issue a single commit at the end of package execution to write it to disk?

Koen (da-zero) (2/9/2011)

---

Stringzz (2/8/2011)

---

The DBA informed me that the system user is a startup user for sql server and agent service and has "SA" rights, so it should have more...

I agree, this seems puzzling. Is there anything in the Event Log?

Could this be relevant?

ranganathanmca (2/8/2011)

---

Hi guys.,

How to fetch 3 differente(excel,csv,flatfile..) file in single source control ? any possibilites to do that?

please share some...

I suggest that you learn - it is a better tool to use in this situation.

Do you have SSIS installed on the machine you are doing this?

Is there any reason why you are not using SQL Agent to run the package?

For the benefit of any others...

Most people here pick things up pretty quick.

Using a thesaurus to say the same thing in several hundred ways isn't going to impress anyone.

Although I agree with you, did you notice that it's his/her first forum post?

Maybe when they get to 30 or 40 posts, you can start slamming them for any dumb...

That's better. You can do that using a subquery - something like this (untested):

SELECT

t2.SumGross,

t.BOOKING_ID,

t.KL_EQUIPMENT_TYPE_CD,

etc etc

FROM tablename t

JOIN

(select t1.Booking_ID, Sum(t1.Gross_Wgt) SumGross

from tablename t1

group by t1.Booking_ID) t2

on t.Booking_ID...

Probably.

But unless you provide a better description of what you are trying to achieve, that's the best answer I can provide.

Here[/url] is a link to an article which will describe...

Haha,...