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 |
|
petek
Posting Yak Master
192 Posts |
 Posted - 2009-05-12 : 09:20:10
|
| Hi all,I have created a SSIS Package; the package runs fine if i:1. connect to Integration Services2. Expand Stored Packages3. Expand MSDB4. ServerName5. Expand Package Folder6. Right-Click Package Name 7. Select Run Package8. Click Executehowever if i....1. Create a SQL Server Agent Job 2. Schedule the SSIS package 3. Right-Click select Start job at Step....4. It does nothing. If I right-click on the Job and select view history it says the job succeeded but the output is not as expected Any ideasKind RegardsPete. |
|
|
shaunc
Starting Member
28 Posts |
Posted - 2009-05-12 : 11:38:41
|
| The first thing I'd check is to make sure the owner of the Agent job has the correct permissions to run it. |
 |
|
|
petek
Posting Yak Master
192 Posts |
Posted - 2009-05-13 : 05:47:42
|
| Hi i have a domian account that the SSIS service runs under and this accounrt has access to the db engine. but it still does not work.Any IdeasKind RegardsPete. |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-05-13 : 08:01:01
|
| "...but the output is not as expected"Does your output requires file creation or modification? |
|
|
|
|
|
|
Execute SSIS Package