Are you sure you have SQL Server 6.0?

Have you saved the package? Can you attach the package to the thread?

IMO, if you are using VS 2005 and RS 2005 and you do not want people to be able to directly access your reports on the report server you should...

What oledb provider are you using?

Have you checked the OLEDB providfer documentation for that error?

Sounds like you have a report that has many many rows and exceeds the Excel limit on rows.

Steve Jones - Editor (12/15/2008)

---

I think it's fool proof already. Just try to follow along!

And I doubt this will ever get by on track. We're off the tracks and out...

As I said in my first post, I don't think there is a way to do this outside profiler or the code I have suggested, and both of these would...

You can create databases with any application that allows you to connect to the server and issue SQL commands. You could download any one of many query tools out...

Lynn Pettis (12/15/2008)

---

Are you sure it shouldn't be posted here instead of there? One post is in SQL Server 2005 and the other is SQL Server 2008. In...

Lynn Pettis (12/15/2008

---

Just noticed, this is also double posted. It is also posted in a SQL Server Experss 2005 forum. What version...

I wouldn't use sa to connect that's for sure. You are now exposing the sa accoutn and password to a lot of people.

Duplicate post. Please post answers here

I don't have SQL 2008 to test on, but I assume it applies, you should be using the Date functions, DateAdd, DataDiff, etc...

How many rows are we talking about? I'd recommend bringing the data across from Oracle to a temp table in SQL Server and then do the comparison with a...

Here's the BOL link for LOGON triggers:

http://technet.microsoft.com/en-us/library/bb326598.aspx