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