Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Cannot run SSIS package from SQL Server agent
Started 1 month, 1 week ago by maevr
> Converted DTS package from sql 2000 to SSIS (2005). When run from BIDS everything is fine but when I try to run a scheduled execution it fails. Have tried soring it in SQL Server and creating a proxy but nothing seems to work. I have read and tested the contents of http://support.microsoft.com/kb/918760 , but nothing works. Any tips?
Site: SQL Server Forums  SQL Server Forums - site profile
Forum: SSIS and Import/Export (2005)  SSIS and Import/Export (2005) - forum profile
Total authors: 3 authors
Total thread posts: 4 posts
Thread activity: no new posts during last week
Domain info for: sqlteam.com

Other posts in this thread:

russell replied 1 month, 1 week ago
> 1. Make sure SQL Agent account has permissions 2. Make sure SSIS pkg protection level is set to server storage. what error message r u getting?
Size: 361 bytes
Customize:  Customize "<b>Reply 1</b>: Cannot run SSIS package from SQL Server agent :: SSIS and Import/Export (2005) :: SQL Server Forums"

smeeluv replied 1 month, 1 week ago
> I had same problem earlier. My package was trying to connect to a server that was not in the domain of the server running SQL Agent. Could never get it to run through SQL Agent so I just used windows scheduler to run the package. Not sure if your problem is the same but the windows scheduler is always an option.
Size: 515 bytes
Customize:  Customize "<b>Reply 2</b>: Cannot run SSIS package from SQL Server agent :: SSIS and Import/Export (2005) :: SQL Server Forums"

maevr replied 1 month, 1 week ago
> Thanks for the replies! None of the servers is in a domain since it is virtual machines in a test environment. Error message: Connection may not be configured correctly or you may not haver the right permissions for this connection. Have tried proxy with credentials, server storage.
Size: 520 bytes
Customize:  Customize "<b>Reply 3</b>: Cannot run SSIS package from SQL Server agent :: SSIS and Import/Export (2005) :: SQL Server Forums"

 

Top contributing authors

Name
Posts
maevr
2
user's latest post:
Cannot run SSIS package from SQL...
Published (2009-11-20 02:45:00)
> Thanks for the replies! None of the servers is in a domain since it is virtual machines in a test environment. Error message: Connection may not be configured correctly or you may not haver the right permissions for this connection. Have tried proxy with credentials, server storage.
russell
1
user's latest post:
Cannot run SSIS package from SQL...
Published (2009-11-16 09:29:00)
> 1. Make sure SQL Agent account has permissions 2. Make sure SSIS pkg protection level is set to server storage. what error message r u getting?
smeeluv
1
user's latest post:
Cannot run SSIS package from SQL...
Published (2009-11-16 09:57:00)
> I had same problem earlier. My package was trying to connect to a server that was not in the domain of the server running SQL Agent. Could never get it to run through SQL Agent so I just used windows scheduler to run the package. Not sure if your problem is the same but the windows scheduler is always an option.

Related threads on "SQL Server Forums":

Running SQL SErver 2005 Agent job with SSIS package  SQL Server Forums - site profile A forum for the next version of SQL Server. - forum profile Running SQL SErver 2005 Agent job with SSIS package
Running SQL SErver 2005 Agent job with SSIS package
Problem Running SSIS Package in SQL Server Agent  SQL Server Forums - site profile SQL Server Administration (2005) - forum profile Problem Running SSIS Package in SQL Server Agent
Problem Running SSIS Package in SQL Server Agent
Running SSIS package through SQL Agent  SQL Server Forums - site profile SSIS and Import/Export (2005) - forum profile Running SSIS package through SQL Agent
Running SSIS package through SQL Agent
SSIS Package not running in Agent job  SQL Server Forums - site profile SSIS and Import/Export (2005) - forum profile SSIS Package not running in Agent job
SSIS Package not running in Agent job
SSIS Package Wont Run inside Agent Job  SQL Server Forums - site profile SSIS and Import/Export (2005) - forum profile SSIS Package Wont Run inside Agent Job
SSIS Package Wont Run inside Agent Job
Run SSIS Package as Job (Using Agent)  SQL Server Forums - site profile SQL Server Administration (2005) - forum profile Run SSIS Package as Job (Using Agent)
Run SSIS Package as Job (Using Agent)
Scheduling SSIS Package in SQL JOB  SQL Server Forums - site profile SSIS and Import/Export (2005) - forum profile Scheduling SSIS Package in SQL JOB
Scheduling SSIS Package in SQL JOB
SSIS Package Transfer SQL 2005 - 2008  SQL Server Forums - site profile SSIS and Import/Export (2005) - forum profile SSIS Package Transfer SQL 2005 - 2008
SSIS Package Transfer SQL 2005 - 2008
Problem setting Package Variables in SSIS Package  SQL Server Forums - site profile A forum for the next version of SQL Server. - forum profile Problem setting Package Variables in SSIS Package
Problem setting Package Variables in SSIS Package
Encryption in SSIS package  SQL Server Forums - site profile A forum for the next version of SQL Server. - forum profile Encryption in SSIS package
Encryption in SSIS package

Related threads on other sites:

Login Failure message with SSIS in SQL Agent  http://www.sql-server-performance.com - site profile by: - forum profile Login Failure message with SSIS in SQL Agent
Login Failure message with SSIS in SQL Agent
SSIS or SQL Agent? in microsoft.public.sqlserver.dts  Discussions in microsoft.public.sqlserver.dts - site profile microsoft.public.sqlserver.dts - forum profile SSIS or SQL Agent? in microsoft.public.sqlserver.dts
SSIS or SQL Agent? in microsoft.public.sqlserver.dts
Parameterize query in SSIS package - SQL 2005 in...  Discussions in microsoft.public.sqlserver.dts - site profile microsoft.public.sqlserver.dts - forum profile Parameterize query in SSIS package - SQL 2005 in microsoft.public.sqlserver.dts
Parameterize query in SSIS package - SQL 2005 in microsoft.public.sqlserver.dts
Cannot Execure the SSIS package from AGENT scheduler  SQLServerCentral - site profile SQL Server Agent - forum profile Cannot Execure the SSIS package from AGENT scheduler
Cannot Execure the SSIS package from AGENT scheduler
SSIS or SQL Agent?  SQL Server Forum - site profile DTS - forum profile SSIS or SQL Agent?
SSIS or SQL Agent?
Parameterize query in SSIS package - SQL 2005  SQL Server Forum - site profile DTS - forum profile Parameterize query in SSIS package - SQL 2005
Parameterize query in SSIS package - SQL 2005
SSIS or SQl Agent job moving from a network folder to a...  TechNet Forums - site profile SQL Server Integration Services - forum profile SSIS or SQl Agent job moving from a network folder to a sharepoint folder - Errors... - TechNet Forums
SSIS or SQl Agent job moving from a network folder to a sharepoint folder - Errors... - TechNet Forums
Using Sql Server SSIS with package configurations, then...  Twitter / MakoCSH - site profile MakoCSH - forum profile Using Sql Server SSIS with package configurations, then trying to set up sql agent jobs reminds me of wrestling a 3 headed bear. not fun 7:51 AM Oct 15th from web
Using Sql Server SSIS with package configurations, then trying to set up sql agent jobs reminds me of wrestling a 3 headed bear. not fun 7:51 AM Oct 15th from web
I have an SSIS package kicked off by a SQL Agent Job. It...  Twitter / wendy_dance - site profile wendy_dance - forum profile I have an SSIS package kicked off by a SQL Agent Job. It keeps failing. The DEV won't look into the pkg to say where it's failing. Any recs? 8:25 AM Jun 4th from TweetDeck
I have an SSIS package kicked off by a SQL Agent Job. It keeps failing. The DEV won't look into the pkg to say where it's failing. Any recs? 8:25 AM Jun 4th from TweetDeck
Running SSIS package from SQL Server Agent problems in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.server - site profile microsoft.public.sqlserver.server - forum profile Running SSIS package from SQL Server Agent problems in microsoft.public.sqlserver.server
Running SSIS package from SQL Server Agent problems in microsoft.public.sqlserver.server
Thread profile page for "Cannot run SSIS package from SQL Server agent" on http://www.sqlteam.com. This report page is a snippet summary view from a single thread "Cannot run SSIS package from SQL Server agent", located on the Message Board at http://www.sqlteam.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity