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.

Correct PDF Format Correct PDF Format

Incorrect PDF Format Incorrect PDF Format

  • I'm wondering if you have "almost" identical images in your stack of data (an older and newer version). SSIS and BCP have been known to import stacks of data at different sections of the data stream to multi-task the import process jumbling the output from the original order of the input. Could this be true for your data? – Sting Sep 12 '16 at 16:02
  • Actually as of right now there is very limited data because they just started using this function of the system. So I'm only dealing with 5 records that have image data (PDF documents). Basically its enough data to test. – Bill L Sep 12 '16 at 16:19
  • A pdf can contain layers incl tect and images. (Im surprised youre saving it in an image field). I wonder if 1 tool is treating it correctly as a pdf and the other is only handling the image content of the pdf. What happens if you store them with a different datatype like a blob? – Sir Swears-a-lot Sep 26 '16 at 7:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.