Hi All,

I Used

Execute SQL Task

in that is wrote select stmt to select the required Tally Erp 9.0 tables which are needed to load into Sqlserver and put them in one variable

Select $Name from ODBCTables (When i executed this query i get all the tables names which are required)

FOREACH LOOP

I Used ADO.NET Enumerate and created another variable

DataflowTask

In that i used ADO.NET SOURCE AND OLEDB destination

but when i select the variable in ADO.NET It gives error.

HOW DO I Configure the ADO.NET SOURCE and OLEDB destination for dynamic creation of tables in sql server through loop from TALLY ERP9.0.

Please provide help.

I believe the ADO recordtype (source) is incompatible with Tally ERP underlined database

in  data flow   have one properties the name  expressions

and click it. it has "ado net source " and sql command  write 

"select * from table where id = "+(@User::name)

Hi Ramyakranthi,

I agree with Arthur, you can also refer to the following thread:
http://social.msdn.microsoft.com/Forums/en-US/f7609acb-c864-447a-a389-e8add1514171/easiest-way-to-export-data-from-tally-erp-90-in-sql-server

Regards,