July 11, 2017 at 12:01 am
Comments posted to this topic are about the item Batch SSIS pkg execution from Business Intelligence Development Studio
July 11, 2017 at 6:07 am
Stan Kulp-439977 - Tuesday, July 11, 2017 12:01 AMComments 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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 11, 2017 at 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.
July 11, 2017 at 6:38 am
Stan Kulp-439977 - Tuesday, July 11, 2017 6:17 AMAt 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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 11, 2017 at 6:50 am
SQL Server 2012.
July 12, 2017 at 3:07 am
Stan Kulp-439977 - Tuesday, July 11, 2017 6:17 AMAt 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.
July 12, 2017 at 6:00 am
tim.ffitch - Wednesday, July 12, 2017 3:07 AMStan Kulp-439977 - Tuesday, July 11, 2017 6:17 AMAt 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 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply