Post reply

how to conect to a SSIS dev environment

  • May 18, 2011 at 3:41 am

    #240416

    Hi,

    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!

  • May 18, 2011 at 5:37 am

    #1326343

    Fact and dimension tables are normal SQL Server database tables.

    So, open SSMS (SQL Server Management Studio). Connect to the server VABCDEFxx:xxxxx (I think it is port number, so use colon instead of comma) using the username and password.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply