jdr0606
asked on
Prompt and pass parameter to a SSIS job
I have a SQL statement that I run manually each day and have to change one or more pieces of information such as the date when I run it.
The results of the statement generates a "|" delimited file.
Is it possible to set this up as an SSIS that will prompt for parameters?
Thanks
The results of the statement generates a "|" delimited file.
Is it possible to set this up as an SSIS that will prompt for parameters?
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you planning on installing SSIS on every users workstation? That could be a lot of licenses.
ASKER
No, only a couple of users need to run this process.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the feedback.
I asked the question more as "could it be done" before I determined if that was a direction to go.
Clearly from your comments this is not the best approach to my issue.
A simple .NET app will will be a much better solution.
Thanks again!
I asked the question more as "could it be done" before I determined if that was a direction to go.
Clearly from your comments this is not the best approach to my issue.
A simple .NET app will will be a much better solution.
Thanks again!
>>A simple .NET app will will be a much better solution.<<
Absolutely. SSIS packages are for the most part best left unattended.
Absolutely. SSIS packages are for the most part best left unattended.
ASKER