We needed to use a bulk insert activity to a database for data loading
The database has some conditions to load data:
• The database consists of 8 columns and we only need to process data for 5 columns.
o x column datetime format and filled by us
o y column string format and filled by us
o z column string format and filled by us
o u column string format and filled by us
o v column decimal format and filled by us
• 3 columns that we do not enter data are filled by default.
o ID column Int64 format and default fill
o t column datetime format and default fill
o w column string format and default fill
These columns are left blank.
We created a built data table to use bulk insert activity. We filled the data requested from us into the datatable.(Img_1)
Img _1 (red-framed data will be filled by default. These columns are left blank.)
We used bulk insert activity to insert the generated data(Img_2)
We got this error while running.(Img_3)
Img_2
Img_3
We assigned the value for the column in the error message on the built data table and we encountered a red-framed warning.
Img_4
Same error message repeated.
If anyone encountered this problem as well here is the workaround;
The add data row activity can be used for data that cannot be assigned on the built data table activity. (Img_5)
In this way, the “datetime.now” value that we want to enter into the data table is processed without any problems.
Img_5
Add Data Row Activities-ArrayRow Input: