To export some data to a text file, I used the wizard in SSMS 17.x to create an SSIS file, and it ran fine from the wizard, but it gives me an error when I try to execute it again using xp_cmdshell, like this:
EXEC xp_cmdshell 'DTExec /f "\\MyServer\MyScriptFolder\MyExportPackage.dtsx"'
The error reads:
Description: The version of Destination - MyExportPackage_txt is not compatible with this version of the DataFlow.
What the heck does that mean? I've Googled this and the only thing I see is people mentioning 32-bit vs 64-bit versions of dtexec.exe, but I don't see what that would have to do with anything, or how to fix that.