This brings me back to the Insert activity but with the connection configured. The data I am trying to insert into the table is a tab delimited .txt file on my computer. How do I insert that into the activity?
Fine
Usually INSERT activity takes in datatable as input
—as we have txt file with tab delimited use
READ TEXT FILE ACTIVITY and pass the file path of that txt file as input and get the output with a variable of type string named str_output
—now use a GENERATE DATATABLE ACTIVITY and pass the variable str_output and get the output variable of type datatable named dt
—now mention this dt variable as input in INSERT activity
Cheers @hall1570
I don’t understand why i’m getting this error because I configured my column headers in SQL server to match my TAB file column headers. Below I am attaching a screenshot of my column headers and data types.