question

kumarm11 avatar image
kumarm11 asked

automating setting ssis parameters for multiple projects in ssis 2012

Hi Team I have around 1000 solutions and I need to deploy all these solutions from one environment to other environments I dont want to use below stored procedure because i need to pass almost thousands of parameters for those 1000 solutions [SSIS].[catalog].[set_object_parameter_value] You'll need to know the parameters @object_type = 20, @parameter_name = N'your parameter by name', @object_name = N'the ssis project name for a project param package for other', @folder_name = N'the folder the project is in SSISDB', @project_name = N'project name again' @value_type = V -- , @parameter_value = N'YOUR NEW VALUE!! I wanted to do a update for most records at once for suppose there are 10 records with object_name=A and parameter_name=Y for 1 solution,i needed to update design_default_value=X server, i am using below query update ssisdb. [internal].[object_parameters] set design_default_value=X where object_name=A and parameter_name=Y But i am getting error as login failed as error1![alt text][1],it seems its not got updated and its trying to point old server where as when i tried to update using below update ssisdb. [internal].[object_parameters] set design_default_value=X,default_value=X,value_set=1 where object_name=A and parameter_name=Y But i am getting error as an item with same key has already been added at system collections.generic dictionary as shown error 2![alt text][2] All these solutions ran fine in 1st environment dont know why its getting failed as above using update statements [1]: /storage/temp/3640-error1.png [2]: /storage/temp/3641-error2.png
ssisssis error
error1.png (17.7 KiB)
error2.png (17.8 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.