May 16, 2015 at 12:24 pm
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.
May 16, 2015 at 1:14 pm
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.
Quick question, did you insert the package id (GUID) into the statement?
😎
May 16, 2015 at 2:53 pm
No not yet. I have been randomly entering package ID's which didn't work? How do I identify a SSIS Package Id on Sql Server? Thanks
May 16, 2015 at 4:06 pm
snoqualmiewa (5/16/2015)
No not yet. I have been randomly entering package ID's which didn't work? How do I identify a SSIS Package Id on Sql Server? Thanks
Suggest you start by reading this article
😎
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply