Solved

SSIS package sample

Posted on 2011-02-12
5
662 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

929 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now