dbTalk Databases Forums  

SSIS PAckage Hangs

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss SSIS PAckage Hangs in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ansonee
 
Posts: n/a

Default SSIS PAckage Hangs - 03-29-2007 , 11:41 AM






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!!


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.