SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Problem in SSIS Job creation
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Jeet Singh
Starting Member

India
1 Posts

Posted - 12/10/2012 :  04:11:28  Show Profile  Reply with Quote

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.

i have provided
these roles to the user
db_ssisadmin
db_owner
Sqlagentoperatorrole
sqlagentreaderrole
sqlagentuserrole

johnson_ef
Starting Member

India
16 Posts

Posted - 12/12/2012 :  03:34:37  Show Profile  Reply with Quote
Have you tried to execute the Package directly, I mean 'Right Click the Package' from integration services and try 'Run Package' option.

what is the error you get when you try to do this?
-Johnson
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000