Is there a process that could be running at the same time on Server B causing the package to only work intermittenly? I would check your database connections as...

I figured it out. I was attaching the file in two places. Thanks again for your help.

That works. Only thing is now it attaches two copies of the Excel File. Do you know why that happens?

Thanks for your help.

I'm sending the mail using an Active X Script. See code below:

'**************************************************************************

' Visual Basic ActiveX Script

'************************************************************************

Function Main()

'Send email with file attachment

Dim objMail'Mail Object

Dim strFilePath, strSubject, strHeader, strEmailBody, strFooter

strFilePath...

Here is what it is delivered as I believe.

Field Name: X_MimeOLE

Data Type: Text List

Data Length: 49 bytes

Seq Num: 1

Dup Item ID: 0

Field Flags:

"Produced By Microsoft MimeOLE V6.00.2800.1409"

Pre-Windows 2000 Compatible Access Group is an upgrade. It is necessary if your receiving the following error:

The job failed. Unable to determine if the owner (domain\username) of job testjob...

When I try and run this I get the error message -

Server: Msg 156, Level 15, State 1, Procedure sp_ALZ_check_failed_jobs, Line 26

Incorrect syntax near the keyword 'AS'.

Server: Msg 170, Level...

So by runnning EXEC sp_update_job @job_name that will make you the owner of the SCHEDULED JOB but not the packages in it?

What if the job runs under a different login name then mine?  Can I still be the owner or does the login it runs under need to be the owner?  Basically...

I know they won't make me a member of SA because that gives you too much system access.  How do you make someone the owner of a job?

Phil

You can return a value from a stored procedure to a global variable this way.  See below:

SET NOCOUNT ON

DECLARE @ReturnValue int, @OutTest intEXEC @ReturnValue=dbo.spReturnAndOutputTest @OutTest OUTPUTSELECT @ReturnValue AS ReturnValue,...

Actually the output parameter box will only allow me to select ReturnValue.  It isn't @ReturnValue and I can't change or select @ReturnValue.  ReturnValue is the only choice.(without @)

Yes I do have it mapped to @returnValue.  That is why I don't understand why it isn't working.  Any suggestions??

I was able to get this to work just like the example I gave at the top of this post.  I passed in the global variable directly into a SQL...

Answered my own question - See example below.

' 205 (Change SourceSQLStatement)

Option Explicit

Function Main()

Dim oPkg, oDataPump, sSQLStatement

' Build new SQL Statement

sSQLStatement = "SELECT * FROM dbo.employee WHERE hire_date > '" &...