Hi Friends, i am using this task to get a copy of some tables and sp to another databases... i deployed it and when i try to use the package utility and config file on some other machine...it is not supporting for the connection... how do i use the package on another machine? Help me friends... Thanks in advance

Since the issue description is quite vague I am shooting in the dark: that other box do9es not have the proper driver installed and/or configured.Arthur My Blog

Since the issue description is quite vague I am shooting in the dark: that other box do9es not have the proper driver installed and/or configured. Arthur My Blog hi, i want replication process in ssis... How can i achieve it?

The replication is implemented a one of the core features of the Database Engine and has various flavors. SSIS is somewhat equipped. I suggest you look at the following popular example: http://www.sqlis.com/sqlis/post/Get-all-from-Table-A-that-isnt-in-Table-B.aspxArthur My Blog

The replication is implemented a one of the core features of the Database Engine and has various flavors. SSIS is somewhat equipped. I suggest you look at the following popular example: http://www.sqlis.com/sqlis/post/Get-all-from-Table-A-that-isnt-in-Table-B.aspx Arthur My Blog Hi, yes i know....but the client side are not letting us to do replication through SQL management.....so i am supposed to do the process in ssis....like whatever the parent database is affected , it needs to affect on the child...so please suggest me some tips in ssis?

Adding details about the other end would help here e.g. what we are dealing there with, for now, I can tell you there are various things you can do e.g. CDC - http://msdn.microsoft.com/en-us/library/bb895315.aspx, Attunity has some Change Data Capture, if not mistaken now even for Oracle, so other then that generic method above this is all I can offer at this time.Arthur My Blog

Adding details about the other end would help here e.g. what we are dealing there with, for now, I can tell you there are various things you can do e.g. CDC - http://msdn.microsoft.com/en-us/library/bb895315.aspx, Attunity has some Change Data Capture, if not mistaken now even for Oracle, so other then that generic method above this is all I can offer at this time. Arthur My Blog Friend, client database are updated every day...we are using their exact database on our server like taking a back up and restoring it on our server every day and using it for testing purpose... so this needs to be automated ....automated is not a big deal....but doing it with SSIS is where i am stucking up....they want me to synchronize those two database every day through ssis....apart from that there is no specific thing to explain here....

Hi Prakash.R, Please refer to the following link about syncing databases between like servers using SSIS: http://underthefold.org/2010/01/03/ssis-syncing-databases-between-like-servers/ Thanks, Eileen