dbTalk Databases Forums  

SSIS execution

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss SSIS execution in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
j0hnj0hn
 
Posts: n/a

Default SSIS execution - 02-11-2009 , 01:31 PM






I think this is due to my lack of understanding of the process. I created an
SSIS package that will export rows from the database to a file on the
network. When I run the package in the Execute Package Utility, it exports
the rows as expected, however when I try to set up a job to execute the same
package I get a cannot connect to file [filename] error. I stopped the agent
service and used my login (I have admin rights) and restarted with the same
result. Am I missing something? Why can I execute the saved SSIS package
from the file system, but not the agent?

John

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.