I have a Stored Procedure process(scheduled SQL Job) created using BCP to export PDF file data from a image datatype to a PDF file on a network share.
Due to a client request, I'm wanting to migrate this process to SSIS. The SSIS process works, but the pdf generated is different. I'm trying to wrap my head around why this would be different if the source information (image field) is exactly the same? I was wondering if it some kind of layering in the original PDF that just isn't getting reproduced using SSIS?
Thanks for any assistance with this.