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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply