sql crazy kid (1/12/2014)
Phil Parkin (1/12/2014)
Is there any way we can use ssis ?
To do what, precisely?
As you have given no examples of the data which is giving you problems, providing any sort of useful answer is close to impossible. How does SSIS fit into the architecture of your Unix environment?
Sample data looks like below, for 3rd row rowdelimiter is not correct.
|USD|1542.52|14536|xxxx
||1542.52|14536|
EUR|1542.52|14536|xxxx
I m not sure how does SSIS Fit into Unix, please advice me if SSIS fits into unix.
I can create an ksh scripts ,is ssis can be called from ksh ?
Sorry but I know very little about Unix. But I'm pretty sure that SSIS can be used to process and push data into a Unix database, assuming the connectivity can be resolved.
But SSIS needs to be installed on a Windows server - is that a show-stopper for you? It's also quite expensive to justify if you are not already using SQL Server.
Does your sample data represent two or three rows of actual data?
If three rows, it looks like the column delimiters (not row delimiters) are incorrectly placed. That's just bad data and it should be fixed at source, not by you - in my opinion.
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.