Post reply

Store Procedure Control or Dataflow Task

  • March 22, 2012 at 9:58 am

    #150849

    Hi

    Is there a control flow or a dataflow task that is a direct link to a stored procedure?

    I have just taken on administering a few packages and they use SQL scripts so to view the script i have to look at the location and find it on the file server.

    I want to just double click my task and open a store procedure with my script in there.

    I hope thats clear 🙂

    Thanks in advance

  • March 22, 2012 at 11:23 am

    #1462901

    Actually it isn't real clear.. Sorry..

    I'm not sure what you mean by direct link, there are references but I'd like to understand what you mean.

    Also you reference SQL Scripts, how are you getting those into the SSIS package or are you refering to code already in a DAta-Flow task source or Exec SQL task?

    CEWII

  • March 23, 2012 at 2:17 am

    #1463217

    Someone I have worked with previously who built the SSIS packages at the place we worked put in tasks that he could double click and it opened a sproc

    When i say there are tasks that are linked to scripts i mean scripts that are saved on the file server, so those scripts arent actually in the package, which isnt ideal 🙂

    thanks for the reply

  • March 23, 2012 at 6:18 am

    #1463304

    You can copy paste the contents of the script files to the Execute SQL Task. Change the SQLSourceType from File connection to Direct input and put the code in the SQLStatement window.

    Be aware that scripts can have only a maximum of 8000 characters.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 23, 2012 at 10:48 am

    #1463588

    I generally have the sp live in SQL and call it from the Execute SQL Task.

    I guess I'm not sure why it is important to be able to edit it in SSIS as I very much like it living in SQL where modification / maintenance are easy.

    Good to know about size limit in SSIS!

  • March 23, 2012 at 1:16 pm

    #1463736

    So it creates the sproc then executes it in SSIS? That is not what I would do. I agree, I'd rather it be in SQL in general.

    CEWII

Viewing 6 posts - 1 through 5 (of 5 total)

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