SQL Server Performance

Need help getting started

Discussion in 'SQL Server 2005 Integration Services' started by ghines57, Apr 6, 2007.

  1. ghines57 New Member

    Hi,
    I'm starting to understand SSIS a little bit. There's a lot to put together and understand all at once. I'm hoping that someone could help me with a little project I need to get done quickly. I'm just looking for an overview of what tasks I should use and maybe a short description of the flow.
    The file(s) I will be processing and loading to a staging table are all in a single directory, and I know how to loop through the files processing each one. Each file is pipe delimited and has a header and a trailer. The header has the date for the records in the file, and each record has the date as the first field. I'd like to store the date as a variable and then check it against each record (not sure how to do this). The trailer has a count of the records (excluding header and trailer), so I'd also like to verify that all the records are there before loading to the staging table.
    I'd appreciate it if someone could give me a quick overview of how to get started on this, and hopefully I'll be able to take it from there. Thanks for any help!
  2. satya Moderator

  3. MohammedU New Member

    Check the following also...
    https://www.microsoftelearning.com/default.aspx?SID=S-1-10-1-1650546472-2239431680&fName=Mohammed&ValidEmail=True
    http://www.sqlis.com/


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page