https://community.qlik.com/t5/Talend-Studio/Drop-and-Create-tables-in-MS-SQL-Server-database/m-p/2205067#M5680 Try upgrading to a more recent version of Talend! Fri, 07 Jan 2011 04:03:21 GMT _AnonymousUser 2011-01-07T04:03:21Z https://community.qlik.com/t5/Talend-Studio/Drop-and-Create-tables-in-MS-SQL-Server-database/m-p/2205066#M5679 Hi All, <BR />I've got an issue with a Talend job that writes data to a MS SQL Server 2008 R2 database. (I'm running TOS 3.2.0 on Win XP) <BR />The job works fine until I change the Action on table to 'Drop table if exists and create' for the target table. The job will start and run but when it tries to write the data via the output link, the job will just sit there and do nothing. It does not return any errors. <BR />If I run the drop and recreate from SQL Managment studio directly it works fine, so I don't think it is a permission issue. I login via Windows Authentication in Managment Studio and in Talend the username and password fields are blank which I assume means that Talend also uses Windows Authentication. <BR />I'm grateful for any suggestion from the forum members as to what I can try to solve this issue. Sat, 16 Nov 2024 13:09:27 GMT https://community.qlik.com/t5/Talend-Studio/Drop-and-Create-tables-in-MS-SQL-Server-database/m-p/2205066#M5679 _AnonymousUser 2024-11-16T13:09:27Z https://community.qlik.com/t5/Talend-Studio/Drop-and-Create-tables-in-MS-SQL-Server-database/m-p/2205067#M5680 Try upgrading to a more recent version of Talend! Fri, 07 Jan 2011 04:03:21 GMT https://community.qlik.com/t5/Talend-Studio/Drop-and-Create-tables-in-MS-SQL-Server-database/m-p/2205067#M5680 _AnonymousUser 2011-01-07T04:03:21Z