Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to load a load a table from on-prem SQL server to Azure SQL Server(single instance) DB using bulk load. Source table is having 20 millions records. My job flow is tDBInput --> tMap --> tFileOutputDelimited --> tAzureStoragePut --> tDBRow. I have used bulk insert script inside the tDBRRow component.
BULK INSERT dim.table1
FROM 'bulkexecfiles/table1.txt'
WITH ( DATA_SOURCE = 'BlobStorageAccount',
FIRSTROW = 2,
FIELDTERMINATOR = ',',
ROWTERMINATOR = '0x0a',
KEEPIDENTITY
);
I have the below issues
Can anyone suggest how to process this data. Thanks in advance