If the url is known to contain non-unicode characters then varchar would be fine, if you are not certain, then you'll have to stick with nvarchar to be sure to...

Let me know if I am on the right track with this:

if object_id('tempdb..#customer1') is not null drop table #customer1

if object_id('tempdb..#customer2') is not null drop table #customer2

Create table #customer1 (customerid int...

I sure hope there is a better way, mines a pretty inefficient way to do things.

Found the following here

http://blog.infotoad.com/post/2009/09/08/Reporting-Services-2008-Using-XML-Data-Source-type-and-Querying-a-Web-Service.aspx

Hope it helps...

Common error: The dataset ‘GetReturnValue’ contains a definition for the Field ‘GetReturnValueResponse’. This field is missing from the returned result set from the data...

Not being terribly familiar with what you are working on, I'll just take a stab at it.

Could this have something to do with the permissions granted to whatever is running...

I've done something similar using a foreach loop going over a recordset, this in turn runs a vb component that sets the value of a SSIS variable that is used...

I can't seem to think of a way to do this without the GROUP BY clause, either. I suppose you could build something to do it, but I think you'd...

Congrats, I'm saving this for future reference for myself. I can't imagine why it wouldn't be documented.

I'm glad you were able to get it to work.

Okay I tried a few things that you think would logically work. They didn't. I did come across this page, didn't take time to try it out.

"Continued" Header on Subsequent...

Hmm, you're right, I just checked. I'd have to do some more searching. Just one more of those things you'd expect would be there that isn't.

The more I think about this, the more familiar it seems. I have had to find workarounds for a few different things that seemed like they should have been part...

Amy, I have not run into this issue myself, however I have had some crazy things happen when using rdl files. My suggestion was based on what I could find...

It would appear so, at least based on the two situations you asked about so far. If you are curious regarding transactions in general then I would suggest some web...

Ahh, I see. Thanks.