Verify the paths including this one:

C:\Windows\System32\XCOPY.exe

Also using the ~1 notation is sketchy (IMO), spell it out and use double-quotes to delimit it, ie:

" F:\Program Files\Microsoft SQL Server\MSSQL\backup\ETKPS\*.*"

Concidently, I am...

I've used DTS in SQL 2008, it works fine, but DEFINITELY upgrade them.

CEWII

I can think of a couple different ways to do this..

The first question I have is, are you passing the content of the XML file to the sproc or just...

I'm curious what you are trying to accomplish.

Transfer objects and data-flow components have very different purposes.

If you tell us more about the problem you are trying to address...

It is possible to trigger a trigger..

Does the table TEM exist on the linked server at: MASTER.DBO.[TEM]

Also, is the remote server case sensitive?

I have to say that using a trigger...

I see an aweful lot of memory left over. As Gail was asking, are they all the same for importance.. I might bump the memory to top at...

By definition you aren't going to be doing a join. How do you know valid combinations? Without any matching columns you are looking at a cartesian product.

CEWII

What comes to mind is that the re-index should occur AFTER.

What it our archive process?

I was thinking copy and then delete but due to index fragmentation (in particular) that you...

You are very welcome.

CEWII

Is outlook connected to Exchange? I've had what you are describing happen when I was using only POP3/SMTP but never Exchange.

CEWII

Derived column transform.

CEWII

What is the error it is throwing and is the error coming from the component or from the email server itself?

CEWII

There are only about a million ways to get that message..

Assuming you have been able to connect before from this machine

1. Is SQL Server up?

2. Is SQL running on...

This is kind of interesting.. the code for that function is pretty straightforward:

CREAE FUNCTION [sys].[fn_get_audit_file] (

@file_pattern nvarchar(260),

@initial_file_name nvarchar(260) = NULL,

@audit_record_offset bigint = NULL)

RETURNS table

AS

RETURN SELECT *

FROM OpenRowSet(TABLE...

They do provide fn_get_audit_file but you have to execute it on the server against files that can be reached from that server. Then again it isn't all that different...