SSIS package sample

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?
toookiAsked:
Who is Participating?
 
Aaron ShiloChief Database ArchitectCommented:
any luck?
0
 
toookiAuthor Commented:
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
 
toookiAuthor Commented:
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
 
toookiAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.