I have this column in sql server that has value of "dog,cat,mouse" so I want to fetch this data into SSIS then transform it into an array using script so I can loop through it but I'm having an error when doing so.
var columnfromDB = "1,2,3"; // Need population so that Split won't throw an error
if (Row.Animals != null)
columnfromDB = Row.Animals; // This is where the error comes from since Row.Animal is a BlobColumn
string splittedString = columnfromDB.Split(',');
Any tips on how to solve this?