Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
maevr
Posting Yak Master
169 Posts |
 Posted - 2009-11-16 : 03:03:44
|
| 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? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-16 : 09:29:33
|
| 1. Make sure SQL Agent account has permissions2. Make sure SSIS pkg protection level is set to server storage.what error message r u getting? |
 |
|
|
smeeluv
Starting Member
20 Posts |
Posted - 2009-11-16 : 09:57:41
|
| 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. |
|
|
|
maevr
Posting Yak Master
169 Posts |
Posted - 2009-11-20 : 02:45:55
|
| 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. |
|
|
|
|
|
|
Cannot run SSIS package from SQL Server agent