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-03-03 : 05:08:15
|
| I have created a ssis package. This package gets executed using a job on my local machine. All works fine.Now, I have placed the page in Dev machine. It is under the storedpackages\FileSystem in SSIS in the Dev machine. Executing the package on the Dev machine works correctly also. Now I set up a job on the Dev machine to call this package. I did the same steps as my local machine. Problems is that when the package is started it says success as start job but it shows the execute job as success straightaway and so the tasks inside the ssis package do not run.Note that there is no permissioning issue at present.Any thoughts please?Thanks |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2010-03-03 : 12:30:13
|
| Question: What are the steps/tasks are you performing on the SSIS?Does SSIS package (NOT JOB) itself ran successfully on DEV? Try this first, if any errors fix it before schuedling a job.Check the User permissions which you are going to use to run the Package.With RegardsSR |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2010-03-03 : 17:03:15
|
| Hi,As I mentioned "Executing the package on the Dev machine works correctly also", so yes the package on the Dev works crrectly.Any suggestions please?Thanks |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2010-03-05 : 04:12:31
|
| This was solved after placing sp3.Thank you |
|
|
|
|
|
|
job