Post reply

SSIS File System task

  • February 15, 2017 at 1:33 am

    #340642

    I am copying the file from remote server to local folder which is taking 2 minutes hardly , but when I am using ssis file system task the file is copied to the destination (local folder) , but the package is in debug mode and it is still running for more than 2 hours .

  • February 15, 2017 at 4:33 am

    #1928581

    If you manually run a package from within Visual Studio (or SQL Server Data Tools) the execution is done in debug mode. Even after all tasks are finished the execution stays in debug mode. You'll need to stop this mode yourself by clicking the message/link.
    You can see the progress of the tasks in the "control flow" and/or "data flow" tab by the icons in the top-right corner of each control. There is also a logging tab where you'll find all messages about the execution.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • February 15, 2017 at 5:48 am

    #1928589

    There is only one task that is file system task , and that is still executing , the task is not finished yet but it copied the file from remote server to local folder but the task is still execution mode for more than 2 hours (I mean it didn't showed any green color only yellow one ) .

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

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