No announcements
Found 1643093 threads
-
0 VotesIBM DB2 --> SQL SERVER (DTS_E_INDUCEDTRANSFORMFAILUREONERROR & DTS_E_PRIMEOUTPUTFAILED)
Are you inserting into the DB2 system?Answered | 2 Replies | 4899 Views | Created by Karumajji - Thursday, October 15, 2009 8:04 PM | Last reply by Cim Ryan - MSFT - Friday, October 23, 2009 8:05 PM
-
0 Votes
IBM DB2 connectivity issue
Maybe IIS forums or IBM forums are more suitable.Answered | 1 Replies | 1384 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
MS SQL 2008 to IBM DB2 migration possible?
@SoftwareDeveloper83 If you migrate DB2 to SQL Server, I would suggest SSMA.Answered | 2 Replies | 6441 Views | Created by SoftwareDeveloper83 - Friday, April 13, 2012 12:57 PM | Last reply by Peja Tao - Monday, April 16, 2012 2:14 AM -
0 Votes
SQL Server 2014 to IBM DB2 on RS6000
Hi LouBeck10, Link below shows how to add a linked server, you may take a look at it.Answered | 1 Replies | 828 Views | Created by LouBeck10 - Thursday, April 21, 2016 6:00 PM | Last reply by Sam Zha - Friday, April 22, 2016 5:27 AM -
0 Votes
MS DB2 connection drives IBM DB2 Drivers
i have used HIT OLEDB Server 400 and it worked fine with no issues.Answered | 2 Replies | 4646 Views | Created by AB82 - Monday, January 24, 2011 11:47 AM | Last reply by Yogesh Ranade - Monday, January 24, 2011 6:29 PM -
1 Votes
Linked server to IBM DB2 not showing Catalogs/tables etc.
Fixed it by changing the "IBM OLE DB Provider for DB2" to "Microsoft OLE DB Provider for DB2".Answered | 5 Replies | 5480 Views | Created by ClayRP - Tuesday, October 1, 2013 3:36 PM | Last reply by ClayRP - Tuesday, October 22, 2013 2:12 AM -
1 Votes
Connecting to a IBM Mainframe Server, Not the Typical SQL Server
IBM mainframes typically host DB2.Answered | 2 Replies | 4483 Views | Created by encryptoras - Thursday, September 1, 2011 8:01 PM | Last reply by encryptoras - Friday, September 2, 2011 12:09 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 | 10105 Views | Created by Poochi74 - Thursday, June 4, 2009 2:07 PM | Last reply by Poochi74 - Monday, June 29, 2009 2:44 PM -
0 Votes
SSIS package error with IBM OLE DB driver for DB2
There might be some incompatible issue between SSIS and IBM OLE DB Provider for DB2 under some circumstance.Answered | 3 Replies | 9458 Views | Created by Sateesh Maduri - Wednesday, November 17, 2010 12:57 PM | Last reply by Charles Wang - MSFT - Friday, November 19, 2010 4:01 PM -
0 Votes
How to setup SQL Linked Server to connect to IBM DB2 using ODBC instead OLEDB?
Microsoft is moving away from OleDb as a data access technology for SQL Server only.Answered | 2 Replies | 2079 Views | Created by heidi_heidi_heidi - Monday, March 14, 2016 5:28 PM | Last reply by davidbaxterbrowne - Monday, March 14, 2016 5:44 PM -
0 Votes
IBM OLE DB provider for DB2 not listed in SSIS 2008
Do you have SQL Server 2008 Enterprise Edition installed.Answered | 7 Replies | 12719 Views | Created by cristal leos - Friday, March 2, 2012 11:28 PM | Last reply by cristal leos - Tuesday, March 6, 2012 11:16 PM -
1 Votes
link DB2 server
Microsoft OLEDB Provider for DB2 can only be used with Enterprise edition of SQL Server, so the answer is no, you cannot use it to define DB2 as linked ...Answered | 4 Replies | 5681 Views | Created by array2012 - Thursday, January 5, 2012 6:49 AM | Last reply by Krzysztof Kozielczyk - Saturday, January 7, 2012 9:37 PM -
0 Votes
How to use Visual Studio to create stored procedure on IBM iseries db2
Thanks for the reply Yi Feng Li, I do get the "create new procedure" option when right mouse button on procedures folder for an MS SQL Server, as always.Answered | 4 Replies | 6070 Views | Created by rpfinn - Tuesday, November 29, 2011 8:15 PM | Last reply by Ed Dore - Thursday, December 8, 2011 4:06 AM -
0 Votes
Bulk upload AS400/DB2 tables to SQL Server
Have you tried getting the data out from DB2 into a CSV file and then load that csv file to SQL Server ?Answered | 15 Replies | 10721 Views | Created by MHM281 - Friday, May 6, 2011 8:32 PM | Last reply by Peja Tao - Thursday, May 12, 2011 3:14 AM -
0 Votes
IBM DB2 to SQL 2012 migration using SSMA
[Generic: Mandatory] [9472/1] [2016-08-22 08:08:14]: SQL Server Migration Assistant for DB2 v7.0.0 [Generic: Mandatory] [9472/8] ...Answered | 2 Replies | 1908 Views | Created by J.A.Raper - Wednesday, August 10, 2016 4:12 PM | Last reply by justin raper - Monday, August 22, 2016 4:37 PM -
1 Votes
Adding a DB2 database as a linked server in SQL 2000
Just throught I'd ask since you had experience in DB2 as well as sql server.Answered | 28 Replies | 21372 Views | Created by KLS130 - Wednesday, February 25, 2009 12:55 AM | Last reply by Prashant Kulkarni - Friday, May 21, 2010 8:15 PM -
0 Votes
Database Mirroring between SQL and DB2
Is there a way to mirror database tables from SQL Server to IBM DB2 and vice versa using Integration Services or in another method.Answered | 3 Replies | 1517 Views | Created by miguelh - Tuesday, April 5, 2016 5:05 PM | Last reply by Shanky_621 - Wednesday, April 6, 2016 10:24 AM -
0 Votes
DB2 and SSIS in SQL 2008
Have you checked IBM Data Server Runtime Client?Answered | 10 Replies | 7614 Views | Created by JojoBinkus - Friday, November 11, 2011 3:15 PM | Last reply by COZYROC - Saturday, November 12, 2011 12:47 PM -
1 Votes
How to handle unresolved references to other database platforms (IBM DB2, Oracle)
I have numerous views and stored procedures that select from these foreign datasources (linked server to IBM DB2 database) using 4 part names.Answered | 6 Replies | 3585 Views | Created by SVM79 - Monday, May 13, 2013 4:27 PM | Last reply by SVM79 - Wednesday, May 29, 2013 4:33 PM -
0 Votes
Load data from IBM DB2 source without removing white space
Hi Mr Vivek Singh, So, would you like to preserve trailing spaces in SQL Server, right?Answered | 9 Replies | 1450 Views | Created by Mr Vivek Singh - Wednesday, October 11, 2017 11:23 AM | Last reply by Pirlo Zhang - Thursday, October 12, 2017 8:52 AM - Items 1 to 20 of 1643093 Next ›
No announcements
