I am trying to run a project that exports a table from Excel to a table in MSSQL. I am using the inbuilt table creation in the EasyMorph Export to Database Command transformation.
EasyMorph correctly identifies datatypes but, for text, the length of field is limited to 255 and there doesn’t seem to be a way around it within EasyMorph itself.
I have found a work around which is to create the table via EasyMorph, then go into SQL Server Management Studio, Switch to the tables design mode, and alter the length. I then go back into EasyMorph and set the behaviour to keep the table and delete the data.
We have many users now using EasyMorph - Not all of them have the ability to alter the tables in SSMS.
Is there a way of changing the text length from within EasyMorph?