<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
Problem In ssis Job creation
13 posts, Page 1 of 2
1
2
»»
Problem In ssis Job creation
Rate Topic
Display Mode
Topic Options
Author
Message
jeetsingh.cs
jeetsingh.cs
Posted Friday, December 07, 2012 6:54 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:06 PM
Points: 179,
Visits: 380
when i am trying to create a job to execute an ssis package
then while trying to search for configuration file the job freezes and shows not responding
than after 10 minutes it comes up with computer drives to choose config for config file.
Post #1394044
John Mitchell-245523
John Mitchell-245523
Posted Friday, December 07, 2012 7:00 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 4,434,
Visits: 7,218
And your question is?
It's best to run SSMS on the computer on which the package resides when you're setting up SSIS jobs. If you run it on a client PC, it will look for the files locally.
John
Post #1394047
jeetsingh.cs
jeetsingh.cs
Posted Friday, December 07, 2012 7:29 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:06 PM
Points: 179,
Visits: 380
Hi John
but this does not happen when user have sysadmin permission
but without this it takes time
Post #1394062
John Mitchell-245523
John Mitchell-245523
Posted Friday, December 07, 2012 7:46 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 4,434,
Visits: 7,218
What permission
does
the user have, if not sysadmin? To manage jobs, membership of certain role(s) in msdb is necessary.
John
Post #1394068
jeetsingh.cs
jeetsingh.cs
Posted Sunday, December 09, 2012 9:57 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:06 PM
Points: 179,
Visits: 380
the permissions that user have are
db_ssisadmin
db_owner
Sqlagentoperatorrole
sqlagentreaderrole
sqlagentuserrole
Post #1394444
jeetsingh.cs
jeetsingh.cs
Posted Monday, December 10, 2012 6:33 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:06 PM
Points: 179,
Visits: 380
hey john
plz help for the issue
Post #1394576
John Mitchell-245523
John Mitchell-245523
Posted Tuesday, December 11, 2012 1:52 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 4,434,
Visits: 7,218
What happens if you create a new login and make it a member of SQLAgentOperatorRole in msdb?
John
Post #1394938
jeetsingh.cs
jeetsingh.cs
Posted Tuesday, December 11, 2012 2:07 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:06 PM
Points: 179,
Visits: 380
hey John its still taking the time but this does not happen when
i give the user sysadmin permission but i dnt want user to have this permission.
Post #1394946
John Mitchell-245523
John Mitchell-245523
Posted Tuesday, December 11, 2012 2:27 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 4,434,
Visits: 7,218
I don't know what's going on, then. Try running a Profiler trace to see what's happening in the background when you modify the job.
John
Post #1394955
jeetsingh.cs
jeetsingh.cs
Posted Tuesday, December 11, 2012 4:45 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:06 PM
Points: 179,
Visits: 380
Thanks
i have run profiler for sqlagentoperatorrole it is searching through all the drives available on the network\
but for ssisadmin it leaves the network drive
any method to restrict this.
Post #1395044
« Prev Topic
|
Next Topic »
13 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
