I have a requirement to connect to remote server and download CAB files to local server. Need to extract the CAB files which contains a CSV file and write the contents to the database table. Sql Server 2005.
What are the best possible solutions for this?
1. Do we need to write code in .NET and call the dll in sql?
2. Write a CLR function for this task?
3. Is there a way to have pure tsql commands to get this done?