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

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
0
TBSupport
Asked:
TBSupport
  • 2
1 Solution
 
Jim HornMicrosoft 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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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