Thank you its working 🙂

Yes they are stored on remote batch server

Hi! I don't have the Server engine installed on my machine so how would i extract the SSIS package list from batch server ?

Thanks Sam It's Working 🙂

Hi Sam !

Could you also please share snapshot of Input/OutPut properties configuration of advanced editor ??? As i was not able to configure them correctly ...

Thanks a lot

Hi Sam I tried doing like what you said as below but no luck any other process or query i can try to get instances running on a machine ...

I did the following steps but its failing stating that invalid object #GetInstances in the dataflow task while configuring Source ODBC connection using SQL Command ..Any help over here...

I Have even attempted by replacing data flow with execute sql Task and tried to insert the data to table in one server but i was getting error as...

Can some one shade some light by giving step by step to configure this process of log shipping with one primary and two secondary servers?

Thanks in advance

yes i guess we can do by configuring the log shipping from primary to secondary and from logshipping wizard you can add one more secondary server.so this would be now...

Hi i was trying to make the expression for connection string like below but still i am not getting the data .. is there any issue with my connection string...

Hi!

1) I had One Execute SQL Task and get the list of servers and stores in a dataset variable object

2)and next for...

I Have the Host names around 500 and i need to loop to each host name and get the data of information like Host name,IP address,OS_Version ,Instance Names,Dbms_version,Port_number for each...

Hi can you please provide me with WMI query to get the Server Name, instance names, IP address,OS_version,Dbms_version,Domain,Portnumbers for each instance

Thanks in advance

Hi Is there any query as such to remove all users except sa and system account users ?