Migrate all tables named SC_% from Oracle to SQL Server.

[Anonymous]

Hi All,
My needs are to move about 130 Oracle tables named with "SC_" string, into SQL Server. Blank tables with equvalent datatypes are already created in SQL Server.

I was hoping to create a job using tOracleTableList component, use "CURRENT_TABLE" variable to and be able to use it for tOracleInput and tMSSQLOutput components.

Not sure if this would work, so wanted to take some advise as to how to achieve this task?

[Anonymous]

Hi
you are on a good way, but the tablename is not imporant at this position.
You need to build a dynamic query : "select * from " + YOURTABLENAME and place this in the toracleinput query box

the YOURTABLENAME must then be in you mssqloutput tablename box

and it shoukld work ( if you are in TIS and have dynamic row type)

HTH

[Anonymous]

djdeejay,
Thanks for reply.
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] I'm still a beginner and do not understand your suggestions.[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] 1) How would I supply the value for YOURTABLENAME in the dynamic query.[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] 2) Is YOURTABLENAME a variable, if yes, then how do I set it using the properties tab?[/font][/color]


[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] Please guide.[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] Thanks,[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] DP.[/font][/color]

[Anonymous]

CURRENT_TABLE might be YOURTABLENAME, but if you have some more time, wait for me, then i come over and do the job for you