Hi everyone! If
SSIS has great advantages in terms of debugging by design, it nevertheless remains largely a tool for improvement on a number of points.
The first of these is probably the weakness of function libraries accessible in the data conversion tasks. Indeed, the conventional tests to identify the correct classification of the imported data in a Data Flow (ISDATE, ISNUMERIC, ...) can not be made otherwise than by Script Component task ... A long and often tedious task to develop, particularly if the number of fields to be tested is especially important. If
to this important gap solution to redevelop a specific component for SSIS comes immediately to mind, the reality of deployment on the client catches up to us inexorably. Indeed, it is necessary to deploy the said component impacted on all servers that can quickly be tricky ...
So I come here to propose an alternative solution, although not very satisfactory for which I am a perfectionist: the use of temporary tables !
While SSIS does not have adequate functions, the Transact-SQL can come to our rescue!
should therefore integrate the data source into a temporary table independent of data format - eg VARCHAR fields - then make the changes and integrity checks as part of a stored procedure ...
If this remains lackluster, it is really the only viable solution as SQL Server Integration Services will not offer a library of components and functions satifaisante ...
continued ...
0 comments:
Post a Comment