Deployment File System installation

Hallo,

i created a solution that is working fine in development. I would now like to deploy it on an other server.

We have choosen for a file system -based deployment because this seems to require the least specialized SQL Server-knowledge from the user who will be utilizing this system. I changed the properties of the solution to

CreateDeploymentUtility: true

DeploymentOutputPath : bin\Deployment

Subsequently I build the solution and in the bin\Deployment-folder dtsx-files have been created.

Can anyone tell me what I need to do next to deploy them on an other machine?

Do I need to deploy a complete version of SQL SERVER 2005 Devenv included or is there a lighter installation possible that only contains what I need to run the packages?

Can I shedule the packages to run at a specified moment without DTultil coming up?

When you once found an answer to these many questions i would be most gratefull if you woulkd let me know.

Kind regards,

Paul

I seem to have found a solution to my own questions?

Can anyone tell me what I need to do next to deploy them on an other machine?

Do I need to deploy a complete version of SQL SERVER 2005 Devenv included or is there a lighter installation possible that only contains what I need to run the packages?

I did the test and only succeeded in running the packages after a complete install of SQLServer 2005.

Can I shedule the packages to run at a specified moment without DTultil coming up?

Using the MS-sheduler I sheduled the execution of a batch-file. this batchfile contains the Command line instructions created using DTUtil, preceded by 'DTexec '. for instance. 'DTEXEC /FILE "C:\Program Files\JACBE_IF_CAB\FMC_People.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI'

There might be a more elegant solution but this seems to work .

Kind regards,

Paul

|||

You don't need devenv at all. Devenv comes with the client tools install.

The only thing you need to run packages is to install Integration Services. This is different to the client install.

-Jamie

|||

Hallo Jamie,

Thanks for your swift reply.

I admit i'm not a SQL server specilist but while installing SQL Server 2005 from CD (Microsoft SQL Server 2005 Enterprise Edition December 2005) or DVD the option 'Integration services' is disabled. So I can not single it out for installation. . Is there still an other installation dvd I need or can I download the SSIS server component from somewhere? I did not seem to find it in the download center

With kind regards,

Paul

|||

That's bizarre. I have installed off that CD a number of times and the option is never greyed out. Very strange indeed - I don't know what would cuse this.

I would contact your reseller and ask them why you can't install the software that you have paid for!

-Jamie

sql