Posted by ansonee on 03/29/07 16:41

I am encountering a weird issue with SSIS.

I have a very simple SSIS package that executes a .bat file. Here's
the
actual file it executes:

@Echo Off
c:
F:
cd ReportingServicesScripts
rs -i NoteBlankSnapshots.rss -S http://10.90.160.13/ReportServerTest
EXIT

The .bat file executes a Reporting Services .rss script using the
rs.exe
utility. When I run the command from the command prompt, it runs just
fine.
When I execute the .bat file manually, it runs and completes. When I
execute
the actual package, it also completes. But when I schedule the package
as a
job, it just hangs...it never finishes.

The owner of the job is an administrator in SQL Server. I have the
SQL
Server Agent configured to interact with the desktop - although
my .bat file
requires no input from the user.

I've created other jobs that just execute plain old SQL using the
same
owneer and these jobs complete just fine.

What am I missing?

Any help would be appreciated!

Thanks!!

• Next in forum: Combine multiple records into single row
• Prev in forum: Re: pivot table without aggregation?
• Thread view: SSIS PAckage Hangs

[Reply to this message]