------------------------------

our knight in shining armor

------------------------------

Well! Thank goodness for Brian Knight, he posted the first not-a-file-folder loop example I've been able to find all week.  So I finally have a SQL...

Great to know.  thanks a million!

Now that I'm starting to get the hang of SSIS it doesn't seem so bad or extreemly slower to develop than DTS (which I loved and used a lot).  There's a...

thanks all.

yeah it was a big wide problem.  ended up uninstalling SQL 2005 full and express editions and reinstalling the server.  since then it's been fine.

much appreciated!

I was just getting the same problem.  Restored the database, added the login to the server and provided it with the same default db as before.

I had to run the old...

OK, thanks gang!  That helped a lot.

Yeah, I came here to see if anyone talked about what connection it was talking about.  I agree a bit more info in the question would have helped... now it's...

thanks gang!!!

much appreciate the help with this vague term.

Also found this third party soft ware independent of Reporting Services.

pretty cool I thought

http://www.dynamicpdf.com/

Great, thanks you 2.  Will try it out!

Try running them and view the execution plans.  They really do sort differently.

Yeah, this one was pretty badly written.  It required a lot of the reader to fix and figure out.  They may not have a budget for a technical editor but...

Man oh Man!! this thread is longer than the OED and must set a new record for the use of smiley faces.

Execution plans did reveal the differences in sort behavior....

mmm... Well if asked "How do you determine which version, build, and edition of SQL Server you are running? " I'd still answer @@Version and think it is the correct answer......

Ah, got me.  Great Pic!

I'm still watching my back tho.