SSIS - Export multiple SQL Server tables to multiple text files -

I have to move data between two SQL Server DBS Export my work data as text (.dat) files Have to move files and import them into the destination. I have to migrate more than 200 tables.

This is what I tried

1) I had executed SQL functions to bring my tables. 2) Each loop is used to loop through table names from the collection. 3) To create a text file destination path, use a script function for each loop. 4) For the source Oli DB, the name of the path in a variable for a DFT and destination flat file with the table name in a variable is called.

The first table removes properly, but the second table with a synchronization error is the bomb. I think that this is a number of posts, but no one can match me in my scenario. So posting here.

Even if I get the package to work with several DFT, then the second DFT table does not export to the columns because the flat file connection manager still remembers the first table column is. Is there any way to forget the column?

Any ideas how can I export multiple tables to use a DFT using the dynamic source and destination variable to multiple text files?

Thanks and appreciate your help.

Unfortunately bulk import work is only able to use format files to map columns source and Bulk import work bulk among destination uses INSERT TSQL, to execute the user to import data, BulkMine Server must have privilege.

Most companies did not allow bulkman server privileges to be enabled for security reasons. Therefore, using script work to create BPP details is a good and easy choice for export. You do not need to create a .bat file in the form of a script, which can execute the DOS command that runs under the .NET security account.