Solved

SSIS package sample

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

743 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

10 Experts available now in Live!

Get 1:1 Help Now