Batch SSIS pkg execution from Business Intelligence Development Studio

  • Stan Kulp-439977

    SSCrazy Eights

    Points: 9948

    Comments posted to this topic are about the item Batch SSIS pkg execution from Business Intelligence Development Studio

  • Phil Parkin

    SSC Guru

    Points: 243791

    Stan Kulp-439977 - Tuesday, July 11, 2017 12:01 AM

    Comments posted to this topic are about the item Batch SSIS pkg execution from Business Intelligence Development Studio

    Stan, you seem to be clinging to the past: it's not called BIDS any more 🙂

    As Developer Edition is now free, there is no clear reason why developers should not be able to install Integration Services, though that does not invalidate the technique you have described here.

    Having to have all of the packages in the same project is a limitation in some circumstances (so any common 'utility' packages from another project cannot be included).
    If additional flexibility is required, packages can be run from T-SQL (link), though they do have to be deployed to SSISDB first.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

  • Stan Kulp-439977

    SSCrazy Eights

    Points: 9948

    At work they won't let me have integration services on my workstation because of the licensing issue, and I have a lot of test data to refresh periodically. This is a workaround that made it a lot easier for me.

  • Phil Parkin

    SSC Guru

    Points: 243791

    Stan Kulp-439977 - Tuesday, July 11, 2017 6:17 AM

    At work they won't let me have integration services on my workstation because of the licensing issue, and I have a lot of test data to refresh periodically. This is a workaround that made it a lot easier for me.

    Which version of SQL Server are you targeting ... presumably pre 2014? Otherwise, I can't see what licensing issue you are describing.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

  • Stan Kulp-439977

    SSCrazy Eights

    Points: 9948

    SQL Server 2012.

  • tim.ffitch

    SSC Veteran

    Points: 292

    Stan Kulp-439977 - Tuesday, July 11, 2017 6:17 AM

    At work they won't let me have integration services on my workstation because of the licensing issue, and I have a lot of test data to refresh periodically. This is a workaround that made it a lot easier for me.

    But a developer licence prior to SQL 2014 was £40 to £50, that is a no brainer in the grand scheme of things.

  • Stan Kulp-439977

    SSCrazy Eights

    Points: 9948

    tim.ffitch - Wednesday, July 12, 2017 3:07 AM

    Stan Kulp-439977 - Tuesday, July 11, 2017 6:17 AM

    At work they won't let me have integration services on my workstation because of the licensing issue, and I have a lot of test data to refresh periodically. This is a workaround that made it a lot easier for me.

    But a developer licence prior to SQL 2014 was £40 to £50, that is a no brainer in the grand scheme of things.

    The IT department said no, which is why I tried this workaround, and it does what I need it to do.
    The next project uses 2014, so it will be moot.

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

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