Hola chicos!!!
Estoy empezando a ver sobre la opcion que maneja el RS de envio de emails...podrian apoyarme con un manual o indicandome como o que configurar para que esto fuciones pliz!... o es con el manejo del Sql , crear un procedure y programar una tarea que se ejecute cada cierto tiempo para que se ejecute el proc ????
Gracias!
Karla Ramos
I have the following code: Imports System
Imports System.Data.SqlClient
Namespace TestWeb
Partial Class araging
Inherits System.Web.UI.Page
Private _dt As DataTable
Private _connstr As String
#Region " Web Form Designer Generated Code "
'This call is required by the Web Form Designer.
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
End Sub
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub
#End Region
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim _connstr As New SqlConnection(ConfigurationManager.ConnectionStrings("ESQLConn").ConnectionString)
Dim sqlCommand As SqlCommand = New SqlCommand("csp_rpt_ack_form", _connstr)
sqlCommand.CommandType = CommandType.StoredProcedure
Dim objaDapter As New SqlDataAdapter(sqlCommand)
objaDapter.SelectCommand.Parameters("@v_order_doc_no").Value = 272
Dim ds As New DataSet
objaDapter.Fill(ds)
mainGrid.DataSource = ds
mainGrid.DataBind()
Response.Write(_connstr)
End Sub
End Class
End Namespace
I am trying to pass a value to the parameter that it contains. What Im I doing wrong? I keep on getting the following message."An SqlParameter with ParameterName '@v_order_doc_no' is not contained by this SqlParameterCollection." Thanks guys!
Hi.
I am working on a procedure which can filter data through three tables.
First Table is User
---------------------------
UserName UserID
---------------------------
Second Table is Customer
---------------------------
UserID Cust_Site_Int_ID
---------------------------
Third Table is l Details
---------------------------------------------------------------
Cust_Site_Int_ID Created_Date Status
----------------------------------------------------------------
I want to create a stored procedure which can filter through these tables. I will have four input fields in my application to accept parameters. The four parameters will be UserName, two date fields which specifies a range of dates and status. I want the filter to work like this, if only one parameter is provided it will use only that parameter if additional parameter is given it will use the AND logic.
I tried to do a Proc but it is not working any way here it is. So you will get a better idea of what I am trying to achieve.
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
ALTER PROCEDURE [dbo].[FilterServiceTickets]
-- Add the parameters for the stored procedure here
@userName varchar(20)= NULL,
@startDate datetime =NULL ,
@endDate datetime = NULL,
@status int = NULL
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT SERVICE_TICKET.SERVICE_TICKET_CODE, SERVICE_TICKET.PROBLEM_REPORTED, SERVICE_TICKET.CONTACT_NUMBER,
SERVICE_TICKET.STATUS
FROM aspnet_Users INNER JOIN
BuildingAddress ON aspnet_Users.UserId = BuildingAddress.UserID INNER JOIN
SERVICE_TICKET ON BuildingAddress.Customer_Site_Int_ID = SERVICE_TICKET.CUST_SITE_INT_ID
WHERE ((aspnet_Users.UserName = @userName)OR (@userName=NULL))
AND ((SERVICE_TICKET.STATUS = @status) OR (status=NULL))
AND ((SERVICE_TICKET.CREATED_DATE >=@startDate AND SERVICE_TICKET.CREATED_DATE <=@endDate ) OR (@startDate=NULL)OR (@endDate=NULL)OR(@startDate=NULL AND @endDate=NULL))
END
Could some one please help me with this.
Thanks
i have setup a sql job with 4 steps
1-checkdb
2-indexdefrag
3-sp_updatestats
4-email notification.
if 1,2 success go next step
if 1,2,3 fails go step 4
if 3, 4 success quit with success
if 4 fails quit with failure
i created a script and pasted it in production server and i get this msg:
Warning: Non-existent step referenced by @on_fail_step_id.
Warning: Non-existent step referenced by @on_fail_step_id.
Warning: Non-existent step referenced by @on_fail_step_id.
how can i fix it? I think the error is due to step 4 not executing before calling it from stepe 1,2,3
I have so many warnings in the package which i create and to open a package to takes a very long time..
How do i get rid of the warnings
Warning 2 Validation warning. Tablw1: OLE DB Destination 8 [61186]: Truncation may occur due to inserting data from data flow column "MEMNO" with a length of 255 to database column "MEMNO" with a length of 50. Membership 90-98 Access 2000.dtsx 0 0
In the final oledb dectination of the package i dont connect the error output to error table because they don't have errors
How to proceed with it???
We have a 6 node cluster with 4 SQL Server named instances in the cluster. I am noticing a lot of warnings in the event log with the following information:
Event Type: Warning
Event Source: SQLBrowser
Event Category: None
Event ID: 3
Description:
The configuration of the AdminConnectionTCP protocol in the SQL instance
<instance name> is not valid.
The event occurs for all four instances.
Additional Information:
* OS is Windows 2003 R2 Enterprise x64 Edition w/SP2
* SQL Server 2005 Enterprise Edition w/SP1, hot fix level 2221
* All SQL services runs under the same domain user account
I did some internet searches and found several others who have had this problem. However, I didn't see any solutions. There also seems to be a similar problem with SQL Express but that is not what I am using.
Any thoughts are appreciated.
Hi. I'm Sara Cushman, a reporter for SearchDatabase. We're doing a story about the latest round of SQL server security warnings and patches.
How did you handle the situation? Did you drop everything else and deal with it? How did it compare with other SQL Server problems you have had? Were you able to handle it in a way that you feel left you without any vulnerabilities? If you haven't dealt with it, what are you waiting for?
We're looking for DBAs to share their stories. If you have some, reply here or email me at scushman@techtarget.com so that I can get in touch with you.
Thanks!
Hey y'all...
Anyone know how to capture SQL Warnings so I can write them to an error log? I can't seem to find any info on it in Books Online...
I can capture the errors just fine by using @@ERROR after a select, but what about warnings such as "Warning: Null value is eliminated by an aggregate or other SET operation."
Thanks!
Is there a way to disable warnings in ssis? I'm using a third part tool to call an ssis and when the ssis give a warning the tool is showing failure.
View 1 Replies View RelatedRao Aregaddan writes "Hi All,
Here is my Query.....
While executing the following code,it is showing some warnings.
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON
GO
Drop procedure [DBO].[Usp_Extract_OLAP_Data_1]
GO
Create Procedure [DBO].[Usp_Extract_OLAP_Data_1] as
begin
IF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID('[DBO].[processed_olap_data_1]') AND OBJECTPROPERTY(ID, N'ISUSERTABLE') = 1)
DROP TABLE [DBO].[processed_olap_data_1]
select * into dbo.processed_olap_data_1 from pubs.dbo.processed_olap_data_1
EXEC ('ALTER TABLE dbo.processed_olap_data_1 ADD generatedid INT IDENTITY')
select * from processed_olap_data_1 order by generatedid
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
SET ANSI_WARNINGS OFF
GO
Out Put is as follows
----------------------
(141 row(s) affected)
(141 row(s) affected)
Warning: The table 'processed_olap_data_1' has been created but its maximum row size (3873071) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
(141 row(s) affected)
Please guide me on this issue that why iam getting this warning even i set the ansi null and ansi warnings off.
one more thing is that is there any other way to add an
identity column with out using alter statement.and is there any problem with front end guys if it shows like this warnings..."
Hi! guys,I have a SQL agent job fails because it gets 10 warnings when it runsa stored procedure. These warnings are trivial and can be ignored. CanI make it ignore these warnings and proceed? I think there is somesetting I can do to change the default behavour of an agent jobregarding warnings but I just don't know how to do it.Any idea?Thanks,Gary
View 12 Replies View RelatedHi,
I would like to get a list of all the unused columns, I have tons of files and fields in the package probably in the hundreds and I need to know which fields I am not using to see which fields are important not to miss out, so is there any way I can get them in a text file or any other format?
Thanks
Hello,
I am creating a 2005 SSIS Package with multiple data flows with source data based on the XML Source and a XSD Schema that we have created. These data flows load data from XML into different tables in our data warehouse for order data so the XSD Schema has several hierarchies. Because each data flow loads data into one table (I broke it out this way to make the package easier for readability and maintance) and the source for each is based on the XSD hierarchies I receive numerous warnings similar to the following; "Warning: 0x80047076....Removing this unused output column can increase Data Flow task performance." that I would like to remove. However, when I un-check the box to remove those output columns (which leaves several hierarchies without output columns) I then receive a error similar to the following; "Error: 0xC00470B9 at ....contains no output columns. An asynchronous output must contain output columns."
So the question is how to remove the numerous remove column warnings? I have thought about creating one XML schema for each dataflow, breaking the data flows into different packages, etc. but I am still not exaclty sure how to remove the warnings which should increase the speed of the package overall. Thank you!
I was just going through the default trace files and see full of sort warnings, missing join predicates and hash warnings. The server behaved weirdly last night with queries longer than usual time and the server started choking. I didn't find any info from error logs or event viewer.
View 3 Replies View Related
Hi,
I am trying to import from Excel file. So In between Excel file source and OLEDB destination I am using One Data Transformations to convert excel unicode characters to Sqlserver varchar.
Iam getting this following errors:
1)
Error: 0xC020901C at Data Flow Task, OLE DB Destination [382]: There was an error with input column "Copy of Zip" (615) on input "OLE DB Destination Input" (395). The column status returned was: "The value could not be converted because of a potential loss of data.".
Copy of zip is the Data Transformation column mapped Sqlserver Varcahr(200) column of Zipcode.
In excel file the Zip codes are like this:
78712-2344
78123
12345
87651-1234
2)
The column "State" needs to be updated in the external metadata column collection.
This is warning. This type of warnings are for all columns in excel file.
3) Intially I declared the Sqlserver table columns like this Varchar(100), then SSIS showing some warning like truncation of column State 255 characters to .. So I changed columns datatype from Varchar(100) to Varchar(500)? Why we need to change like this.
Thanks in advance
Hi,
I am getting unusable warnings from dataflow task while running. Say for example I am getting column A, B, C from source and I am using only column C in destination. Whenever I run the package, I am getting a warning saying that
"The output column "A" (67) on output "Output0" (5) and component "Data Flow Task" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance."
Can any one help me how to resolve these warnings?
Thanks in advance.
Hi,
Is there a way of stopping truncation warnings due to the fact the the XL driver assumings BSTR(255) columns. I'm loading data from excel to SQL Server, the SQL Server columns are nvarchar(50) but the Excel source has assumed 255.
I can change the Excel Source using the 'Advanced Editor' and change the meta-data of the 'Output Column', but then there's a mismatch between the External Column and Output Column collection - so a warning is displayed.
The External Column meta-data can be changed, but then it's out of sync with the 'Error Output' meta-data (and the Error Output meta-data is read only).
I'm sure I've missed a step, can anyone enlighten me
Dave
Hi,
I have a custom component that compiles just fine on one environment. I copied and pasted the code to another environment and now I'm getting compilation warnings:
Warning 1 CA1014 : Microsoft.Design : '*******.Seer.Ssis.Common' should be marked with CLSCompliantAttribute and its value should be true. *******.Seer.Ssis.Common
Warning 2 CA1705 : Microsoft.Naming : Correct the capitalization of type name 'PPDMDataLineageComponent'. C:PROJECTSSeerCode*******.Seer.Ssis.CommonPPDMDataLineageComponent.cs 13 Chevron.Seer.Ssis.Common
Warning 3 CA1062 : Microsoft.Design : Validate parameter 'buffer' passed to externally visible method PPDMDataLineageComponent.ProcessInput(Int32, PipelineBuffer):Void. C:PROJECTSSeerCode*******.Seer.Ssis.CommonPPDMDataLineageComponent.cs 99 Chevron.Seer.Ssis.Common
Any ideas?
Thanks in advance
-Jamie
When running a stored procedure, how can i retrieve the warnings that are issued within the stored procedure?
the code used is below,
the jdbc is connecting fine, it is running the stored procedure, but when an error is raised in the stored procedure, it is not coming back into s.getwarnings()
warning raised in stored proc with
Code Block
RAISERROR ('Error', 16, 1)with nowait;
there are no results for the stored procedure, I am just wanting to get the warnings
Code Block
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:sqlserver://localh...........);
CallableStatement s = con.prepareCall("{call procedure_name}");
s.execute();
//running in seprate thread
SQLWarning warn = s.getWarnings();
while (m.running) {
if(warn == null) {
warn = s.getWarnings();
}
safeOut(warn);
if(warn != null)
warn = warn.getNextWarning();
m.wait(100);
}the code is not complete, but should show what is happening
it is continually outputting null for the warning, though the strored proc is definately raising errors, which is proven by running it in a query window in sql server.
it is retreiving warning if the statement is a raiseerror instead of a call to the proc
Code Block
CallableStatement s = con.prepareCall("RAISERROR ('Error', 1, 1)with nowait;");
this thread is quite related, but doesnt offer a working solution
Getting messages sent while JDBC Driver calls stored procedure
any help much appreciated,
thankyou
Simon
hi!
i am trying to execute through command line the following:
dtexecui /SQL "ArchiveMain" /SERVER "SE413695AASQL2005" /WARNASERROR /MAXCONCURRENT " -1 " /CHECKPOINTING OFF
I am actaully creating an archiving package.
1. All it does is get some data from the Table.
2. creating directory and set usedirectoryifexist = true
shows some warning when i run that directory already exists cos i don't want to create new one i want to use the existing one.
3. actual archiving to get call to another package for archiving - warning while running the package that parent variable is missing
The pacakge seems to run while i execute it thorugh command prompt but i get this message
DTExec: The package execution returned DTSER_SUCCESS (0) but had warnings, with
warnings being treated as errors!
Thanks,
Jas
I have a manager SSIS package that calls a generic loader SSIS package, via the 'Execute Process Task'. The manger package (amongst other things) creates a config file and and then executes DTExec passing the config specification in the Arguments property, i.e. '
'/FILE "D:AudiencePackagesUKDW_Core_Loader_Persist.dtsx" /CONFIGFILE "D:AudienceDataSCPmystery.dtsconfig" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF"
It works as expected, but, I always get the warning message 'File/Process "DTExec" is not in path.', I know that it is because the exe runs and loads the correct package which then performs the correct actions.
Have I dropped the ball here? I cannot see any reason for the warning as DelayValidation==True, I could set RequireFullFileName==True, but I do not know where SQL is installed on the various nodes.
Any input would be warmly received
Thanks
Hi,
As I was developing my SSIS package, I created several variables and tasks ( FTP, WMI Reader Task ). I am now cleaning up, deleting unwanted variables and connections in the design window. I save and build the package and when I load the package, I get warnings that these variables are referenced but can't find them and errors that the WMI connection is not found.
When a package calls a sub-package, it stores the absolute path of the child package in its dtsx xml file in a Connection String property. How annoying !!! . When I deploy this to another machine with a different file structure, it becomes a problem. Why can't it store the path relative to the parent package, which would be typically in a sub-directory under the parent ?
These last 2 days have been nothing but frustration and my deadline is slipping. Any help is appreciated.
Thx,
-chiraj.
Hi, looking for some help on job notification emails in SQL 2005.
I've created a backup job in the Maintenance Plan section of SQL2005, and added a "Notify Operator" task to notify me when the job completes.
I've setup Database Mail, and I am getting the notification email whenever I run the job. So this is working fine.
The problem is when I got to the 'Jobs' folder, and into the properties of my backup job, I set it up to notify me from the notifications option, but I am not getting any emails. For now I have set it to notify me when the job "succeeds".
Any ideas why it works from the Maintenance Plan section, but not the "Jobs" notification section? Am I forgetting something?
I have recently migrated a SQL2000 instance to SQL2005, and would now like to setup all the existing jobs to notify me if they fail.
Any advice would be helpful
Thanks
All:
I've implemented a variation of the Custom Logging provided in this post by Jamie Thomson.
http://blogs.conchango.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx
Everything seems to work well on my desktop during development, but when I deployed the packages to our DEV environment the packages still execute, but I'm now receiving warning messages in the sysdtslog90 log table...
Precompiled script failed to load. Attempting to recompile. For more information, see the Microsoft Knowledge Base article, KB931846 (http://go.microsoft.com/fwlink/?LinkId=81885).
My log table (SSISLog) looks OK, with only OnPostExecute messages that include the package / task information and rowcounts.
The KB article suggests upgrading to SP2, but I'm well past SP2, using Build 3159 on both machines.
Any suggestions on how to get rid of the warnings?
Thanks!
Leda
Hi
I am using asp.net framwork 2 with sql 2005 express edition. Can anyone please provide me any sample of sending automated emails (like welcoming people when they register to my website, or if their personal details have been updated....). or any e-book/website ref will do. I am not very expert in sql/db and smtp (or other email) stuffs. So please help me.
With thanks
How would I go about checking incoming e-mails? For example, on a certain e-mail address, I would get e-mails formatted in a certain way. According to the response, some scripts need to run/ some sql tables updates etc. How can one do this in (ASP) .NET with SQL Server? Anyone did this kind of stuff before?
View 3 Replies View RelatedI'm new to programming and to databases so apologies if this sounds like a stupid question.
I have a html page with a simple javascript function that uses the href mailto tag to send an email to a normal email address. I was wondering if it would be posssible to send the email directly to an SQL Server database, without having to pass through an intermediate parsing app. It would mean assigning an email address to the database. Is this possible with SQL Server? I know there would still be problems with parsing the email content to the appropriate fields, but would the sending of the email to the database in itself be possible?
I haven't much experience using databases and I don't currently have access to the SQL Server Express database that will be used to store the email content, so I'm not sure how difficult an operation this would be. I've looked on the internet but I haven't been able to find anything. I was hoping someone here might have done something similar, either with SQL Server or with any other database.
Thanks in advance.
I'm trying to remove emails from a table but the simple update query I wrote doesn't seem to do it. I figured I'd test one record instead of the entire dbase. I've probably given more info than needed (the select statement) but wanted to give a frame of reference.
SELECT
Name.ID,
EMAIL,
COMPANY,
MEMBER_TYPE
FROM
APSCU_PROD.dbo.Name
[Code] ....
Hi, folks. I'm fairly new to SQL Server, so forgive any stupidityinherent in this question. I work at a university and a certainfaculty member would like to have her students create a simple auctionweb site as an exercise. As part of the assignment, she wants theauction site to be able to send an email to a bidder when they havebeen outbid.So she has asked me if this is possible, and how to do it. I've read abit about sending an automated email from SQL Server, but I can't findanything about how to trigger the email based upon a field comparisonin the database. I also don't know how to incorporate a field value asa variable into the body of the email.Of course, I don't expect anyone to solve my entire problem in thisforum. I was just hoping that someone could point me in the rightdirection. Can anyone give me any advice about where I should belooking for such info? Can you recommend a web page, or some otherreference material? Is there a specific terminology I should be usingwhen I search? I just don't seem to be able to find what I need.Please reply to Join Bytes! -- I don't read newsgroups regularly.Many thanks in advance!--Sue
View 3 Replies View RelatedIs there a way to automatically import incoming emails into a SQLServer Database?I know it is inefficient, but we have to run a number of rules on theemail after it is received. Store it in a database and be able toconnect other things, meetings, contacts, etc. Moving it back andforth in chunks can be difficult and the overhead could spiral out ofcontrol.So we were thinking of moving it to the DB as it was retrieved.What do you think would be a better solution to retrieve it?Does my email make sense?
View 2 Replies View RelatedJust wondering if there are other people getting mail from Pinnaclesoftware demanding payment of $179 for a subscription that they didn'trequest. I am now on the"Fourth Notice - Invoice past due"I know only one other SQL Server DBA and that person is also gettingthe mail each month. Information on the invoice says the paymentshould be made to Ragan Communication. Is there anyone else out therewho's getting these mails demanding money. I personally find itdisgusting that the company operates in this fashion.
View 1 Replies View RelatedWe have SQL server 2005 Reporting Services SP1. In Report Manager I have a shared subscription that runs every hour between 8am and 6pm (I created the shared subscription in Report Manager, then modified it in Sql Server Management Studio to run the hours I wanted). I have a second shared schedule that runs Tuesday and Friday at 7am. For 2 separate report subscriptions - one uses the hourly schedule and the other uses the 2-day schedule, the first time they run during the day it sends 2 email - after that it sends only 1 email, as it should. I created a subscription to email a report when the report content is refreshed from a report snapshot. In Properties...Execution, I selected to render this report from a report execution snapshot, and selected my shared schedule. For the History property I have selected Allow report history to be created manually and Store all report execution snapshots in history; I am not using a schedule to add snapshots to report history in the History property.
When I look at the job in Sql Server Management Studio, it has only ran once each hour. When I look at the snapshot history, there is only one record for each hour. Why is the first scheduled instance sent twice instead of once?
I don't know much about broker service so I have question. We have a content management system the we developed locally, and what we have are catagories and subcatagries. When people choose a topic we send them an email about the topic they are interested in. We are now selling webinars and white papers and articles on demand. We would like to be able to send a reminder email to anyone who signed up for a webinar or special event. Is this possible with broker service?
View 4 Replies View Related