I've been provided with information about SSIS server and DB DEV server. ( the information is something like this: SSIS DEV environment something like VKABC01 - xx.xxx.xxx.xx BD DEV server something like VABCDEFxx,xxxxx - xx.xxx.xxx.xx Beside this I've also been provided with the username and password. This is all the information I have and I'm supposed to acess that in order to take a look into some fact and dimension tables. The main problem is that I don't have any idea on how to conect to the SSIS DEV environment with the information provided and what do I need to use. Any help would be really appreciated!
TO connect to a SSIS Service for browsing or downloading and/or uploading SSIS packages, you can use SSMS (SQL Server Management Studio). In the Server type combo box in the connection dialog you select Integration Services and to Server name box, you provide the server name (or IP address) you have received. Note, that integration services only support Integrated windows authentication.
Thanks for your answer. I've just tried that using the xx.xxx.xx.xx ( I'm a little bit confused of why do I have the VKABC01 - xx.xxx.xxx.xx , I mean, what is the first part ) but I got an error message ( RPC server not available ) and despite that I don't believe I will be able to sucessfully do it with the windows authentication :\ I know this probably isn't too explicited but I'm really confused with this. Thanks a lot