what is the reason, why they can't co-exists?

It is doable to load multiple tables into files dynamically.

within ADO enumerator, use SQL task for BCP command:

declare @sqlStr varchar(2000)

set @sqlStr = 'BCP TESTDB.[dbo].[customer] IN B:\Users\Documents\SQL Server Management Studio\customer24072015.txt...

hi Grasshopper,

you actually remind something, it is working now. many thanks

thanks for the reply, it really helps.

hi,

hope you can get the message. Have you heard epex? i got the same problem as yours. having a problem with data extraction and this only applies to varchar...