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 |
|
powellbound
Starting Member
23 Posts |
 Posted - 2008-10-21 : 18:17:26
|
| I have a SSIS package from VS 2005 (in the .dtsx format) and I want to set it up to run as a Job in SQL2005. How do I get the package to SQLServer?TIA |
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2008-10-21 : 21:11:21
|
| you need to build and deploy the packagehey |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-22 : 00:53:30
|
| Go to SQL management studio. Connect to Integration Services engine on your server.Expand stored packages->MSDB.Right click and select Import package ->File System and browse to local path of package file. It will automatically take package name. finally select 'rely on server store and roles for access...' option for protection level and click ok. The package will get exported to server.then go to sql agent and create a job to execute this package. |
|
|
|
|
|
|
SSIS Package to SQLJob Question