Goal: I am trying to using Import and Export Wizard in SSIS to grab data from mainframe and put in a sql database. I am stuck at the beginning point: how to connect to the mainframe?
I picked the mainframe as my data source. Then on the Data Link Property window under connection, there is Data Source and Location. I assume Data Source is the ip address of my mainframe, and location is the database I am trying to link to. Correct me if I am totally wrong.:) The problem is I don't know what database is on there. Is there a way I can look up what database on that mainframe? I do have a user name and password.
Thanks in advance,
I picked the mainframe as my data source. Then on the Data Link Property window under connection, there is Data Source and Location. I assume Data Source is the ip address of my mainframe, and location is the database I am trying to link to. Correct me if I am totally wrong.:) The problem is I don't know what database is on there. Is there a way I can look up what database on that mainframe? I do have a user name and password.
Thanks in advance,