SSIS Vs. SSRS: Date Range

Hello:

SSRS, through report parameters, has the capability to prompt the end user with a date range.  Does SSIS have this capability, when the end user executes a package?

TBSupport
LVL 1
TBSupportAsked:
Who is Participating?
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
>when the end user executes a package?
ONLY if whatever 'executes a package' means captures user-entered dates, and passes those dates as parameters in the command line that executes the package.

SSIS command line switches, scroll WAY down to 'Set Option'

AND

The SSIS package has two variables for beginning and end dates, and those variables are used throughout the package.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Thanks for the grade.  Good luck with your project.  -Jim
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.

All Courses

From novice to tech pro — start learning today.