praveenkumarpalla (2/24/2010)

---

Thanks for the response

I am having issues when using integration services project from sql server...

USing SSIS how can i import data from MS Access to SQL Server

Can you please...

One of the quickest way to do updates in bulk manner is to delete the rows from the destination table first then add the updates in the same way as...

you 'could' howver you cannot created indexes on table variables so this could cause problems with 100,000 rows.

A temp table would be better or perhaps create a perm. staging/lookup...

Dont forget to take a tail log backup before you...

I dont think that mirroring will solve the performance issues as all the transactions need to be moved to the mirror anyway.

You would be better splitting the databases between the...

You shouldn't worry about fragmentation on a table with that few rows.

MS recomends that you should not be concerned with fragementation of indexes with less than 1000 pages

it really depends on the data type, microsoft outlines the steps for sizing clustered and non-clustered indexes here;

http://msdn.microsoft.com/en-us/library/ms187445.aspx

Can you check the logs on the subscriber sever? this will have the error code and state that will help determine why the login failed.

how many rows are in the table?

okay, you could check the windows system logs to see if there is anything there also..

Have you checked the account that the agent is running under has permissions to...

I use the script here to transfer logins and passwords;

http://support.microsoft.com/kb/918992/en-us

in SSMS

expand SQL server agent --> then expand jobs

Find the job that you created to run the package and right-click and select View History

It could possibly be a permission issue, does your account that runs the SQL agent have the correct permission to access the MS Access database?

Also do your SQL agents...

There wont be any difference in the speed, Windows authentication is preferred as it can be more secure since it is controlled via the AD

You should start the values on the first cell(A1) in excel .

Also i would be reluctant to use a custom format in excel as this also may cause issues(?)

Fix the...