Hi i am very new to ssis....i need your help please help me out Information: I do have txt file(source),count 8900 rows of data ,20-header n trailer adi ragged right record My requirement is Write an SSIS package SSIS is essenstially the wrapper to validate the file, call bcp, then report any errors back to the front end ??????. ((((I need to write a script task i guess..)))) Validations that SSIS will do: Verify file exists.????? Validate file size is > 0.???? Call bcp and return any errors back.???? Line count compare stage tables with flat files.????? These are the steps i need to do can you guys help me out ,suggest me Please

That sounds like a homework? (Because of the requets to use bcp in SSIS) Yes, you have to write a SScript Task. The file valdations you cann do with Scripting.FileObjects. Here are some examples: http://www.eggheadcafe.com/software/aspnet/30817947/script-task--scriptingfilesystemobject.aspx But for the import I suggest the use of SSIS itself, there you have all options for Errorhandling.