Link to home
Start Free TrialLog in
Avatar of StampIT
StampITFlag for United States of America

asked on

Rename pdf file using Integration Services

I am using Subscriptions to save an SSRS report as pdf into a network folder mjd\send at 6:00 am on weekdays. The name of the file is rptPot.pdf. The file is overwritten each day. I would like to create a package in integration services that would rename this file to rptPot_CurrentDate_CurrentTime so that I have a copy of each day's file.  How would I accomplish this ? Thanks.
Avatar of Arifhusen Ansari
Arifhusen Ansari
Flag of India image

You do not need to create SSIS package for this. Rather you can use data driven subscription and create the file based on dynamic field.

If will created file as per your requirement.
Avatar of StampIT

ASKER

Can you explain please ?
ASKER CERTIFIED SOLUTION
Avatar of Arifhusen Ansari
Arifhusen Ansari
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of StampIT

ASKER

Thanks. Works great.