deploying SSIS

Hi

We are storing our packages in File System.

Process:

BIDS->Right Click on soln file ->properties->Deployment Utility->DeploymentOutputPath--Bin\Deployment

So it creates a folder with the project name and all the packages in C:\Program Files\Microsoft SQL Server\90\DTS\Packages\Project

While executing the package on Server what should be thesource of the Package? I mean should it refer to the solution file->..dtsx

or

Bin\Deployment->packages

or

C:\Program Files\Microsoft SQL Server\90\DTS\Packages\Project

Moving from .NET Framework Data Access and Storage...|||

Paarul wrote:

Hi

We are storing our packages in File System.

Process:

BIDS->Right Click on soln file ->properties->Deployment Utility->DeploymentOutputPath--Bin\Deployment

So it creates a folder with the project name and all the packages in C:\Program Files\Microsoft SQL Server\90\DTS\Packages\Project

While executing the package on Server what should be thesource of the Package? I mean should it refer to the solution file->..dtsx

or

Bin\Deployment->packages

or

C:\Program Files\Microsoft SQL Server\90\DTS\Packages\Project

You need to point to the folder holding the .dtsx file in the server no matter hoe you deploy it.