This is what I am trying to do.

select sj.name,sj.enabled,sjh.step_id,sjh.message from

sysjobhistory sjh inner join sysjobs sj

on sj.job_id=sjh.job_id

and sj.enabled='1'

In this query result.For every sj.name there will 1 or more sjh.step_id 's and...

Have you tried writing a different SQLAgent task to ensure that you have the task launch under these conditions? <--- What do you mean by this ?

Yes to both powershell...

Can anyone please help fix this ?

Thanks

The above script is working perfectly but it only checks the RDP access for a server and does not check if we have DB access.How I enhance the above code...

resolved this...thanks

Yes

I tried this code on one of the tables which has col values as fadsf-ff,fsdf-ffg,edf-d

and this code should select values after the '-' in the string from colA

SELECT SUBSTRING ([DB].[dbo].[Table1].[ColA],...

Use SUBSTRING/CHARINDEX (if the number of characters after the '-' is variable and there is only one '-' in the string: SUBSTRING(TableA.ColA, CHARINDEX('-', TableA.ColA), LEN(ColA)) = TableB.ColA

The above condition does...

The execute sql task is not the only task in the for each loop.There is file task in the for each loop.

I do not have any connection managers as there...

The for each loop container has Execute SQL Task and also a File system task

Based on the number of input servers (select in the 1st execute task outside the for...

Hi John,

Attached are screenshots of the variables and the package and also the parameter mappings.

The first task inside the for loop creates as many directories as the number of servers...

As of now my SSIS package only update the first server it comes across in the for each loop , updates the relevant column and then fails stating that the...

Hi SSCommited,

Appreciate the detailed reply.

This is what I have and need to fix.

I have an execute SQL task editor inside a for each loop which has this SQL statement

update DB.dbo.Table...

I have tried the parameter path and its not working.

Can you please give sample update statement/s for both the options you mentioned ..

I have posted what I did on this...

I have looped through servers many a times and appreciate the link for the same.

In this case my update statement should like what ?

update tabelA set col1='\path\User::currentservername\'

How do I write...