Need help getting started | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Need help getting started

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!
See the links : and Brian’s blog fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Check the following also…
Moderator All postings are provided “AS IS” with no warranties for accuracy.