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 |
|
kunaaldesai
Starting Member
36 Posts |
 Posted - 2009-10-27 : 21:00:42
|
| I am trying to run SSIS package from SQL server agent and all I am getting is errors. Here I am giving specific details to SQL Server Job scheduler and there is one thing which I am wondering is that how do I specify that I have to run THIS particular package? I mean inJob Scheduler--> new Job---> New Job step--> I filling in specific details :Type : SQL SSISRun As: SQL Server agent service acountPackage Source: Sql ServerServer name and other detailsNow, when it comes to specifying SSIS package name then it shows me tow folders " Data Collector" and " maintenance Plan" none of both contains my package. it even does not let me select any other files. How do I specify my project?Anything |
|
|
Sqlfreak
Starting Member
5 Posts |
Posted - 2009-10-28 : 02:31:41
|
| hi,Just a suggestion .did u try running the SSIS package by creating a proxy account.Maybe by that way u wudnt find the error.U can give that a try too."live and let live..." |
 |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-28 : 05:25:16
|
| To use the Package Source: Sql Server, you need to import your package into SQL Server.Did you do this?If your package files are on the file system, change the Package Source to File Sytem, in the dropdown. |
|
|
|
kunaaldesai
Starting Member
36 Posts |
Posted - 2009-10-29 : 00:20:14
|
| Exactly that worked thank you very much YellowBug.Anything |
|
|
|
|
|
|
Job Scheduler from SSIS