locked
How to read a Raw File RRS feed

  • Question

  • Hello,

    I have Package with ABC.raw file as source.A varaible is create to say where exactly that ABC.raw is located.In that package I can open that source and see there are 20 columns and I am not sure where they are coming from.

    Now I want to open that ABC.raw  in its location ,where it is stored and I am unable to open and see exactly what mapping has been to get the columns which are used as source in my package.

    How to open that ABC.raw file

    Can someone help me with this.

    Thanks

    Tuesday, June 7, 2011 4:21 PM

Answers

  • The RAW file format is proprietary to SSIS. you can ONLY open it from inside an SSIS Package. The only REAL way to view the contents is to put in a Data Viewer in the pipeline. There is no Preview button like you have with other Source Connections.

    Where did this RAW file come from? Must have been some other SSIS package that created it using a RAW File Destination and naming it "ABC.raw"!


    Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
    • Proposed as answer by Mr. Wharty Wednesday, June 8, 2011 3:29 AM
    • Marked as answer by Tony Chain Wednesday, June 15, 2011 5:41 AM
    Tuesday, June 7, 2011 8:21 PM