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 |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2008-09-23 : 15:23:42
|
| I have a package with 4 variables in it.I would like to schedule the package as a sql job.This pacakges is developed & is to be deployed on our Development servers.I have saved the SSIS package to the Development SQL Server.How do I schedule my package as a job?Is there any additional steps required to save the SSIS package variables as well? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-23 : 16:28:45
|
| If variables are in the scope of the package ,then they should be fine. Well Can you elaborate what your package is doing? |
 |
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-09-23 : 16:40:34
|
| It is a simple package that dump's data into flat files.The variables are place holder for some validation on the incoming data. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-23 : 17:00:24
|
| Then schedule it with SQL Server agent Job. Choose Integration Services for Job type. |
|
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-09-23 : 17:06:01
|
| Shall do.Thank You |
|
|
|
|
|
|
Scheduling SSIS pacakge with variables