It looks to me like you may have added an 's'

Where Inserted.clPDBtypes=4;

just a quess but I assume this should be type not types

Not to ask a dumb question but since you are not looking for the vstextid parameter to come in have you tried removeing the where clauses that use the @vstextid....

In the navigation tab you should be able to select the parameters you want to be passed have you defined those?

I have always setup login mapping but I can not tell you now if I do that as part of a relex action or if it is becuase I have...

I was not so much disagreeing with you as much as I was challenging my own belief. The tempdb is a very useful tool and I am guilty of...

Another though would be that since the original problem states that the have to reboot would they not see a huge change in the amount of time it takes to...

I see what you are saying but surely a select of 20 Mil rows from a properly indexed table is not the same as writing 20 million rows to a...

In SSMS I would love to see some basic functions that have been around in any good code editor for a long time. If I miss a comma highlight...

With all respect

How would writing 20 Million rows to a temp table not be part of the problem even with the for-mentioned query problems. I would be very surprised if...

Yes that is roughly the idea. I define a blank spreadsheet give it pretty headers call the worksheet something useful. remove the extra worksheets that I don't need....

I may be missing the point but I assume you already determined the file name for import sinc you have that value can you not introduce that file into the...

I think the first thing you should check if you have not already is where is your tempdb located and what is the size of it? If your tempdb fills...

Assuming you are creating a new sheet from scrath then the default worksheet would be sheet1

the sheet name provided in the excel destination must match one that is in the...

Is the leading zero required? If it is and you are using a template excel file and not a new file then set that field as text in your template...

I am not sure how I missed this solution but here is a link to a page that handles this.

http://stackoverflow.com/questions/606621/reporting-services-parameter-constraint

The last option does infact prevent the query from being submited...