Hi,
after using Data Sources for many reasons, I wondered if it was possible to use it to insert data into an external database (MSSQL). Database was set up, and I used the following SQL to insert a single record into a table, and then read the same record back into a staging table, where it can be verified using a transform map script. It looks like it work fine. Does anyone know if this method could cause any problems, or is it safe to use?
The SQL statement I used is:
Insert into [DATABASE AND TABLE NAME] (field1, field2, field3, field4, field5, field6) VALUES ('Text1', 'Text2', 'Text3', 'Text4', 'Text5', 'Text6');
SELECT * FROM [DATABASE AND TABLE NAME]
