1. Have the SQL task store the server name of the principle in a variable

2. Set up a OLEDB connection to the current principle database. Rename this to Principle....

could you run a trace in profiler to make sure the code being called is exactly the same?

tom

you can do this by either adding the variables to the "ReadOnlyVariables" property on the Script tab and then you can access them using the dts object:

[font="Courier New"]Dts.Variables("variable name").Value[/font] ...

you could use a foreach loop to loop through the folder, get the filename for each file, then use a script task to check for the Last Update date. ...

use a file system task set to "Create Directory" and UseDirectoryIfExists set to true. Have one for the year and one for the day.

Tom

If the destination is on your network, you can use the file system task to move the file.

I think if you rename the file and include the destination UNC filepath...

Have a look here for a possible solution

SSIS: Using Temporary Tables

Ah, I see. I misread your first post.

So, what you are trying to do is run one data flow task for two sets of tables that have differing metadata....

i haven't been able to find a way to change the scope after a variable has been created, and such am forced to delete the incorrectly-scoped variable and recreate it,...

i think when you set the strSQL variable you should include the "SELECT " before the rest of the statement.

also, you don't need script tasks to change variable values; you...

can you not keep it as unicode all the way through to oracle?

i don't think so; i just used the xml source straight out of the box.

what happened when you used the files i included?

tom

which code page are you using for your conversion?

tom

from MSDN:

As your company and customer...

is the text in the source column held as unicode?

tom