Hello everyone. I am trying to setup a process in which a user, who is using a vb.net 2008 application, will need to trigger the creation of two items. The first is SSRS report which will need to be exported to PDF format to a shared
folder on the network. This report accepts one parameter. The second thing that will need to be created at the same time is an excel file with data exported from SQL Server 2008 which is generated through an SSIS package. A couple things
to note. The excel file and the pdf file need to have the same file name, other than the extension. For example P00000001_20100831.pdf and P00000001_20100831.xlsx and will both be stored in the same network share. The filenames need to be
created dynamically at run time and will be based on a parameter being passed to the report.
So far I have the portion that creates the excel file working fine. The way I create that is as follows. I have a stored procedure that creates a job which calls the SSIS package and passes the appropriate parameters to the SSIS package.
After the job is created I immediately run it and then delete the job. Ok, everything works fine with that.
Now I cant seem to figure out how to get the pdf created. If possible I would like to keep this portion together with the already created job or package.&nb
View Complete Post