By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,377 Members | 1,330 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,377 IT Pros & Developers. It's quick & easy.

How to connect to mainframe through Integration Service

P: 2
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,
Mar 25 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.

Browse more Microsoft SQL Server Questions on Bytes