Need help loading massive data tables from one SQL server to Teradata

Help Studio
, ,
1

Hi All,

I am trying to load a pretty big data table (87,000 rows) from SQL server to Teradata. I used select statement to get the data table onto UiPath, but how do I now load it into Teradata? I tried using bulk insert database activity, but it keeps on throwing an error saying I do not have the correct driver for it. Unfortunately, I do not have access to any other drivers as this is what my company has provided.

2

RPA probably isn’t the best way to migrate a large amount of data from one database to another. Seems like Teradata would have ways to directly load the data. I know you can do it from a file.