Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Problem In ssis Job creation Expand / Collapse
Author
Message
Posted Friday, December 7, 2012 6:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 6:14 AM
Points: 251, Visits: 615
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
Posted Friday, December 7, 2012 7:00 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:24 AM
Points: 5,430, Visits: 10,099
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
Posted Friday, December 7, 2012 7:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 6:14 AM
Points: 251, Visits: 615
Hi John
but this does not happen when user have sysadmin permission
but without this it takes time
Post #1394062
Posted Friday, December 7, 2012 7:46 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:24 AM
Points: 5,430, Visits: 10,099
What permission does the user have, if not sysadmin? To manage jobs, membership of certain role(s) in msdb is necessary.

John
Post #1394068
Posted Sunday, December 9, 2012 9:57 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 6:14 AM
Points: 251, Visits: 615
the permissions that user have are
db_ssisadmin
db_owner
Sqlagentoperatorrole
sqlagentreaderrole
sqlagentuserrole
Post #1394444
Posted Monday, December 10, 2012 6:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 6:14 AM
Points: 251, Visits: 615
hey john
plz help for the issue
Post #1394576
Posted Tuesday, December 11, 2012 1:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:24 AM
Points: 5,430, Visits: 10,099
What happens if you create a new login and make it a member of SQLAgentOperatorRole in msdb?

John
Post #1394938
Posted Tuesday, December 11, 2012 2:07 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 6:14 AM
Points: 251, Visits: 615
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
Posted Tuesday, December 11, 2012 2:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:24 AM
Points: 5,430, Visits: 10,099
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
Posted Tuesday, December 11, 2012 4:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 6:14 AM
Points: 251, Visits: 615
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 »

Add to briefcase 12»»

Permissions Expand / Collapse