In my previous post, I tried to show how to install Enterprise Manager Cloud Control 12c, now I’ll show how to add target hosts to our Enterprise Manager system.
Xp_cmdshell has primarily been a system administration extended stored procedure.Post ID=112469&Site ID=1It sounds like either you haven't installed SP1, you don't have SSIS installed and generated the code through the import/export wizard in Management Studio, or it's a bug that I don't know much about (well, even less than I gleaned by poking around via google). Did you run the Import/Export wizard from your local machine, against a SQL Server Enterprise Edition SP3 server, or you're ON the server importing from there and to there?Hope this helps, Rick Todd OK, I read through the thread on that URL I posted earlier. Rick Todd @ rick I am on remote server with sql server 2005 sp3 installed on it... OLEDB.4.0" for linked server "(null)" indicates that either the object has no columns or the current user does not have permissions on that object.(SQL Server Import and Export Wizard) Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (91).(SQL Server Import and Export Wizard) Apparently this is a bug, according to this: Post.aspx?In the Normal View of the request resource in the FIM Portal, the Request Status Detail attribute is named Request Workflow Remarks.