Home / server / Questions / 134368
Accepted
alimack
Asked: 2010-04-22 01:58:29 +0800 CST

SQL Server Agent 2005 job runs but provides no output

  • 772

Essentially I have a job which runs in BIDS and as as a stand lone package and while it runs under the SQL Server Agent it doesn't complete properly (no error messages though).

The job steps are:

1) Delete all rows from table;

2) Use For each loop to fill up table from Excel spreasheets;

3) Clean up table.

I've tried this MS page (steps 1 & 2), didn't see any need to start changing from Server side security.

Also SQLServerCentral.com for this page, no resolution.

How can I get error logging or a fix?

I have logged in as the proxy account I'm running this under, and the job runs stand alone but complains that the Excel tables are empty?

sql-server sql-server-2005 ssis

1 Answers

  1. Best Answer

    I did fix this eventually, thanks for the suggestions.

    Basically I logged in with the proxy user account I was running and started to see errors like: "The For each file enumerator is empty"

    I copied the project files across, and it turned out that I'd still left a file path (N:/) in the properties of the For Each loop box, although I'd changed the connection properties. I also had to recreate the variable mapping to get it working.

    No wonder people just recreate the whole package(!)

    Now fixed and working.

    • 0