Hello all, This is a simple deployment question. I have SSIS project which just has one package for backing up one database in local server. I changed the properties of the solution and made createdeploymentutility option to true. Then I ran 'build' for the solution.I then executed the manifest file and deployed in the local sql server. But no file is created in the DTS\Packages\package location and also I can't find the package when I am trying to add the package in SQL agent job. Please let me know if I am missing anything. Thanks.

Hello all, This is a simple deployment question. I have SSIS project which just has one package for backing up one database in local server. I changed the properties of the solution and made createdeploymentutility option to true. Then I ran 'build' for the solution.I then executed the manifest file and deployed in the local sql server. But no file is created in the DTS\Packages\package location and also I can't find the package when I am trying to add the package in SQL agent job. Please let me know if I am missing anything. Thanks. Hi, The package actually will be located next to the manifest file, also when you double click on the manifest file, it'll ask you which destination, file system or sql server, if sql server is chosen, it'll ask you for the destination folder or path. What version of SQL SRVR you're using? for 2005 and 2008, here's the steps to check for the package existence. Open MSFT SQL Server Management Studio and choose Connect > Integration Services from the UI. Choose the Server and connect. The packages will be saved under Stored Packages then MSDB folder. MCITP - BI 2008 http://asqlb.blogspot.com/

Yes, the package is there in bin\deployment folder with the manifest file. Do I need to do anything with the package by running this file? Yes I chose local sql server for deployment and in the destination path, the folder has been created but there is no file in it. I did like you said, but I can't find the package in MSDB.

Yes I found the problem, I was looking for the name of the solution but the name in the properties is still package.

Yes, the package is there in bin\deployment folder with the manifest file. Do I need to do anything with the package by running this file? Yes I chose local sql server for deployment and in the destination path, the folder has been created but there is no file in it. I did like you said, but I can't find the package in MSDB. This is weird! Never heard of that! usually you just slect SQL deployment, click on the elipsis, select the default location and hit next and it'll upload it if you have permission! can you test if you can do that from bids?? select 'File' --> 'Save copy of ... AS' and select SQL server, that will take care of deployment. Do you have any package configuration going with the package? if not, you can just ignore the deployment utility, and from inside BIDS you can select 'File' --> 'Save copy of ... AS' and select SQL server, that will take care of deployment. MCITP - BI 2008 http://asqlb.blogspot.com/