May 8, 2013 at 12:54 pm
I have deployed a ssis pkg that only has a script task showing messagebox.
dabaseeployment was successfully done in sql database.now I want to schedule it as job.I am getting various error as machinename/administrator user does not have permission or bad password logon failure.
I did create proper credentila and mapped it to amchinename/administrator user and created proxy for this credential. still not job does not start.Can anyone tell me in detail the proper steps for scheduling ssis pkg in ssms.and security account required for user.
May 14, 2013 at 3:45 am
sej2008 (5/8/2013)
I have deployed a ssis pkg that only has a script task showing messagebox.dabaseeployment was successfully done in sql database.now I want to schedule it as job.I am getting various error as machinename/administrator user does not have permission or bad password logon failure.
I did create proper credentila and mapped it to amchinename/administrator user and created proxy for this credential. still not job does not start.Can anyone tell me in detail the proper steps for scheduling ssis pkg in ssms.and security account required for user.
What is the protection level of the package?
By the way, you will not see the message box on the server, leaving you with a hanging package.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 14, 2013 at 5:11 am
.. leaving you with a hanging package.
Nobody wants that
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy