Load odd column data to local file

Question

Is it possible to load odd column data from sql server table to flat file in ssis package?

Answer 1

Hi @Su Si,

When you create the source manager, you may use below command.

Select * from yourtable where (RowID % 2) = 1

If you do not have the RowID, you may use ROW_NUMBER().

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Create a view with only that columns you want to export.