ok, thanks for the info. I guess that's the only way to do it then.

I now understand why the error occurs. I don't have the for-each loop set up correctly to process multiple files at once. It won't move to the next file and...

Hello again,

I read some articles, watched videos but still there are two things I'm struggling with at the moment:

a) like I explained earlier, handling two or more files coming in...

thanks for the explanation.

I've tried setting up my project like your sample pic, but I only looped for 5 times. However I get an error when I put two or...

Hello,

thanks for this great and detailed article. I've just started to get my head around SSIS and since I have a quite similar task to deal with, I'll take the...

matching a pattern -...

for the expected output I'd be happy with a simple true or false - as in the exist-method.

The language is supposed to be XQuery (I know the keywords shouldn't be in capital letters) 🙂

My main problem is to transform the loop-construct to work with TSQL-Syntax, since...

Hello again,

I'm still trying to narrow down on a topic, thanks for you suggestions so far.

Like I mentioned, I like working with XML but unfortunately I don't really have...

GilaMonster (5/11/2010)

---

What level of work is this for?

Do you just have to produce a summary of a particular area? Say, how a particular feature works, how it's used, etc?

Is this...

If you scroll down to the bottom of this page

you can see an approach I first had in mind.

The thing is I want triggers (or whatever does the job...

Sergiy (9/21/2009)

---

"status" indicates a result of actions taken on an entity, or lack of any action.

Every time you query for results of different actions - you name it different statuses.

So,...

so I'll end up with 6-7 Status tables - haven't seen that before 🙂

And do you think my first approach is too difficult or maybe even wrong?

To me it looks...

To tell you what the database is all about: Customers can borrow tools for a certain amount of time: like chain-saws, power drills and so on.

I want to be able...

thanks for your quick reply.

hmmm...the thing is that most of these states will be duplicates. For example a customer can be "locked" and a product (for review) too. So...