Can you post the query?

Is that key an integer or string?

With SSIS you can drop files into a shared folder.

It's up to the code of the website to pick that file up.

No, I would read the file and write it entirely to a staging table.

Then I would read this staging table with a FOR XML clause and insert the results in...

Basic, easy question? I never use the damn thing 🙂

Thanks for the question, it was very interesting to learn a bit more.

There are several ways to deploy a cube from one environment to another, and this is one of them.

I actually laughed out loud.

jcrawf02 (3/14/2012)

---

IT'S A BOY!!!

I won't get to meet him for a few months still, but very excited!

So now the important question is, do we let him watch Star...

I'm going to frame this one.

Where do you convert the data of the second column? It is converted somewhere, as CSV is all text. Is this in the source, or do you use a derived...

Never, I don't even know what it is 🙂

Apparently there's an error in the syntax. Did you specify a SQL statement or something like that?

Any ideas on this one?

http://www.sqlservercentral.com/Forums/Topic1266589-391-1.aspx

Are server A and B in the same domain?

Ah ok. Maybe change the owner of the job to another account than sa?

sa is a built-in account, so that also uses the local system account for connecting.

Unless you code the XML yourself in a script component, I don't think so.

But I would skip the step where you read the temp table out with FOR XML, put...