One Star Ben
One Star

drop table before inputdelimited upload

I am runnnig TOS 1.1.2.r2022 and would like to know how to drop a mysql table prior to reading in from a txt file. my input is a tFileInputDelimited and my output tMysqlOutputBulk, i know that in the newest release that there is an option to drop a table within the tMysqlOuputBulk properties but i cannot use this version as it hangs on me when i try to define a delimted schema (the wizard hangs previewing the txt file).
Any ideas?
Ben
1 REPLY
Employee

Re: drop table before inputdelimited upload

Simply add a tDBSQLRow with a "DROP TABLE XXX" and a RunBefore Link to your tFileInputDelimited