• snoqualmiewa (5/16/2015)


    Hi,

    The insert statement in page 294 fails (SQL Server 2014 Integration Services text by Brian Knight). Any Ideas what data should be entered for the PACKAGE ID? Thanks

    INSERT INTO SSIS SETTING

    SELECT '{INSERT YOUR PACKAGE ID HERE}', 'LOGFILEPATH', 'c:\myLogFile.txt'

    Error message thrown - Msg 8169, Level 16, State 2, Line 1

    Conversion failed when converting from a character string to uniqueidentifier.

    Cross-post, answer to this thread.

    😎