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.
