I want to add a new column in my dataset while working in SQL Data Flow . Can I use ALTER TABLE command ?
yes.
just use standard MySQL 5.6 syntax.