Hi, i have requirment to export multiple files using tpt as below. For example i have employee table
Emp id 1 to 10 -- load to file 1
Emp id 11 to 20 -- load to file 2
Emp id 21 to 30 -- load to file 3
Like this have 20 categories of emp id.
My script working for one file with one sql.
How can i achieve this in same tpt?. Also is there a way to parameterize the sql?
Please help
Emp id 1 to 10 -- load to file 1
Emp id 11 to 20 -- load to file 2
Emp id 21 to 30 -- load to file 3
Like this have 20 categories of emp id.
My script working for one file with one sql.
How can i achieve this in same tpt?. Also is there a way to parameterize the sql?
Please help