July 7, 2011 at 7:57 am
How do i validate a text file using SSIS.I also need to check the data types of my Source file and my destination
July 7, 2011 at 8:25 am
You'll have to define what you mean by 'validate' please.
Text file columns do not have data types. If your destination is SQL Server, the data types are pre-defined and therefore do not need to be checked. Please elaborate.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 7, 2011 at 10:16 am
Validation: I want to actually check whether the *.txt file is actually a text file(because in some cases a user may send an excel file as a *.txt file)
July 7, 2011 at 10:22 am
Maybe the best way of doing that is reading line one of the file and looking for field headings that you know should be there if the file is valid ... I'd do that in a script task.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply