No announcements
Found 3524571 threads
-
1 VotesProblems with SSIS when transfering character data from Mainframe DB2 ebcedic to MSSQL 2012 unicode
Hello <u5:p> </u5:p> We have problems with SSIS when transfering character data ...Answered | 2 Replies | 617 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
-
1 Votes
migrate 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 | 6182 Views | Created by Reppster - Thursday, January 7, 2010 7:35 PM | Last reply by Reppster - Friday, January 8, 2010 3:11 PM -
0 Votes
Reading Data from a Mainframe Mailbox
OpenPGP Task -> Zip Task , all without any intermediate file storage.Answered | 8 Replies | 1952 Views | Created by R_Abata - Tuesday, December 10, 2013 1:00 PM | Last reply by COZYROC - Wednesday, December 11, 2013 11:24 PM -
0 Votes
ssis will not accept DB2 ZOS non-unicode data to sql server non-unicode
We need to load 600+ tables from DB2 zos to SQL Server 2012.Answered | 1 Replies | 1127 Views | Created by tcjlr0 - Monday, March 31, 2014 2:57 PM | Last reply by ArthurZ - Monday, March 31, 2014 7:31 PM -
0 Votes
Unicode characters : Flat File Destination SSIS
Yes, there may be some garbage when i convert from unicode to ansi and this may happen occassinally.Answered | 8 Replies | 9439 Views | Created by S Prashant - Wednesday, January 11, 2012 5:02 PM | Last reply by S Prashant - Wednesday, January 18, 2012 10:11 AM -
2 Votes
Move data to DB2 on AS400 with SSIS
hi please let me know how to load data from sql server to as400 through ssis . i am able to load data from sql server to AS400 by linked server.Answered | 37 Replies | 52242 Views | Created by BJ Custard - Tuesday, December 26, 2006 9:36 PM | Last reply by bayapa - Wednesday, July 30, 2014 12:01 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 ...Answered | 6 Replies | 2638 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
transferring data from SQL server 2008 to Db2/400 database
CozyRoc's DB2 Destination http://www.cozyroc.com/ssis/db2-destination.Answered | 2 Replies | 2911 Views | Created by cijojohn - Thursday, May 10, 2012 6:39 PM | Last reply by ArthurZ - Thursday, May 10, 2012 7:08 PM -
0 Votes
ADO.NET Destination to Connect DB2 in SSIS 2012
Hi Dhinesh, You can use the third party SSIS Connetor--CozyRoc for IBM ...Answered | 1 Replies | 3285 Views | Created by Dhinesh_G - Monday, August 19, 2013 8:38 AM | Last reply by Mike Yin - Sunday, August 25, 2013 3:05 PM -
0 Votes
INSERT ENCRYPT COLUMN DATA INTO DB2 FROM SSIS
Another option is use the Script Component with some .Net coding to encrypt your sensitive data.Answered | 2 Replies | 1554 Views | Created by Maivizhi - Tuesday, February 10, 2015 7:01 PM | Last reply by Katherine Xiong - Thursday, February 12, 2015 8:52 AM -
0 Votes
Migrate Db2 sabrix database to MSSQL
Another option is to use ConvertDB migration toolAnswered | 2 Replies | 3334 Views | Created by sehgalajay - Thursday, August 29, 2013 5:23 AM | Last reply by DMSoft - Friday, August 30, 2013 11:51 AM -
1 Votes
Import Data from DB2 iSeries
Try setting it to 0-- Overall, client data transfers from the ibm iseries class of servers might appear as hex #'s [bytes] rather than ascii chars ...Answered | 2 Replies | 2961 Views | Created by Well Doggy - Thursday, October 31, 2013 7:01 PM | Last reply by plditallo - Friday, November 1, 2013 1:00 AM -
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 | 2435 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
Migrating From DB2 to SQL using SSIS
There is a good guide MigrateDB2toSQLServer_2009.pdf from download.microsoft.com Arthur My BlogAnswered | 3 Replies | 10600 Views | Created by Abhay_78 - Thursday, November 11, 2010 2:40 PM | Last reply by Jinchun Chen - Monday, November 15, 2010 3:19 AM -
0 Votes
Unicode data issue with teradata source in SSIS 2012
You need to figure in what collation/Unicode code page Teradata operates and then add a Data Conversion task to convert the source data exactly to this encoding.Answered | 1 Replies | 912 Views | Created by vasu_479 - Tuesday, July 14, 2015 10:12 AM | Last reply by ArthurZ - Tuesday, July 14, 2015 2:06 PM -
0 Votes
SSIS - Oracle OLE DB and Unicode...
SQL Server 2012 has full support of Unicode: Introduced in SQL Server 2012, a new family of supplementary character (SC) collations can be used ...Answered | 2 Replies | 7231 Views | Created by iammac - Saturday, April 28, 2012 3:31 AM | Last reply by Piotr Palka - Monday, April 30, 2012 3:42 AM -
2 Votes
unicode and non-unicode string data types Issue with 2008 SSIS Package
: can store up to 4000 characters Best suited for US English: "One problem with data types that use 1 byte to encode each ...Answered | 5 Replies | 8551 Views | Created by Avik Kesh - Thursday, December 13, 2012 11:28 PM | Last reply by Shivendoo Kumar Dubey - Wednesday, November 12, 2014 2:49 AM -
3 Votes
Linked Server with MSSQL and DB2
uid=swg21394344 If it does not work also, I suspect that the problem should be related to the DB2 instance you specified.Answered | 3 Replies | 3576 Views | Created by Ioakim Ioakimidis - Wednesday, April 1, 2015 1:38 PM | Last reply by SQL Team - MSFT - Wednesday, April 15, 2015 1:56 AM -
0 Votes
Teradata Attunity connector in SSIS for Unicode characters
Since Teradata doesn't have any specific datatype as NVARCHAR, we generally define such field as "VARCHAR(Size) CHARACTER SET UNICODE".Answered | 3 Replies | 3532 Views | Created by n Kishore - Saturday, November 14, 2015 11:03 AM | Last reply by Sudhir Upadhyay - Thursday, August 2, 2018 8:30 PM -
0 Votes
SSIS transfer problem
Hello We have problems with SSIS when transfering character data from Mainframe DB2 ...Answered | 1 Replies | 271 Views | Created by Hannis P. Wardum - Thursday, March 10, 2016 10:08 AM | Last reply by Cor Ligthert - Thursday, March 10, 2016 10:17 AM - Items 1 to 20 of 3524571 Next ›
No announcements
