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:...

I used file instead of command.

Command line parameters:-file C:\PS\email.ps1

It did not send out an email alert upon stopping the SQLAgent.

#variables

$emailFrom = "asdfAlerts@fghj.org"

$emailTo = "abcdef@fghj.org"

$subject = "Powershell Function calling an SMTP server"

$body = "Send an email through SMTP in Powershell"

$smtpServer = "smtp.fghj.org"

#create a function

Function sendEmail([string]$emailFrom, [string]$emailTo, [string]$subject,[string]$body,[string]$smtpServer)

{

$smtp = new-object Net.Mail.SmtpClient($smtpServer)

$smtp.Send($emailFrom,$emailTo,$subject,$body)

}

sendEmail...

powershell.exe -noprofile -command Send-MailMessage –From asfdsa@gdfgs.org –To abcd@abcd.org –Subject "Test Email" –Body "Powershell Email Testing" –SmtpServer smtp.abcd.org

The above code runs as part of SQL job but does not...