I'm not sure if I understand you question but you need to ectract the Datetime value from a column in a table correct?

If so assign this value to a Global...

I did not see a clustered Index, not that is related to you problemn but why is that?

I see that you have an index that consist of 4 columns and...

You can store an Access mdb to a share that does not have Access installed on it but the host Access the mdb file must have the Acces Jet Engine...

Have you included a data conversion task between the source and destination?

Another article from Microsoft:

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

Pinal Dave has an article that describes how to do this:

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

Have you checked CPU Utilization, Memory Avg Disk que Lenght, Reads, Writes, etc and made a comparison between when the system was performing well and compared that benchmark to when...

Have you fixed the ophan users?

There are a number of factors to consided in making this choice. You may want to know both nut put you intial emphasdid on ome and then become proficient on...

I tried to Google this so that I could get an anser but this came up in a SQL Server 2008 for Oracle DBA Class I attended a couple of...

Have you ever used the OPENROWSET FUnction?

Please refer to the Link below concering syntax and usage:

http://www.sql-server-helper.com/tips/read-import-excel-file-p01.aspx

You can also deine a Linked Server if a peranent connection is needed:

http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=135

The WITH (NOLOCK) can be very helpful. It is equizilant to the Read Uncomitted Mode REad Committed is the default mode.

WITH (NOLOCK) will return all uncommitted records, so if returing...

Have you tried this in a Development or QA Environment?

I suggest that you try this & run the SQL Server Installation Wizard.

This will check the paramater and a number of...

Can you go into break mode and capute your query and try ti execute it from query analyzer?

Ford you query execute from SQL, if so something may be wrong with...

You probably want to specify the max number of errors, an error file, batch size as well as last row that you want to process so that you are not...