March 25, 2014 at 8:44 am
The properties shows: "PDF Version: 0.0" 🙁
I can extract (and display) the pdf filer without problems using my front-end (WriteBLOB).
I guess it has to do with the way it extracts the data, but...
March 25, 2014 at 9:38 am
sten.f.soerensen (3/25/2014)
I have a job sending e-mails automatically, and I want to attach a PDF file to these e-mails. That requires the job to place the file to the file server, whereafter it attach the file. Unfortunately, I haven't been able to extract the file(s) successfully - yet.
Now we are getting to it. 😀
Is this a sql job or a scheduled/automated windows job?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 26, 2014 at 1:00 am
Yes, it's a SSIS job which create/sends the e-mails. I just want to add a file which are stored on our SQL server, so I need the job to be able to extract the PDF file from the table and I will then be able to attach the file to the e-mail.
Sorry for not being detailed enough to start with.
April 2, 2014 at 12:29 am
sten.f.soerensen (3/26/2014)
Yes, it's a SSIS job which create/sends the e-mails. I just want to add a pdf file[/url] which are stored on our SQL server, so I need the job to be able to extract the PDF file[/url] from the table and I will then be able to attach the file to the e-mail.Sorry for not being detailed enough to start with.
Will following blog offer some help?:-)
http://sqlage.blogspot.de/2013/12/ssis-export-files-from-sql-table-to.html
April 2, 2014 at 12:40 am
I have already tried that and it didn't work 🙁
I guess it has to do with the way the files was uploaded to the table (VB/WriteBLOB).
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply