Hi, I have a small SQL Server 2005 DB and it has 50 tables ( All tables have different Structure). Now I want to import the data of all tables into CSV. I can make a SSIS package for it but for this I have to make 50 FlatFile Connection Managers for mapping the data of Each table into CSV. Is there any way to do this into a single step.
I think Pavel is right. BCP with either sp_msforeachtable or else handwritten dynamic SQL is probably the best way to go. You could also have SSIS dynamically create the connections it needs instead of creating 50 connections manually.