March 29, 2012 at 5:07 am
Could someone please tell me what the Microsoft.SqlServer.PipelineXml.dll and how to register it?
I'm getting an error when running a package on all transformation task when running as a job stating that that DLL may not be properly registered.
Data Flow objects cannot be loaded. Check if Microsoft.SqlServer.PipelineXml.dll is properly registered.
End Error Error: 2012-03-28 14:26:05.74 Code: 0xC0010018 Source: Load cyp_Class_Table
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 29, 2012 at 5:51 am
If I execute the SSIS Packages using the DTExec as a CmdExec it does not load any transformation task.
If I run DTExec from the command line it works.
It only populates tables in which I had to replace the Transformation to an OpenQuery inside a Stored Procedure.
Same behavior as an Integrated Services Step from MSDB stored Package.
I was thinking about create a batch file that call DTExec but with my luck that will not work either.
Code: 0xC0040019 Source: Load cyp_Receivable_Activity Load cyp_Receivable_Activity (SSIS.Pipeline)
Description: Data Flow objects cannot be loaded. Check if Microsoft.SqlServer.PipelineXml.dll is properly registered.
End Error Error: 2012-03-29 07:42:15.19 Code: 0xC001001
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 29, 2012 at 6:42 am
It was a permissions issue on the Account used for the SQL Server Agent.
For the task that I had to use Stored Procedures with OpenQuery Statements it worked.
The majority of the tables were being populated from an AS400 using a Data Transformation task.
For now I used my account for the SQL Agent Service but I need to determine a more appropriate Account to use for this Service. It was set to Network Service which does not cut it.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply