• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 64
  • Last Modified:

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.
0
StampIT
Asked:
StampIT
  • 2
  • 2
1 Solution
 
Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
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.
0
 
StampITAuthor Commented:
Can you explain please ?
0
 
Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
0
 
StampITAuthor Commented:
Thanks. Works great.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now