error string : Column name 'Catégo'

• raynald

  Valued Member

  Points: 58

  More actions

  March 12, 2002 at 4:43 am

  #105217

  Hello, I have a DTS package I can execute using SQL Enterprise Manager 2000. When I make run this DTS as a job, I have the error : "error string : Column name 'Catégo'". I suppose there is a problem with accent letters given to the shell command. I know the best way to get out of this problem would be to change the column name, but I can't. Any suggestion ?

  Ray

  
  Ray

• Neil S Hambly

  SSC Veteran

  Points: 278

  More actions

  March 12, 2002 at 4:50 am

  #425243

  Have U Tried enclosing the column Name in [column name] in square brackets.

  quote:

  ---

  Hello, I have a DTS package I can execute using SQL Enterprise Manager 2000. When I make run this DTS as a job, I have the error : "error string : Column name 'Catégo'". I suppose there is a problem with accent letters given to the shell command. I know the best way to get out of this problem would be to change the column name, but I can't. Any suggestion ?

  Ray

  ---

• raynald

  Valued Member

  Points: 58

  More actions

  March 12, 2002 at 7:13 am

  #425247

  Thx Neil, I solved the problem. This DTS package was imported from a french regional settings server. So, I decided to rebuild it directly on the server it needs to run. It works fine now, but it sounds a little weird to me.

  Ray

  
  Ray