Recently we got a requirement of saving data from one server to another server . both server has SQL server 2012 . data will not be not that huge but we are expecting 10-12k records everyday.
This data will be transferred once in a day.
so after looking other options like creating a job in C# and sending data in xml as extarct or using big data and SSIS we have finalized SSIS . I am very new to SSIS dont know much about SSIS .
so i just started working with SSIS package so whatever will be the questions or learnings i will be posting.
meanwhile i would like to whether its a correct decision to use SSIS in this scenario ??
No comments:
Post a Comment