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

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.