Hi, I have an excel file source, on which i have to perform a transpose operation (i was planning to do in VBA macro). This transposed file will be the source for other tasks in the control flow. My question is, can we invoke VBA from SSIS? Thanks.

You could manipulate on the Excel object from within a Script task. This is not typical though, I have a better solution for you: http://blogs.msdn.com/b/philoj/archive/2007/11/10/transposing-rows-and-columns-in-sql-server-integration-services.aspx This is an article that uses Unpivot transformation transformation that is IMHO more appropriate.Arthur My Blog