Incomplete transformation for Bulk Insert
This EWI is added when a
BULK INSERTinside a stored procedure was not identified at all, so the dependencies for the complete transformation will not be generated. Also the transformed
COPY INTOretrieves the file from a
tempStagethat needs to be created manually.
CREATE PROCEDURE BULK_PROC2
BULK INSERT dbo.table1 FROM 'E:\test.txt'
CREATE OR REPLACE PROCEDURE BULK_PROC2 ()
EXECUTE AS CALLER
// REGION SnowConvert Helpers Code
// END REGION
EXEC(`/*** MSC-WARNING - MSCEWI4024 - THE CURRENT BULK INSERT WAS NOT IDENTIFIED BY SNOWCONVERT, DEFAULT TRANSFORMATION TO COPY INTO WAS ADDED BUT WITHOUT ITS DEPENDENCIES ***/
COPY INTO dbo.table1 FROM @tempStage/test.txt`);
- For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.