Viewing MSDB Jobs From SSIS Get Error. -
04-28-2006
, 11:14 AM
Hi,
I used Export/Import tool to generate the SSIS package for copy table from
one db to another (both dbs in same machine) in SSMS, used SQL Server
Business Intelligence Development Studio added existing package under SSIS
Packages, and generate scheduling job to execute this package.
Actually I created 3 Export/Import packages, the previous two I used encrypt
sensitive data with user key while save the package, those two never success
when using schedule job to execute packages. The third package I used relies
on server storage and roles for access control, it’s succeeded.
When I try to view the MSDB jobs from SSIS in SQL Server 2005 EE (Windows
Server 2003 with 64 bit server), I got following error:
Failed to retrieve data for this request, (Microsoft.SqlServer.SmoEnum)
Additional information:
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
My questions are: Is this error related to previous two packages? If it's
related, how can I find and delete those two packages?
Regards!
-Chen |