all groups > sql server dts > march 2007 >
You're in the

sql server dts

group:

SSIS PAckage never completes


SSIS PAckage never completes A. Robinson
3/29/2007 8:42:01 AM
sql server dts:
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!!


Re: SSIS PAckage never completes A. Robinson
3/29/2007 10:12:04 AM
No effect...

Job still starts but doesn't do anything...

[quoted text, click to view]
Re: SSIS PAckage never completes A. Robinson
3/29/2007 10:36:11 AM
The rss script executes just fine when it's run from the command prompt and
also when it's run from the DTS package and the Visual Studio IDE. There
aren't any issues with the rss script...

This is essentially a SQL Agent issue I'm thinking...but don't know what the
problem would be since the user is an administrator on the box.

[quoted text, click to view]
Re: SSIS PAckage never completes Kent Tegels
3/29/2007 4:59:30 PM
Hello A. Robinson,

Try using:

call rs -i NoteBlankSnapshots.rss -S http://10.90.160.13/ReportServerTest

and see if that helps.

Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/

Re: SSIS PAckage never completes Kent Tegels
3/29/2007 5:22:10 PM
Hello A. Robinson,

[quoted text, click to view]

Does the RSS script actually execute or not?

If it does, this sounds like an issue with SQL agent.
If it doesn't, this sounds like an issue with RSS.

Thanks,
kt

Re: SSIS PAckage never completes Mike M.
5/10/2007 9:04:06 AM
How do you have the SQL
Server Agent configured to interact with the desktop ? How is this done??

Thanks!

[quoted text, click to view]
AddThis Social Bookmark Button