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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 For each file enumerator not working in job

Author  Topic 

ychougule
Starting Member

1 Post

Posted - 2009-02-24 : 07:53:43
i have a package which reads files from a folder and transfer data to oledb.
package works well when i execute it in BI or in sql enterprise manager.
but when i schedule a job package runs successfully but not transfering data from flat file to oledb destination.

CTDBA
Starting Member

9 Posts

Posted - 2009-02-24 : 09:26:08
What accout is SQL Agent running as? Does that have the rights to the flat file?
Go to Top of Page
   

- Advertisement -