July 5, 2010 at 11:26 pm
I'm looking to create a more advanced IMPORT process from Excel to SQL Tables.
I want to enhance the validation checking of each column/row of excel data before i use my Split Task to INSERT validated rows or reject and log invalid rows of data.
I am thinking a Script Task is probably the only way i can accomplish this to validate each row within a loop using code validations on each column of data.
My column data types in each row of data will vary across:
- Date Fields (formatted dd/mm/yyyy)
- Integer checking
- Currency checking
- Text String only
- plus maybe some more advanced Regular Expressions (eg. email addresses)
Can anyone help me or point me in the direction of some sample code or suggest a better solution.
July 5, 2010 at 11:35 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic947698-148-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply