Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
When I'm loading data from tsapinput table to azure synapse(SSMS) data loading is very slow , can some one help me its little bit urgent.
Any suggestion on design and components will be highly recommended
Hello,
From your screenshot, here is a tMap component which will consume too much memory. For a large set of data, try to store the data on disk instead of memory on tMap and allocate more memory to execute the job. Let us know if it is OK with you.
Best regards
Sabrina
Hi ,
Really thanks for your replay , i am struck disparately need help i want to load my data into azure synapse(sql server) , data getting extraction fast but commit is happening very slow , bulk load not working
Hi, after removing tmap component , and try to ingest data commit inside the db happening very slow for tsqldwhoutput, so i tried to ingest data with tsqldwhbulk load but i am facing
make sure you have all the required access on both the system i.e. reading and writing