question

bryanflorida avatar image
bryanflorida asked

connecting to a SSIS dev environment

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!
ssis
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Pavel Pawlowski avatar image
Pavel Pawlowski answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

bryanflorida avatar image
bryanflorida answered
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
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.