Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 merging pdf's in SSIS

Author  Topic 

Dirch
Starting Member

8 Posts

Posted - 2012-10-01 : 12:02:12
I need to merge two pdf files in SSIS. Can anyone give me some advice on what to use and how to do this? Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-10-01 : 12:16:35
why do you need SSIS for this? SSIS is not file merging tool
We make use of batch scripts for this

Alternatively if its for ssrs reports you could even try this

http://visakhm.blogspot.com/2011/12/generating-pdf-pack-reports-in-ssrs.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Dirch
Starting Member

8 Posts

Posted - 2012-10-01 : 12:23:23
quote:
Originally posted by visakh16

why do you need SSIS for this? SSIS is not file merging tool
We make use of batch scripts for this

Alternatively if its for ssrs reports you could even try this

http://visakhm.blogspot.com/2011/12/generating-pdf-pack-reports-in-ssrs.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/





Do you have a batch file that will merge two pdf's? That would be great if I could borrow it.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-10-01 : 12:28:49
quote:
Originally posted by Dirch

quote:
Originally posted by visakh16

why do you need SSIS for this? SSIS is not file merging tool
We make use of batch scripts for this

Alternatively if its for ssrs reports you could even try this

http://visakhm.blogspot.com/2011/12/generating-pdf-pack-reports-in-ssrs.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/





Do you have a batch file that will merge two pdf's? That would be great if I could borrow it.


see one in lines of what we used

http://www.a-pdf.com/faq/how-to-merge-multiple-couples-of-pdf-files-into-single-ones-together.htm

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

carolinenew
Starting Member

4 Posts

Posted - 2014-04-14 : 23:21:58
the following external pdf merger enable to merge two or more pdf documents. can it be used on SSIS?
http://www.rasteredge.com/how-to/csharp-imaging/pdf-merge-split/
http://www.rasteredge.com/how-to/csharp-imaging/pdf-processing/
Go to Top of Page
   

- Advertisement -