Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2010-10-08 : 12:37:32
|
| Environment: SQL server 2008.Here is the error I am getting when running the SQL jobs, this sql job basically runs the SSIS package. But if I run the package from BIDS it runs fine without any errors.Not sure where to look at to fix this error: Errors:Description: The log provider type "DTS.LogProviderTextFile.2" specified for log provider "SSIS log provider for Text files" is not recognized as a valid log provider type. This error occurs when an attempt is made to create a log provider for unknown log provider type. Verify the spelling in the log provider type name.Code: 0xC0010021 Source: Description: Element "{6FEBA179-AC40-417B-82A1-271FF62DD72E}" does not exist in collection "LogProviders". End Error Error: 2010-10-08 09:45:07.95 Code: 0xC004706E Source: PNEReadmit SSIS.Pipeline Description: The module containing "component "Aggregate" (1581)" cannot be located, even though it is registered. End ErrorDescription: The connection type "SMTP" specified for connection manager "SMTP" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name. End Error Error: 2010-10-08 10:43:26.60 Code: 0xC0010018 Source: Description: Error loading value "<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"> <DTS:Property DTS:Name="DelayValidation">0</DTS:Property> <DTS:Property DTS:Name="ObjectName">SMTP</DTS:Property> <DTS:Property DTS:Name="DTSID">{36f88722-2896-4988-9d47-966911353a81}</" from node "DTS:ConnectionManager". End Error Could not load package package1 because of error 0xC0010014. |
|
|
|
|
|
SSIS help!!