loading flat file via SSIS

Question

loading flat file via SSIS

ron.nicholls

SSC Rookie

Points: 33
More actions
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.

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

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

ron.nicholls SSC Rookie Points: 33 More actions · Answer 1

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

narayanas119 Newbie Points: 4 More actions · Answer 2

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

ron.nicholls SSC Rookie Points: 33 More actions · Answer 3

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