After modifying the default Data Types in an ETL source, my modifications are lost the next time I open the Source component
If
you need to modify the data types or lengths for any source columns or fields, use the
Advanced editor for the component and only make changes to the Output columns.
Do not make changes to the External columns. If you make changes to both the
External and the Output columns, the changes will be lost the next time you
open the editor for the source component.
If done correctly, you will be able to use the “Refresh” button to see any new columns or fields and your previous changes to other columns will remain intact.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
How to trace HTTP(S) and REST API using Fiddler
Fiddler can help you troubleshoot HTTP(S) / REST API / SOAP Web requests very easily. Fiddler is a web debugging proxy that logs all HTTP(s) traffic between your client machine and a server. It allows you to inspect the HTTP requests and responses ...Error Message: The connection type "xxxx" specified for connection manager "xxxx" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
Action: When I try to deploy my SSIS package from the SSISDB catalog, I get the following error: Error Message: The connection type "xxxx" specified for connection manager "xxxx" is not recognized as a valid connection manager type. This error is ...Where can I find the documentation for the SAS Data Source?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the SAS Data Source can be found at the following link. For many of the components you can find resources ...Where can I find the documentation for the Dynamics GP Source?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Dynamics GP Source can be found at the following link. For many of the components you can find ...Where can I find the documentation for the Dynamics NAV Source?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Dynamics NAV Source can be found at the following link. For many of the components you can find ...