I have the Package deployed by following steps

-->Right Click on Project and Deployment utility is set to true

-->Build the Solution

-->Go to bin\Deployment and run the deployment tool and selected file...

I am using SQL Server 2008 R2

Now i am having the following expression for destination database files as below..and the error that i was getting is

Variables declared:-

I run a query at destination and get the...

Hi !

I still Getting the error in expression for destination database files ... can some one shade some light on expression as i need to make the path for the...

yeah i have query that pulls the data and log files along with path and i am assigning them with variables. Now the Question is how to have the expression...

ok.. I do have 2 variables one for data file and log file as @[User::V_DataFile], @[User::V_LogFile]. .So i want to define the files in run time and make them...

Please find the error message as below that i was getting ....

TITLE: Expression Builder

------------------------------

Expression cannot be evaluated.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2008&ProdVer=9.0.30729.1&EvtSrc=Microsoft.DataTransformationServices.Controls.TaskUIFramework.TaskUIFrameworkSR&EvtID=FailToEvaluateExpression&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

Attempt to parse the expression ""TestData.mdf","@[User::V_DataFile] ","";"TestLog_log.LDF","@[User::V_LogFile]",""" failed....

Hi wanted to do this as my boss asked me to do the following....

"test to see we can add an index in a different database then the prime table and...

so can we create the non clustered index in my case then ?I have a table in database1 and i created the view in database2 for table in database1. So...

So With out Package configuration Step we can successfully deploy the SSIS Package right ?I was under the impression that with out the Package Configuration Step we may not be...

Thanks every one now its working the expression in server name property would be like as below

@[User::V_VirtualIP] +","+ @[User::V_PortNO]

Yes !In dynamic connection we could only see empty values ..so the connection string looks like this . and in expression i was giving the myservername+","+ portno where myservername and...

Hi !

I do have a list of Virtual IP Address and Port Numbers of different servers in a table and i would like to make the dynamic connection and in...

Hi !

I even Tried in the expression by selecting the server-name property and gave the following expression . but still having the connection issue .can some one help me with...

Hi !

I guess i am going wrong with the expression in the connection string where i was using the virtualIP Address and Portno parameters for connecting to server ,SO can...