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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2010-01-04 : 08:46:09
|
| Hello,I have crearted a package.It is now in File System under SSIS connection in sql server management window (Object Explorer).On right clicking the package under file system, I can select "Run Package" and so the package runs successfully.Now I have created a job to run this package. It runs successfully but I do not see the result happening, so really nothing takes place but it does say successful.In the job step properties, I have set the Type as "SQL Server Integration Services Package"Package source as "SSIS package store"server selected to the name of the local server.package: set to : \File System\ArchiveFeedsAny thoughts why the job is not working correctly please?thanks |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2010-01-04 : 09:17:47
|
| I have managed to narrow down the issue.It is to do with file path.I am using my machine as the The sql server development.The package has a foreach loop container which looks at a file path i.e. \\xxx.com\foldername\importsThis does not seem to be working when scheduling a job.Any thought on this please? |
 |
|
|
|
|
|
Job