Solved

SSIS package sample

Posted on 2011-02-12
5
664 Views
Last Modified: 2012-08-14
Could anyone please let me know about a sample SSIS package code that could copy a table content from an SQL server 2005 source to an Oracle 11g target database?
0
Comment
Question by:toooki
  • 3
  • 2
5 Comments
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 450 total points
ID: 34881767
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 34906344
any luck?
0
 

Author Comment

by:toooki
ID: 34942299
Thank you for the document. I am stuck a bit. I could create the SSIS package and could run it too. I get an warning message when I created it.
I only import two fields of a table from source to target. I attached the warning message. And after the end of the SSIS package execution, I see that the content of the target table is not correct.
 warning messageHere are first 5 entries from the SSIS target table entry:
3433.00      10401.00
3434.00      10393.00
3435.00      7554.00
3436.00      10405.00
3437.00      10406.00

And the corresponding source table entry:
8393      Enhanced support
8394      Sprint - v2.2
8395      Dynamic support in Java
8396      Support WiFi to handoff
8397      Support MTP protocol

There is no similarity.
0
 

Author Comment

by:toooki
ID: 34946535
The above issue was fixed after setting "AlwaysusedefaultCodePage" value from default "False" to "True".

No I can import the entire source table field contents to destination (in empty destination table).
How can I delete the destination table contents before inserting in successive run of the job?
0
 

Author Comment

by:toooki
ID: 34946537
The above issue was fixed after setting "AlwaysusedefaultCodePage" value from default "False" to "True".

Now I can import the entire source table field contents to destination (in empty destination table).
How can I delete the destination table contents before inserting in successive run of the job?
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question