The database will be accessible but if any jobs defined with that owner will not run and you need to change the owner name of those jobs and its...

This the WMI Query i was using

SELECT Caption, CSDVersion, CSName, Version FROM Win32_OperatingSystem

and i was following the document as below and now its working fine

http://www.sqlservercentral.com/Forums/Attachment2144.aspx

Is...

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