Well, it's a script component (there is a difference) and I attached a zip file that contains an excel file and an SSIS package that reads the excel file and...

Thanks for the effort. I'll do a search as well.

You can also use an asynchronous script component. I'm attaching a complete example.

rgoerwit (8/6/2009)

---

Taking a somewhat different tack here, I'd just note that summarily turning off access is usually bad form. The correct approach (which you may well have tried, so...

Do you...

To the best of my knowledge there is no way natively to do this in RS. You could hack around it by creating a parameter for the report where...

You can do quite a bit without any scripting knowledge.

Is your report server on a named instance?

Why are using a script component? Is there more you are doing in the script? I think you can probably do what you need with the builtin components...

I really don't think this is where you are getting the error. Can you post the table definitions, some sample data, and attach a sample excel sheet?

Can't fix...

I don't see why that would throw the error you are getting, but I was going to comment that using the Dynamic SQL, Exec(Sql string) is unnecessary. Try removing...

Jeff Moden (8/5/2009)

---

Jack Corbett (8/5/2009)

---

Hey Steve, check out this guys posts (http://www.sqlservercentral.com/Forums/Search1-0-2.aspx?SessionID=euwat2555c1qqdnch3bhfpq1&SortBy=2&SortOrder=1) both have turorials as Word docs attached. I didn't read the docs, but did suggest they...

I don't see anywhere in that stored procedure where you'd get more than 1 value from a subquery. The only thing I can suggest to troubleshoot is to run...

Wow, and I thought you were old enough to remember the programming language too!

You can have 2 precedent constraints and have them check the value of the Count variable. On the precedence constraints (green arrows for success) you'd change the options to:

For...