lundi 26 octobre 2015

whitespace is not allowed at this location

I have an SSIS package that is importing a flat file into my database. I get the error message in the title and it points to the location of an ampersand. I can run this package from SSIS and it runs without issue. But when I try to run it is a SQL Server agent job I get the error. I also just finished setting up 2 other jobs that work similarly and have similar data (company names with ampersands) and they work fine.

Aucun commentaire:

Enregistrer un commentaire