Here's an odd one for you. SSIS 2012 package put into SSIS 2019 (SQL Server, not Catalog or file system). It's called by a job and has 3 tasks in it. Execute SQL, File System Task and Send Email task (in that order). The File System Task copies a file from one directory to another using a source variable, with expressions that were populated by the Execute SQL task, and a destination variable.
No changes have been made to this package in at least a year. Works fine in 2012 and ... sort of works fine in 2019?
The package finds the file, moves the file and sends a notification to the users that the file is now in their folder. Weirdly, though, the SQL Agent job fails on the File System Task with the error "An error occurred with the following error message: "The filename, directory name, or volume label syntax is incorrect.".
I can run the Execute SQL code in SSMS and see the proper data. The file does actually get found and moved. The users get their email. But every single time, we get this error as if something is wrong with the source or destination. Every other time I've seen this error, it doesn't move anything or continue on with the rest of the package because of the failure.
Has anyone seen such weird behavior from SSIS 2019 before? I'm at a loss as to why we're getting the error when everything is working fine.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.