October 1, 2014 at 10:48 am
In 2008 BIDS we had a configuration table that contained variables that where used by all projects, such was common workspace.
How do I do this in 2010 SSDT for all projects instead of an environmental variable that is unique to the project.
October 9, 2014 at 12:35 pm
Environments can be accessed across folders. To see this, right click on a deployed project and select configure. Click references,Add... and you will be able to browse to other folder's environments. Or for a script:
Declare @reference_id bigint
EXEC [SSISDB].[catalog].[create_environment_reference] @environment_name=N'EnvironmentYouWantToUse', @environment_folder_name=N'FolderEnvironmentIsIn', @reference_id=@reference_id OUTPUT, @project_name=N'YourProjectName', @folder_name=N'FolderYourProjectIsIn', @reference_type=A
Select @reference_id
One approach is to create a folder called "CommonConfigs" or whatever you want and just set references in your project to use this.
October 9, 2014 at 1:32 pm
Thanks, that was what I was wanting. You are the only person that has been able to answer this question in two weeks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply