I am extracting very nasty file from our source. Before we used to run that file thru our C# sharp program and changed it to pipe delimited file. Then with then help of our in house ETL tool we load it to our staging table in SQL server.
NowÃÂ how to load that nastly file, then run C# sharpÃÂ and load into destination ( all in SSIS)?
Can weÃÂ call that C-sharp program from SSIS?
View Complete Post