jagadeeshb (12/10/2009)
Hi,Here actually i am getting the data from script and by using conditional split i want to verify the excact data with tab delimited and save those data into seperate file. If any data not having tab delimited then save those data into another file.
So can you suggest me how can i do this.
Thanks,
Jags
[font="Comic Sans MS"]
You can use native SSIS capability to do this very easily. Use a flat file source system to point to your source file. While defining the connection manager - column tab - mention that the column delimeter is tab{t} from drop-down.
If you have a fairly correct formatted source file - you should be able to see the preview.
Now right click on the flatfile source component - to go to advance editor - go to 'Input & Output properties' and configure flatfile source error output...
You can redirect 'bad' rows to the output and good rows to another output.
See the following for more help:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=101225
(this should resolve your requirement)
Fore more :
http://www.sqlservercentral.com/Forums/Topic666292-148-1.aspx
Let me know how it goes..
[/font]
[font="Comic Sans MS"]--
Sabya[/font]