MS SQL Server data source to MS SQL Server target possible?

I'm attempting a transformation in AETLE, where I need to move data from one MS SQL Server database (Server A) to a different MS SQL Server database (Server B ). My data source on Server A is a view; going to a table on Server B.

When I try this in AETLE, it appears that the data from the view aren't parsing, so all data values for the many fields are trying to be written to the same field on Server B.

Do you know why this would be? Do I have to write these data to a text file as an in-between step?

Thanks!

'When I try this in AETLE, it appears that the data from the view aren't parsing'

What does it mean?

Please read the forum rules and follow them

Sorry about that! I'm using a Transformation in AETLE version 6.3.7.18. Both servers I'm copying data from and to are SQL Server v14.

I've setup my transformation, checked the Validator and Transformer (all good) and Reader and Writer are both set, with the correct connections. But when I try to run the transformation I get the following error (attachment):



You can see the row of data highlighted in the background. Then in the error box (Line 25), all of those data have not been parsed, and the transformation is trying to write all of those fields into the integer field on my target database.

Again, the source is a view on Server A; and the target is a table on Server B.

The message you are seeing on the screen is the message from SQL server BCP interface.
The message is a dump or the entire row our software is trying to insert.
It does not mean that the software is trying to update one single field with this data.

The message complains about column 19
Find this filed in the table and check the data you are trying to insert
Most likely it is too big for this field

That was it! School-boy error! Thanks very much!