SSIS Error when trying to configure Connection Manager in a SQL Server Agent Job

• ericwenger1

  Hall of Fame

  Points: 3436

  More actions

  May 4, 2022 at 12:57 pm

  #4026576

  I've exported some SSIS Packages from one environment to another. I created a sql server agent job to run the package and I want to modify the Configuration Parameters to point to the SQL Server that I'm now trying to run this package. I'm getting the following error:

  The property 'ParameterName' contains invalid characters as an object name. Remove the invalid characters. (Microsoft.SqlServer.Management.IntegrationServices)

   

  Any help would be greatly appreciated

• Phil Parkin

  SSC Guru

  Points: 246985

  More actions

  May 4, 2022 at 12:59 pm

  #4026578

  The error message seems self-explanatory. Can you post here the parameter text which is resulting in the error?

  Edit: why are you trying to modify the parameter name and not its value?

  • This reply was modified 2 years, 7 months ago by  Phil Parkin.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• May 4, 2022 at 10:48 pm

  This was removed by the editor as SPAM