Do this,

Create a new database in your Test Server (Only on your Test Server)

And run the exact script that you posted in this thread and run it. See what the...

Your table is missing an important Index, it needs to have.

CREATE NONCLUSTERED INDEX [not_log_x4] ON [dbo].[not_log]

(

[nlh_hdr] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING...

Can you post the error message you get, since the original post here is someone else error, rather than that, if you can describe your issue, what you have tried,...

I recently posted a blog on Linked Server with Access DB.

You can visit the site in my signature, try the steps (in GUI) mentioned in my Blog on December 6th.

Everything seems to be fine, and my initial assumption is security permissions for the Agents (which Steve has already mentioned) on that directory, check that one more time.

steveb. (12/8/2009)

---

Bru Medishetty (12/8/2009)

---

Even we do implement a single dedicated SSIS Server that takes care of all data movement from multiple server inside our organization. In that way we...

Even we do implement a single dedicated SSIS Server that takes care of all data movement from multiple server inside our organization. In that way we would take off the...

Where is the directory your snapshot is storing the data.

If it is a network location, verify and see that you have correct path name.

satanofhope (12/8/2009)

---

Hello everybody,

For a client I need a to write a rapport to persuade them to get a special integration server. Right now it runs on the same server as...

Wow! You responded within 32 days. 😉

Hey Adam,

I already mentioned this in yesterday's reply, you need to see what is Oracle Version you have on the Oracle side and install the client components. (Only Client). After...

Hi Dan and Gift,

The error reported by the OP is occuring since the Oracle Client component is not installed on the machine from where he is trying to connect...

Examples on what? To add storage go got to ask your Storage / Network / Systems Engineer. They would...

First what is the reason for this move to Windows only Authentication Mode.

Have you checked if there are users who are using the SQL Login. If you move to...

You need to search Microsoft for the latest patches for your product.

Regarding the assurance that nothing will happen and your applications will not have any issues, that promise cannot be...