October 8, 2010 at 9:57 am
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 Error
Description: 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.
October 8, 2010 at 11:16 am
What edition of SQL Server are you running on? (Express, Workgroup, Standard, Enterprise/Developer)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 8, 2010 at 11:26 am
Mh-397891 (10/8/2010)
Description: The connection type "SMTP" specified for connection manager "SMTP" is not recognized as a valid connection manager type.
Stripped it down to what I think is critical to the error. SMTP is email protocols. So, this thing wants to send an email. Is emailing setup on the server and is it setup for the SQLAgent's account?
Remember BIDS runs under your account until you ship/job it, so it's using a different outlook profile.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 8, 2010 at 12:24 pm
SQL Server 2008 Enterprise edition
October 8, 2010 at 1:05 pm
My best preference for e-mail is use the below query and set this as a job in execute t-sql maintainance plan tasks, so you have job logging and results to e-mail.
Note: you should configure dbmail first to use the following query
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'dbmail name'
, @recipients = 'e-mail'
, @body = 'This is result of query for daily report'
, @body_format = 'text'
, @query = 'Write your query here'
, @execute_query_database = 'your db name'
, @attach_query_result_as_file = 0
, @query_result_header = 1
, @query_result_width = 500
, @exclude_query_output = 0
, @append_query_error = 1
GO
I tried works fine, Good luck
In you scenario, I don't see any variables in ssis you mentioned,
becaused mail session to work in ssis check your variables in your package.
Hope, little helpful.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply