pipe delimited file to SQL using DTS
Hello all,
I am rookie in DTS. I have a basic question. I actually need to input pipe delimited text file , convert it into table and then check the values of certain for validity(eg. the state cannot be more than 2 chars etc).
I read from some forums that this can be acheived faster by using DTS. But, I have certain concerns. Since, I am developing an application for this,I am using C#.Net. Is it compatible for the above purpose.
Also, Can anyone tell me a brief overview of the steps involved in the above task. I'd be grateful to you.
|
