Parameterizing data connection

%3CLINGO-SUB%20id%3D%22lingo-sub-2007057%22%20slang%3D%22en-US%22%3EParameterizing%20data%20connection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2007057%22%20slang%3D%22en-US%22%3E%3CP%3ETrying%20to%20parameterize%20connection%20as%20per%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcustomize-a-parameter-query-addf7cb7-ddf0-442f-a60c-cd7280e201bd%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcustomize-a-parameter-query-addf7cb7-ddf0-442f-a60c-cd7280e201bd%3C%2FA%3E%3C%2FP%3E%3CP%3EHowever%2C%20Parameters%20button%20is%20greyed%20out.%20What%20do%20I%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2007057%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2010494%22%20slang%3D%22en-US%22%3ERe%3A%20Parameterizing%20data%20connection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2010494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F908634%22%20target%3D%22_blank%22%3E%40GeraldBritton%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20share%20more%20information%20on%20your%20project%20-%20if%20possible%2C%20a%20workbook%20without%20confidential%20data.%3C%2FP%3E%3CP%3EAlso%2C%20are%20you%20using%20PowerQuery%20to%20set%20up%20the%20connection%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Trying to parameterize connection as per https://support.microsoft.com/en-us/office/customize-a-parameter-query-addf7cb7-ddf0-442f-a60c-cd728...

However, Parameters button is greyed out. What do I do?

4 Replies

@GeraldBritton 

Can you share more information on your project - if possible, a workbook without confidential data.

Also, are you using PowerQuery to set up the connection?

@adversi I attached a workbook.  Take the first sheet as an example.  I want to parameterize the server name in the connection string.  I attached a screenshot of what I want to parameterize and the workbook 

@GeraldBritton 

Sorry, not entirely sure what the right solution would be. I did find that CRSIRVBC01TBV,3341 SSISDB connection is doesn't have its connection file grayed out.

adversi_0-1608669661436.png

 

Maybe these two articles can help:

Dynamically assign filename to excel connection string 

Passing Dynamic Query Values from Excel to SQL Server 

@adversi Thanks for taking a look.  I did read the linked articles, which can help if you want to parameterize the query.  However I want to parameterize the connection instead, which doesn't seem to be covered.