Hi All, I have a SSIS Package that is already working when I execute it using BID and DTExecUI utility it its local server where I created the package. But when i tried to exec the package in my local terminal the exact command are below. dtexec /sq DTS_Package /ser Server /U username /P password /l "DTS.LogProviderTextFile;"D:MSSQL.1error.log" Can anyone help me with this??? Here is the error that it returned: Started: 8:10:14 PM Error: 2008-09-01 20:10:17.06 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTSassword" with error 0 x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic err or. Verify that the correct key is available. End Error Error: 2008-09-01 20:10:19.17 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTSassword" with error 0 x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic err or. Verify that the correct key is available. End Error Progress: 2008-09-01 20:10:19.75 Source: Data Flow Task Validating: 0% complete End Progress Thanks and Regards, JHOY
Check your package property called "ProtectionLevel". What is it set to? And save the package to sql server with protection level setting to be relying on sql server roles.
Hello Satya, Sorry I am not so familiar with SSIS.. Where can I set "Protection level for the Package"??? Thanks and Regards, JHOY[quote user="satya"] Check your package property called "ProtectionLevel". What is it set to? And save the package to sql server with protection level setting to be relying on sql server roles. [/quote]
Hi Satya, I am able to change protection level of the package.. but i still got the ff error: The product level is insufficient for component "Flat File Source
Looks like SSIS itself is not installed on machine. There are some components that will be installed only if you are installing SSIS in your installation.