How much physical Memory do you have on the machine and what is the MaxServerMem Set to?

ravi01031986 (7/8/2011)

---

Hi,

I need to import Access db to SQL server using SSIS packages.Could some one tell me how to do these in the best possible way.I am having like 3...

Are you sure that qry_Reports and qry_PI_Reports referenced are not queries?

Thank you Gail. 🙂

Take a look at the following for an explanation.

http://stackoverflow.com/questions/799584/what-makes-a-sql-statement-sargable

http://www.sql-server-performance.com/2007/t-sql-where/2/

http://msmvps.com/blogs/robfarley/archive/2010/01/22/sargable-functions-in-sql-server.aspx

I hope this helps! 🙂

The maximum size for SQL express 2008 R2 is 10240 MB for each DB.

sqlquest2575 (7/7/2011)

---

Thank you for your reply. I am still trying to figure out the issue here. After Modifying the queries now the error says that table does not exist... I...

Given the naming convention, the qry_Reports and qry_PI_Reports Tables seem like ad-hoc temporary tables, a.k.a. garbage. 😉

If you can't find them, ask as was sugested and if nobody ones what...

If the table is missing then recreate it in SQL Server and the populate it.

You should tweak the indexes and remove reserved words and spaces in column names, etc so...

toddasd (7/6/2011)

---

So, if this returned nothing

select * from information_schema.tables where table_name = 'qry_Reports'

then...

I see that you are still trying to use a "SELECT DISTINCTROW".

Did you every try what I suggested?

Edit then copy & paste.

sqlquest2575 (7/6/2011)

---

corgi. thanks for your post. I am not trying to waste anyone's time. I am just trying to get the answer of my sql issue. I had a different...

Is there a different schema?

What happens if you query on the table directly?

What are you talking about? :hehe:

Welsh Corgi (7/1/2011)

---

sqlquest2575 (7/1/2011)

---

1. When I run ssma I got 2 error saying that two of the queries could not be converted

(Is that a problem as...