Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# SSIS
Hi,

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 17:12pm
leoabad274
Comments
Richard MacCutchan at 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
0 Sergey Alexandrovich Kryukov 370
1 OriginalGriff 195
2 Zoltán Zörgő 124
3 Dave Kreskowiak 120
4 DamithSL 115
0 OriginalGriff 7,610
1 DamithSL 5,559
2 Sergey Alexandrovich Kryukov 5,324
3 Maciej Los 4,961
4 Kornfeld Eliyahu Peter 4,539


Advertise | Privacy | Mobile
Web03 | 2.8.141223.1 | Last Updated 7 Nov 2012
Copyright © CodeProject, 1999-2014
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