It's in another IP segment but in the same building. If there were any network/packet rules even the manual run would've failed. The manual runs worked.

Update...

After resetting the time to run in the wee early morning, it did the same thing. Ran for 12 seconds and reported "Success" for all steps but no data.

So I...

The Agent job Owner has sa server role membership.

You wanna hear something crazy? We changed just the time this SQL Agent job executes to 10 minutes from now (well 15...

Is it safe to assume that when you say take a backup of the TX log, you mean using the SQL native backup and not RedGate?

We'll try that and let...

We will try that.

I'll let you know if it worked.

Thanks

Make sure the domain account the SQL Service runs under is the same on both servers. If they are not, then make them.

Also, you may need to setup a SPN...

So your saying that "If the second subreport is not embedded in a tablix" it shouldn't re-query SQL for the same recordset and the subreport will use the first reports...

The linked server works properly. I am able to query tables with no probs.

I can also execute a stored proc that exists on the linked server like so....

EXEC [HOUSEOFPAIN].BRUISE..sp_SmackDaFoo...

OK, I figured it out. In the backup maintenance package that I created in BIDS for backup, you create a SQL agent job. Within the SSIS package that got built...

Make sure the switch you are attached to is set to the same Duplex level as your NIC. If your switch is set to 1000Mb/s FULL DUPLEX and your server...

It took ~2.5hrs. That's normal. Typically it's 2.5-3hrs depending on what's running.

There really is no different executing an SSIS pkg as a job compared to a step withing several...

OK, I opened just that step in BID's, no issues. I even exported it to a file then ran it, it finished OK. The standalone SQL Agent job runs fine....

If it means anything, when I run the original SQL Agent Job (which is a step in the job I am having issues with), it runs with no problems.

I'll try...

Here's the log output of the one step in the job...

Microsoft (R) SQL Server Execute Package Utility

Version 9.00.4035.00 for 32-bit

Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 11:08:13 PM

DTExec:...

Here's the log from SSIS starting one of the steps...

Date7/30/2010 11:09:05 PM

LogWindows NT (NT Events)

SourceSQLISPackage

Category(0)

Event1073819648

UserMPAPSDB\localsqlservices

ComputerMPAPSDB

Message

Package "Daily ReBuild Indexes" started.

Here's the log that says it finished the step...

Date7/30/2010 11:09:05 PM

LogWindows NT...