SSIS when we need to use raw file source ?
SSIS when we need to use raw file source ? in what situation we need to go for it?
July 2nd, 2011 11:00am
Hi,
Please go through the below link for details of RAW files. Please post questions in appropriate forums, so that you can get better help.
http://www.sqlservercentral.com/blogs/stratesql/archive/2011/1/1/31-days-of-ssis-_1320_-raw-files-are-awesome-_2800_1_2F00_31_2900_.aspxMSBI Developer
Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2011 11:50am
Have a read of the following
http://www.bimonkey.com/2009/04/the-raw-file-source-and-destination/Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID:
Microsoft Transcript
Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
July 2nd, 2011 10:06pm
you can pass data from one data flow task to another with RAW files which has good performance, they can be good place for staging.
in addition to BIMonkey's article which is referenced in Jeff's post, this is articles about Raw files in SSIS:
http://sqlserverpedia.com/blog/sql-server-2005/31-days-of-ssis-%E2%80%93-raw-files-are-awesome-131/http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
July 3rd, 2011 2:25am