Post reply

loading flat file via SSIS

  • November 30, 2010 at 4:17 am

    #241759

    I try to execute an SSIS package that essentially loads a flat file into a new SQL Server database. How difficult can that be? Anyway, I get an error at execution stage that simply says “Unexpected Unrecoverable Error”. Nothing else, and it doesn’t matter what I do, it aborts the process. I can see the database and the table has created OK via SQL server management studio, and can even INSERT INTO.

    I know it’s a bit of a long shot given the error, but perhaps someone might have some general idea’s that I could look into.

  • November 30, 2010 at 9:11 am

    #1256850

    Thanks. Am a bit new to SQL server. Could you please give me a couple of pointers to these (I don't even know where to look, or what they mean)

    > The security model used by the SSIS package to access the database

    > The SSIS package security level (Do not sae sensitive, etc....)

    thanks

  • November 30, 2010 at 9:48 am

    #1256867

    when ever use ssis package load flatfilesource u check the duplicates flies there in that data u check it.Incase duplicate data u try to Aggregate Transformation In that operation Group By option When Ever Use The Group By Option Flat file Duplicates deleted

    (or)

    Use HashkeyAlgorithm Also Delete The Duplicates Delete

    And Providing Transformations

    In case u take ImportColumn And move the data SqlServer DataBase

  • December 1, 2010 at 7:19 am

    #1257341

    Thanks you. Good steer with web sites. Still not sorted but good places to look

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply