extract text files using ssis
Hi, I'm praveen,I want to extract the flatfiles those are in the format of the rar files.Present i want to extract those files and load data into sql server while at the time of extracting flat files it gives an error message like "no archive found"
March 31st, 2011 7:01am

before extracting are you unzip the rar files? please see this thread to unzip files http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/1b6c5a12-1f0b-483e-8d25-8e3b365200f5 Then importing text files here is good sample http://decipherinfosys.wordpress.com/2008/07/28/ssis-importing-data-from-a-text-file-using-a-package/
Free Windows Admin Tool Kit Click here and download it now
March 31st, 2011 7:07am

The nicest way (personal opinion) is to use a Script Task (like this unzip example). Just look for an unrar library. But maybe someone already created a custom unrar task on codeplex. An other way is to use the Execute Process Task and call winrar from your package.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
March 31st, 2011 7:09am

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

Other recent topics Other recent topics