If I understand you correctly, Yes, we do this.

I have a local connection variable that resolves this way using expression

Data Source=YOURSERVER;Initial Catalog=YOURDATABASE;Provider=SQLNCLI.1;Integrated Security=SSPI;PacketSize=32767

Expression

"Data Source=" + @[User::cfgDWServerName] + ";Initial Catalog=" + @[User::cfgDWDatabaseName] + ";Provider=SQLNCLI.1;Integrated Security=SSPI;PacketSize=32767"

YOURSERVER and YOURDATABASE are the cfgDWServerName, cfgDWDatabaseName variables that I use configurations to set. So it's an easy move from dev to prod or sales or demo or whatever, I just use Set Variables tab in the job step to point to correct server/database.

There are many ways to do configurations and I only know this way so hope you can adapt for the method you use.

In dev, all I do is check variables to see that my connection is dev.

Hope this helps!