Hello,

New to VC, I am trying to load the data from sql to mysql. I have a SQL Job that i am trying to move to VC.

The commands are
EXEC('TRUNCATE TABLE details;') AT Linked_Server_Name
EXEC('LOAD DATA LOCAL INFILE ''' + @DataFile1 + ''' INTO TABLE details FIELDS TERMINATED BY ''\t'' ENCLOSED BY ''^'' LINES TERMINATED BY ''\r\n'';') AT Linked_Server_Name

I get error messages
Msg 102, Level 15, State 1, Procedure , Line 1
Incorrect syntax near 'TRUNCATE TABLE details;'.
Exception in Task: Incorrect syntax near 'TRUNCATE TABLE details;'.

How can i go about truncating the table in mysql and dumping the data from sql to mysql?

Thanks
SH

You should not use EXEC - just the command itself like:

TRUNCATE TABLE details

---