Using ODBC Source to read data from Hadoop and insert them in OLE DB destination. Performing conversion operations on various columns using derived column on various column. I have Column "POPric...

I am trying to modify my SSIS package to accept both CRLF and LF row terminated files. I have come across the suggestion to use a derived column where the you REPLACE(ColumnName,"\r","&...

The initial dataset I am working with is a list of tarnatula prices overtime from two shops, one based in Canada and the other in Poland. In order to make a fair comparison between the two shops, I wa...

I'm writing an SSIS package to load data from a .csv into a db. There's a column in the csv file that is supposed to have a count, but the records sometimes have text, so I can't just load the data in...