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 |
|
Zix
Starting Member
31 Posts |
 Posted - 2010-01-28 : 23:05:26
|
| I have created an SSIS package that I want to run on a regular basis. I assumed I could simply call the .dtsx package from the Windows Task Scheduler. I guess not...Anyway, I found this topic that seems to address the same question:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=135006&SearchTerms=run,a,packageI *think* I did what this topic describes but I'm not sure. Is this saying that by simply changing the package source to "File System" from the default that you are importing the package into SQL Server? Are there other steps?Thanks!cc |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-29 : 02:26:09
|
| "I assumed I could simply call the .dtsx package from the Windows Task Scheduler"There is a task scheduled in SQL, part of SQL Agent, which is what I think you need.However, SQL Agent may not be available in SQL Express - what version have you got? |
 |
|
|
Zix
Starting Member
31 Posts |
Posted - 2010-01-29 : 06:48:39
|
| Hi Kristen.This is SQL Server 2008 Developer Edition. As far as I can tell from the documentation, it should have full functionality. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-29 : 09:40:42
|
"it should have full functionality"Indeed, Developer Version gives you full functionality equivalent to Enterprise Edition  I'm not familiar with SSIS.In SQL Server Management Studio (SSMS) (open up the Server tree in the left pane) you should see SQL Agent at the bottom.You can schedule jobs from that HOWEVER I would expect you to find a "Schedule" option within SSIS - e.g. Right Click & Set Schedule - but I would then expect that to use SQL Agent Jobs to actually do the scheduling. It would not make sense that you have to manually schedule it in SQL Agent.But as I don't know SSIS I can't point you are "where" to find that function.Hopefully you can see SQL Agent in SSMS? |
|
|
|
Zix
Starting Member
31 Posts |
Posted - 2010-01-29 : 10:00:59
|
quote:
Hopefully you can see SQL Agent in SSMS?
Yes. And that definitely seems to be the way to go.Feeling my way through the GUI, I set up the schedule to run 10 minutes in the future. It didn't run so I think I must have something set up correctly. The GUI is not that complicated, but there are a TON of options.The post I noted initially talked about "importing" the package. I'm not sure what that meant. Also, I'm pathing out to the package.dtsx. I assume that is correct?I feel like there is one checkbox or something that I'm missing. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-29 : 12:45:50
|
| "I feel like there is one checkbox or something that I'm missing."Enabled / Disabled ?? |
|
|
|
Zix
Starting Member
31 Posts |
Posted - 2010-01-30 : 07:43:12
|
| I don't know. Like everything else in SQL Server this simple function has been made unnecessarily difficult. Here is a screenshot of how I have everything set up.http://obsidistech.com/SS_Task.docThanks,Clay |
|
|
|
|
|
|
|
|
Scheduling SSIS Package