Thanks for the reply Tim,

i'm using sql 2005 server. i'm already breaking down the main transformation task to several subtasks. i could go down further but i dont think...

well basically my package is importing xml file using sqlxmlbulkload to the staging table in the database. then the next step is transforming the data in staging table to the...

yes each setup access its own local sql database.

i backup the database from remote server and restore on our local setup.