Link to home
Create AccountLog in
Avatar of toooki
toooki

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of Aaron Shilo
Aaron Shilo
Flag of Israel image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
any luck?
Avatar of toooki
toooki

ASKER

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.
 User generated imageHere 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.
Avatar of toooki

ASKER

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?
Avatar of toooki

ASKER

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?