Yes I am working from Visual studio.

Yes I can connect to all servers using SSMS form the source server where my package is being run in Visual studio.

Hi John & All,

I tested the following.

Had only 1 server along with this statement :

update tableA set filepath = ?

This statement ran successfully for only 1 server(ServerA).The related tableA in...

Yes,I do have access to the other server.Tested and tried.

I have checked it and cant seem to understand.Anysuggestions please.

I am able to connect,buthe update works only the first time the update statement runs i.e only for the first server value in the User:serverlist variable.

This is my update statement:

I have tried these 2 statements as underneath.

update dbo.BackupDeviceInfo

set filepath = 'C:\ABCDEF\' +'?'

update SMSPHcdb.dbo.BackupDeviceInfo

set filepath = 'C:\ABCDEF\' +?

The update statement works on the first...

This is my update statement:

I have tried these 2 statements as underneath.

update dbo.BackupDeviceInfo

set filepath = "C:\ABCDEF\" +"?"

update dbo.BackupDeviceInfo

set filepath = "C:\ABCDEF\" +?

My parameter mapping under Execute SQL editor...

This is my update statement:

I have tried these 2 statements as underneath.

update dbo.BackupDeviceInfo

set filepath = 'C:\ABCDEF\' +'?'

update SMSPHcdb.dbo.BackupDeviceInfo

set filepath = 'C:\ABCDEF\' +?

The update statement works on the first...

The above code is part of an SSRS report.After setting variables properly it is still not filtering data based of the date column.

oops...thanks ... feel stupid now.Thanks anyway !

That is already included in the Connection manager.But that dynamic server name change is not getting into the execute sql task and hence

The execute sql task(update sql) is not updating...

I did that and it worked for me.But the update is working only on the source server where I am running this package.The update needs to run across all servers.What...

.

It still shows an error.There were errors during task validation and the Execute SQL task editor has not turned green.It displays with a red cross mark.

What are the following values...

This is the update statement.

"update [ABCD].[dbo].[Table]

set filepath='\\\\abc002\users\myuser\myfolder\\" + @[User::currentserver'] + "'"

[Execute SQL Task] Error: Executing the query ""update [ABCD].[dbo].[Table]

set ..." failed with the following error:...