I have copied data from Excel sheets to the multiple tables of a SQL server. I want to copy data from these tables of one SQL server database to another database. How do I do that? Note: Since it is a complete refresh I need to delete data from the destination database before copying the data. Please tell me how do I go about this two tasks?
Re: Copy data from one SQL server database to another
Hi Yuvraj, That "another database" is same sql server or another? If it is different you can do in following way - tSQLServerInput-->main-->tyourdatabaseoutput (use truncate and load option if you want to remove all earlier data before loading) - If the database is same, you can also think of using SQLRow component and use database copy command sql
Whether you are facing any problem in doing this? Vaibhav