May 25, 2009 at 11:51 am
Hello,
I newbee in SSIS.
I try to make a SSIS Package to import data from flat file and validate the data.
I was seeking examples, and I found several but none where validate the data.
I was trying to do the same like SQL 2000 into DTS.
Into Lookups I defined several queries one to validate if data exists, one to log and one to update.
Into de Transformation I defined a Script and write the logic to call the lookups.
into SSIS I dont know what items of toolbox use, well, I know the basics to import the file
but i dont know how to validate the data, I see the lookups but I cant introduce the queries, I dont know if use Script Task or Script Component and I dont know how to link de shapes.
Thanks in advanced.
May 26, 2009 at 10:49 am
Hi,
Lookups are meant for looking up and returning data from a database table. Validation is up to the package creator since he/she would know what data needs to be validated and the criteria for that validation. that being said, it sounds like you may have to use a script component in your data flow task and write a custom validation procedure using VB.NET or C# (VB and C# availible in version 2008). Hope that helps!
Thanks,
Strick
May 27, 2009 at 3:20 am
If you are new to SSIS the question is if you will do more than just import flat files else I would
recommend you to use bulkinsert instaed . Look in BOL for examples.
The dataevaluation can (hopefully) be done with SQL-statement,procedures etc.
/Gosta
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply