Click here to Skip to main content
12,952,159 members (57,154 online)
Rate this:
Please Sign up or sign in to vote.
See more:

i am very new to SSIS. and i was wondering if anyone could help me with this.

I have an SSIS Package that insert excel files to the MS SQL Database. Inside the foreach loop, i have a Data Flow Task which manages the inserting of excel. What i want is before i upload my excel file, (before going through the data flow task) i want to validate the excel file if its has any empty cell. If yes, it will proceed to the data flow. if not, it must notify the user via email and/or move the excel file in some other folder. This validation i want to do inside a Script Task. I am using C#.
Posted 7-Nov-12 16:12pm
Richard MacCutchan 8-Nov-12 5:04am
Please do not repost the same question more than once. If you have additional information then edit your question and add there. I have deleted your duplicate of this post.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,239
CHill60 3,490
Maciej Los 3,083
Jochen Arndt 1,975
ppolymorphe 1,880

Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 7 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100