Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2002
    Location
    Minneapolis, MN
    Posts
    253

    Unanswered: SSIS Package Hangs

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

    "If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."

  2. #2
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    I would guess it is the rs command. If rs does not quit automatically, SSIS will hang. Try to run the batch file from the command line, with the same user as in SSIS. You could of course also run "start rs ..." which will tell the batch file to continue immediately, not waiting for rs to complete.
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

  3. #3
    Join Date
    Feb 2002
    Location
    Minneapolis, MN
    Posts
    253
    The rs command runs fine from the command line. It also stops automatically...
    Anthony Robinson

    "If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Haven't played with SSIS yet, but if it's anything like DTS, then the contect when you run it is the drives are your mapping, wen it's scheduled, it's the server's drive mappings
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •