October 10, 2013 at 1:57 pm
Hi
What is the process to follow if we have to retrieve data to a tune of 50 million records from couple of different data sources[legacy and non SQL server] and store them into multiple csv files.
What is the process to go about ..any example?
Thanks
October 10, 2013 at 2:10 pm
You could use SSIS for this.
If you have an OLE DB or ODBC provider for your non-SQL Server sources, it should be no problem.
Make sure you have up-to-date providers.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 10, 2013 at 2:14 pm
Sounds like an SSIS job to me.
You may want to provide a little more information, such as whether or not this is a 1 time operation or a something to be performed regularly, and a few more details about your data source(s).
Good luck!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply