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 |
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? |
 |
|
|
|
|