SSIS:source and destination is sql server
hi this question i asked priviously i didnt gt currect explanatipon acctually i want to Develop SSIS project with i have sorce is sql server database ,so for this what i have to do? 1)For creation of ssis porject to extract the data from sorce to destination want staging are not? 2)can i create for every table as one pakage 3)are any task is there to dump with data from one server(database) to another server(database) in the sence stagging datadase plese help how to start i am only one doing this project littile confusinng i now dnt now to do this way prashanth
October 18th, 2011 2:43am

1)For creation of ssis porject to extract the data from sorce to destination want staging are not? If your source is DB then need not to create any staging table.Directly you can map source with destination table. 2)can i create for every table as one pakage if you have to simply dump data from source to destination for all tables you can do in one package . 3)are any task is there to dump with data from one server(database) to another server(database) in the sence stagging datadase You need Data Flow Task for it inside data flow task Ole DB source to select source data and Ole DB Destination to dump data into destination table. hope it make sense for you.Shailesh, Please mark the post as answered if it answers your question.
Free Windows Admin Tool Kit Click here and download it now
October 18th, 2011 2:51am

Hi Prashant , I understand your project requirements . 1)For creation of ssis porject to extract the data from sorce to destination want staging are not? A: Source and destination servers should be in same domain , and not required for staging server or database 2)can i create for every table as one pakage A: Do you want all objects from source database to destination database , if yes you can select the database objects and transfer to destination server . You can directly use data flow taks for the operation . 3)are any task is there to dump with data from one server(database) to another server(database) in the sence stagging datadase A: use connection manager for the operation to select the server and databse . use Data Flow task for the transferring data from source to destination . Note: Its straight forward request ( you need to dump all objects from source database to destination ) Please find the link for creating simple etl package . http://msdn.microsoft.com/en-us/library/ms169917.aspx Hope above information will help you..let me know the updates ... Please prose as Answer if it anwers your query. Many Thanks Karna I prefer you to create a simple SQL job to take the source database backup and then use the backup to restore the destination DB. 3)are any task is there to dump with data from one server(database) to another server(database) in the sence stagging datadase
October 18th, 2011 3:19am

But I have 4 production servers are there .How can i dump the data from all 4 production server. if 4 prod server is there means require stagging are not prashanth
Free Windows Admin Tool Kit Click here and download it now
October 18th, 2011 3:54am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics