Topic: SSIS: the packet from does not work
Help to solve a problem please: there is a packet which of the text file copies given in the DB table.
At start from studio and from Integration Services Catalog/SSISDB the packet works.
But if a packet to launch from the job of service of SQL Server Agent writes an error: "Data conversion failed. The data conversion for column" budget "returned status value 2 and status text" The value could not be converted because of a potential loss of data. "."
The field type numeric (18,2), it without conversions goes at once in the field of the table of the same data type.