No announcements
Found 538503 threads
-
1 Votesmigrate mainframe db2 data into sql server
It's an entire DB2 mainframe database, which consists of about 70 tables so I figured my approach would be one at a time to better isolate logical groupings of data.Answered | 7 Replies | 6261 Views | Created by Reppster - Thursday, January 7, 2010 7:35 PM | Last reply by Reppster - Friday, January 8, 2010 3:11 PM
-
2 Votes
PowerPivot or PowerQuery to connect in MainFrame
IBM DB2 and many other sources, it PowerPivot: And PowerQuery: Olaf Helper [ Blog] [ Xing] [ ...Answered | 1 Replies | 1380 Views | Created by alciro - Monday, December 15, 2014 2:06 PM | Last reply by Olaf Helper - Monday, December 15, 2014 2:20 PM -
1 Votes
Connecting to a IBM Mainframe Server, Not the Typical SQL Server
Yes, that's right I'm connecting to DB2.Answered | 2 Replies | 4510 Views | Created by encryptoras - Thursday, September 1, 2011 8:01 PM | Last reply by encryptoras - Friday, September 2, 2011 12:09 PM -
0 Votes
Creating Feeds for mainframe systems
Hi, I haven't tried it , but try below links , it will help you to some extent for sure ...Answered | 2 Replies | 2524 Views | Created by BLR_ETL - Friday, September 13, 2013 6:08 AM | Last reply by SathyanarrayananS - Friday, September 13, 2013 4:32 PM -
1 Votes
Mainframe modernization
Especially if it's a DB2 application.Answered | 1 Replies | 1081 Views | Created by Gabriela Dumencu - Friday, March 20, 2015 7:03 PM | Last reply by davidbaxterbrowne - Friday, March 20, 2015 8:02 PM -
0 Votes
Help with connecting to DB2 using SSIS
The connecting user must have rights in DB2 to create and bind packages.Answered | 12 Replies | 8508 Views | Created by nancy25dec - Friday, February 6, 2009 1:31 AM | Last reply by Naren_USB - Thursday, July 19, 2018 5:10 PM -
0 Votes
Connecting to DB2 on zOS in an SSIS Package
BTW, I have DB2 client tools on my machine already installed.Answered | 5 Replies | 6805 Views | Created by DB2SSIS_USER - Tuesday, April 10, 2012 8:16 PM | Last reply by DB2SSIS_USER - Wednesday, April 11, 2012 4:32 PM -
0 Votes
DB2 connection manager
To fix this issue, we should select the Microsoft OLE DB Provider for DB2 from the list of available drivers as Provider, then refer to the details steps in the blog ...Answered | 2 Replies | 2473 Views | Created by sqlguy10 - Monday, August 17, 2015 9:32 PM | Last reply by Katherine Xiong - Thursday, August 20, 2015 7:59 AM -
1 Votes
Problems with SSIS when transfering character data from Mainframe DB2 ebcedic to MSSQL 2012 unicode
But is quite easy to make the load happen by the means of a Transformation Script as described ...Answered | 2 Replies | 649 Views | Created by Hannis P. Wardum - Tuesday, March 15, 2016 9:54 AM | Last reply by Hannis P. Wardum - Tuesday, March 29, 2016 12:04 PM -
0 Votes
I am having an query which will run on mainframe.but i am dont have any idea to connect to mainframe.
I am using DB2, ok i will install IBM DB2 connect driver. and then try to run the query using OdbcConnection.Answered | 5 Replies | 1706 Views | Created by Ankit Rajput - Wednesday, November 21, 2012 7:30 AM | Last reply by Roar Jørstad - Wednesday, November 21, 2012 10:40 AM -
0 Votes
Connecting DB2 USING SSIS
Hi Vipin jha, After you install the Microsoft OLE DB Provider for DB2 using the link Koen provided, create a connection manager in your package ...Answered | 3 Replies | 20399 Views | Created by Vipin jha - Wednesday, May 9, 2012 5:26 AM | Last reply by Eileen Zhao - Friday, May 11, 2012 8:28 AM -
1 Votes
Connect sqlserver to DB2
Hi Rishi_rich, We can perform the following steps to connect SQL Server 2008 to DB2: 1.Answered | 1 Replies | 4015 Views | Created by Rishi_rich - Thursday, September 6, 2012 10:22 AM | Last reply by Allen Li - MSFT - Friday, September 7, 2012 9:01 AM -
3 Votes
Connecting to DB2 from PowerPivot
You said you have 32-bit Windows; you need to make sure the connection type is 32-bit as well.Answered | 4 Replies | 8296 Views | Created by MSDN Student - Wednesday, April 25, 2012 1:22 PM | Last reply by Ed Price - MSFT - Monday, October 28, 2013 7:11 AM -
0 Votes
Importing from Mainframe with Host Integration Server
But it is not connecting with mainframe.Answered | 16 Replies | 1861 Views | Created by Shaheen24s - Monday, October 21, 2019 4:51 PM | Last reply by Shaheen24s - Wednesday, October 30, 2019 1:11 PM -
0 Votes
DB2 CONNECTION issues
http://geekswithblogs.net/13DaysaWeek/archive/2010/05/16/connecting-to-db2-from-ssis.aspx http://social.msdn.microsoft.com/Forums/en-US/sqlinte ...Answered | 2 Replies | 2343 Views | Created by Vipin jha - Friday, May 18, 2012 4:46 AM | Last reply by Sriindu - Friday, May 18, 2012 12:48 PM -
0 Votes
IBM DB2 connectivity issue
Hi, I am using visual studio 2005 for my web application and my back end is SQL Server. our requirement is to get the details from DB2 and we need to display in our web ...Answered | 1 Replies | 1468 Views | Created by Ram MP - Wednesday, July 22, 2015 3:28 PM | Last reply by Caillen - Thursday, July 23, 2015 3:58 PM -
0 Votes
how we integrate java application data and mainframe data into ssis
http://sqlserverpedia.com/blog/sql-server-bloggers/etl-method-%E2%80%93-fastest-way-to-get-data-from-db2-to-microsoft-sql-server/ http://geekswithblogs. ...Answered | 6 Replies | 2658 Views | Created by Naresh_a - Wednesday, March 7, 2012 1:15 PM | Last reply by Raunak J - Wednesday, March 7, 2012 1:57 PM -
0 Votes
OleDB connection fail to DB2
To be clear, what type of connection are you trying to use (provide exact version)?Answered | 6 Replies | 5948 Views | Created by on4ciq - Wednesday, April 7, 2010 11:57 AM | Last reply by Marcus Crast - Friday, April 9, 2010 3:55 PM -
0 Votes
Connecting to IBM DB2 data source..
It is using a Shared Data source that is connecting to IBM DB2 server.Answered | 3 Replies | 10202 Views | Created by Poochi74 - Thursday, June 4, 2009 2:07 PM | Last reply by Poochi74 - Monday, June 29, 2009 2:44 PM -
0 Votes
Reading Data from a Mainframe Mailbox
I will find out what kind system is the mainframe.Answered | 8 Replies | 2024 Views | Created by R_Abata - Tuesday, December 10, 2013 1:00 PM | Last reply by COZYROC - Wednesday, December 11, 2013 11:24 PM - Items 1 to 20 of 538503 Next ›
No announcements
