Post reply

Problem with a Script Task for calling a Stored Procedure

  • March 19, 2010 at 1:17 pm

    #146101

    Hi everyone!

    I have the following problem:

    I have a SSIS package that watch over a folder, when a new file is created in that folder, the package use a Script Task to transform the file and then, it use 2 stored procedures to insert the data in 2 tables.

    That package works just fine, when running it from BI Development Studio. I deploy the package and put it into SQL Server, and create a job to run the package. The package starts and run well, but after processing about 20 - 30 files, it goes down.

    Any ideas about what´s happening there?

  • March 19, 2010 at 3:18 pm

    #1137046

    If you post some of the output we might be able to help you. Right, now it is effectively, it sort of works but stops working can you tell me why, but we don't have enough information and output from the package run will help.

    CEWII

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply