Hi, I'm developing via SSIS 2008 for couple of months, I've developed and deployed packages and projects several times. I recently encountered a problem when was asked to deploy an SSIS project on a NEW server which has SSIS 2008 and SQL SERVER 2008 installed. I followed the steps described on this familiar link: http://msdn.microsoft.com/en-us/library/ms140117.aspx. I've deployed the project to an instance of SQL Server, However when I got to step 5 ("Specify Target SQL Server page") I was asked to insert not only the server name - but a "package path" as well. This is the fist time I was asked to insert a "package path". (It's appears just above the "rely on server storage for encrytion" check box, it's first time I see it) I usually get this screen without the "package path" text box part. On this step I usually enter the server name and move on to the next step. Since I had no idea what to enter there i pressed the the "next" button but I got the following message: "package path is not specified, please specify a valid package path". This is the first time this server is "being deployed" by SSIS. Do you think it's got to do with my problem? Does anyone have an idea why I was asked to enter a package path while deploying a package? what should I enter there? Thanks! David

you need to select a path to deploy your package on target sql server, look at this picture tutorial ( deploying a package secion ): http://www.protalk.in/sql-server/steps-to-create-and-deploy-ssis-package-as-a-sqlagent-job/ and let us know if you have problem again.http://www.rad.pasfu.com

When I press the "Browse" Button I get an error message that there is no connection to sql server. However, I manage to connect to sql server DB and even Integration services via sql server managment studio. As I wrote, It's the first time I deploy SSIS project to this server - so It's possible that didn't configure something SSIS and SQL SERVER correctly... I just don't know where to check... Any Idea? Thanks again' David

When I press the "Browse" Button I get an error message that there is no connection to sql server. However, I manage to connect to sql server DB and even Integration services via sql server managment studio. As I wrote, It's the first time I deploy SSIS project to this server - so It's possible that didn't configure something SSIS and SQL SERVER correctly... I just don't know where to check... Any Idea? Thanks again' David Is your authentication to sql server correct? do you have user name and password and used sql server authentication?http://www.rad.pasfu.com

Problem solved. It was Sql server issuse. Thanks!