I'm amidst "parameterizing" a connection in my package and I'm confused: I'm trying to set the database name but there are two options: 1- InitCatalog Name and 2- Name:
Here is what my connection looks like:
And my parameter options are (as mentioned 1- InitCatalog Name and 2- Name): and
So my question is: which one do I choose? I've read about "InitCatalog" and it seems to be where you'd define the default database within a server. But that could be defined under the name as well. Thank you!
As answered here: Difference between Initial Catalog and Database keyword in connection string