Generate Exchange Task From T-SQL

Aug 17, 2006

Our organization would like to add tasks to users' Exchange accounts from our SQL Server using a USP. Basically, we are looking for the same functionality as the xp_sendmail syntax provides, but instead of sending an email to a user, we would like to create a task in the user's Exchange Tasks folder based on the information passed from our database via the USP.

Here is an example:

A client must receive paperwork every 6 months based on a date stored in our SQL database.
2 weeks prior to the date the paperwork is due, a USP would detect that John Doe has upcoming paperwork needed.
Bob is John Doe's sales rep. The USP would create a new task in Bob's Exchange Tasks folder indicating that John Doe's paperwork is due on such-and-such a date, setting reminders, etc.

We are currently running SQL 2000 and Exchange 2003 in an Active Directory environment. Any help or pointers would be greatly appreciated!!

Thank you - Jeremy

View 1 Replies


ADVERTISEMENT

Send Mail Task On Exchange 2007

Jan 25, 2008



I've used send mail tasks on all my etl's without any problem.

Today we are migrating from a exchange 2003 to an exchange 2007 server.

I've filled in the new IP and runned the send mail task box and now it fails, the send mail task won't work anymore.

Anyone else who has experianced simular problems like this ?

I've already tried the checkboxes use windows login verification and ssl but it still won't work.

Someone please help me or i have a major problem.

View 1 Replies View Related

Generate File Task With 2 Files

Sep 18, 2007

Hi Guys,

I've one Dafta flow task where I'm getting data from OleDb source and then doing some scripting using script component and then generating a file.
Now I would need to get the same data and apply some different things and generate another file.
Can I used this same task for doing the secondry work? If yes how woulld I put the thing in place, I would need to get the same data but I would need to use a seperate scripting and generate a seperate file?

TA
Gemma

View 1 Replies View Related

SSIS DataFlow Task To Generate Custom Columns

Apr 7, 2008

Hi All,

I am using a Data Flow task which copies data from an Excel Source to a SQL Database Table Destination. From 15 columns I require only 10 columns to be imported to the DB Table. So I have mapped those colums. In SQL DB there is a colum called say X, whose value should be the "Remedy" for all the columns which are imported. Is there any task that can achieve it.

Please Help.

View 10 Replies View Related

Data Script Task - How To Generate Multiple Rows From One Row ? (string Splitter)

Nov 28, 2006

Hi

in input we have a set of rows, each one with a column containing a string (eg: "AAOOOOAAAOOA").

We'd like to split this string (using a vb.net data script task) into tokens (eg: "AA", then "OOOO","AAA","OO","A"), and to output one line per token.

How can we achieve that with a vb.net data script task ? (Or anything else ?)

best regards

Thibaut

View 9 Replies View Related

SQL Tools :: Load Data From One Database To Another Using Task / Generate Script / Tables

Jun 15, 2015

I am trying to load the data from one data base to another using the Task->Generate Script->tables (data only).  So I saved the script of the data and when tried to run the script to the destination DB, getting the below error when ran the script.

Error: Visual Studio has encountered an exception. This may be caused by an extension.You can get more information by running the application together with the /log parameter on the command line, and then examining the file'C:UsersKK67AppDataRoamingMicrosoftAppEnv10.0ActivityLog.xm'. When tried opening the folder using the above path... don't see anything for AppData folder from that path.

View 2 Replies View Related

SQL 7.0 In SMS And Exchange?

Oct 24, 1998

Has there been any indication from Microsoft as to when they anticipate using SQL 7.0 in SMS and Exchange? We are currently planning our MCSE+I certification training course schedules through the end of March. We are currently using SMS 1.2 and Exchange 5.5, which use SQL 6.5. We are planning to schedule the SQL 6.5 Admin and Design classes, but knowing when Microsoft will switch to SQL 7.0 for their BackOffice apps may influence our schedule. I have been told that we could take the SQL 7.0 Design class, and the instructor could tell us what has changed since SQL 6.5. I was told that the SQL 7.0 Admin class is very much different, however. Could anyone shed any light on this?

Terry J. LeBlanc
Lambda Novatronics, Inc.

View 1 Replies View Related

Access To Exchange

Aug 9, 2002

Has anyone tried to link an Exchange database to SQL Server? I was wondering if I could query the Exchange database with SQL.

Thank you,
Jennifer

View 1 Replies View Related

Exchange WaitType

Nov 3, 2000

Does anyone know how to prevent an exchange waittype?? Is it happening because of the memory config??

View 4 Replies View Related

SQL Server And Exchange

Nov 15, 1999

How do I get my Exchange address from my exchange server stored in my SQL Server 7.0 database? Or, how do I query that list from SQL Server 7.0...?

Thanks!

Dean

View 1 Replies View Related

SQL Server Without Exchange

Jun 2, 1999

Hello,
I'm having difficulties to figure out how to set up Sql Server / Windows NT / MAPI in order to send e-mails.

Is it possible to manage emails from Sql Server without exchange ?

Thanks in advance

Sam

View 1 Replies View Related

MS Exchange Server

Jun 8, 2000

Hi there,

I have just installed Exchange Server.
Can any one help me for what I have to do in Exchange Server so that I can send Email
from SQL Server 7.0

Thanx in advance,
zak

View 2 Replies View Related

Linking To Exchange From SQL

Mar 16, 2004

Does Exchange 2000 and SQL 2000 have to be the same machine to use exoledb.dll?
I want to link to an Exchange server and gain access to a Public Folder Contact Object for use as a lookup table within an Access front end. Someone directed me to use the Exchange OLE DB Provider, but it does not exist on my SQL machine.

Any help is appreciated

View 14 Replies View Related

Pulling Information From Exchange Into SQL?

Apr 3, 2001

I am looking for something on pulling information from Exchange 5.5 Sp4 to SQL7.0. Anyone know where I can start?
-Stu

View 3 Replies View Related

Moving Exchange Email To SQL

Apr 27, 2001

We have a business requirement for arching emails (5+ years) which are
generated in an e-commerce application. The quantity is substantial and
some of the emails will have MS Word attachments. As stands today, our
Exchange 5.5 environment is already taxed and archiving options are limited.
Someone suggested that there is a way to offload the emails into a SQL
database. If we could do this, this would provide much more latitude.

Generally speaking, is this difficult?

Thanks,
Bill

View 1 Replies View Related

SQL Mail And Exchange Question?

Jul 9, 2001

Hey All,

Is there any way to run SQL Mail with exchange CLOSED? Keeping Exchange always minimized seems rather unneedy, inexperienced developers might just have the tendency to close it. Is there any way to avoid that?

Also, can SQL Mail be configured with something else besides Exchange?

Thanks a bunch!

Ilya

View 3 Replies View Related

SQL AGENT MAIL Not Using Exchange

Oct 27, 2000

I setup a domain user account and e-mail account for the sql agent. When I want the agent to mail me a message
when something happens it puts it in the out box but does not send until I pull up the outlook express and ping the server to send recieve.
If I don't have outlook express running in the taskbar, it won't send the message at all. The e-mail is configured as an internet mail component.
Any suggestions??

View 2 Replies View Related

Using SQL MAIL Without A MS Exchange Server ?

Oct 28, 2000

I want use SQL MAIL, but I have MDAEMON mail server on my Wndows NT Server!
Can I have any chances for it?

View 1 Replies View Related

Import Exchange Into SQL Server With DTS?

Oct 4, 2000

Import Exchange into SQL Server with DTS?

Our users enter data into the MS Exchange database using custom Outlook forms. We want to import that data in SQL Server using SQL Server Data Transformation Services (DTS). We do not see Exchange in the Data Source list in the DTS wizard. Is there an easy way to do this? Maybe an OLEDB provider for Exchange?

Thanks,
Bob

View 1 Replies View Related

Currency Exchange As A Dimesnion

Dec 22, 2004

I have a fact table with amounts, all in a single currncy. I would like to be able to process the cube where I can select the currency from a dimension.

The format of the currency exchange dimension must include date, currency code, and exchange rate, where the native exchange rate (the currency that the amounts are in) is defined as 1.000.

View 7 Replies View Related

SQL Alerts Via Exchange Email

Dec 9, 1998

I once had a procedure to setup exchange client as email for SQL alerts,
but I've misplaced it. (threw it out, actually) I've not had great luck finding it on the web at MS, or otherwise. Does anyone know where this can be found? Thanks in advance, John

View 1 Replies View Related

Database Mail And MS Exchange

Oct 30, 2007



I have set up database mail in SQL 2005. We have an MS Exchange group that is alerted when SQL jobs fail.
Two things ;
i) I can't seem to be able to use Exchange mail Groups. If I specify the group name SQL returns ;

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2007-10-30T15:40:39). Exception Message: Cannot send mails to mail server. (The specified string is not in the form required for an e-mail address.).
If Exchange cannot be used in the way that Outlook did then how can we alert a group of users about SQL job failures ?

Therefore I tried specifiying an indiviual email address rather than a group ;

- sending a test message (right click database mail) using the full single email address works fine.
- sp_send_dbmail using the full single email address is also fine.

ii) When a job fails the notifications do not seem to work. The Job history log just reports ;
NOTE: Failed to notify 'Operator Name ' via email.
The SQL Error log reports ;
Message
[264] An attempt was made to send an email when no email session has been established

However sysmail_help_status_sp indicates that database mail has started.
The job fails to notify the operator and in this case it is a single email address.


Anybody got any suggestions, (thanks in advance) ?

View 7 Replies View Related

Send Mail Task Problem Using A Combination Of ForEach Loop, Recordset Destination, Execute SQL Task And Script Task

Jun 21, 2007

OK. I give up and need help. Hopefully it's something minor ...



I have a dataflow which returns email addresses to a recordset.

I pass this recordset into a ForEachLoop configuring the enumerator as (Foreach ADO Enumerator). I also map the email address as a variable with index 0.



I then have a Execute SQL task which receives this email address as a varchar variable (parameter 0) which I then use in my SQL command to limit the rows returned. I have commented out the where clause and returned all rows regardless of email address to try to troubleshoot this problem. In either event, I then use a resultset to store the query result of type object and result name 0.



I then pass this resultset into a script variable to start parsing the sql rows returned as type object. ( I assume this is the correct way to do this from other prior posts ...).



The script appears to throw an exception at the following line. I assume it's because I'm either not passing in the values properly or the query doesn't return anything. However, I am certain the query works as it executes just fine at the command prompt.



Try

ds = CType(Dts.Variables("VP_EMAIL_RESULTS_RS").Value, DataSet)



My intent is to email the query results to each email address with the following type of data by passing the parsed data from the script to a send mail task. Email works fine and sends out messages but the content is empty. I pass the parsed data as string values to the messagesource and define the messagesourcetype as a variable in the mail task.



part number leadtime

x 5

y 9

....



Does anyone have any idea what I might be doing wrong?

thanks

John

View 5 Replies View Related

Exchange Data Between Databases On Two Servers??

May 29, 2007

Dear all
 
I have tow server on the same intranet. One server has a sql server 2000 database and the other one has SQL server 2005 databse.
 The sql 2000 database has a table called employee. When ever a new employee is inserted in the database i would like the same values to be sent to the sql 2005 database. But this cant be done on the application level. It has to be done in the database. The application level can not be changed.
I was thinking a trigger but how to achieve the writing from one database to another. If they were on the same server then it would be easier but because they are on different servers i dont know how to do it.
 Has anyone had similar issue before?
Any help is apreciated.
 
Sincerely
Dan

View 2 Replies View Related

Extracting Data From Exchange Into SQL Server Db

Mar 22, 2002

Has anyone been able to solve the issue with setting up a package in EM, which connects to an Exchange(.edb) database and extracts the data into a SQL Server db. Previous message posts don't offer much insight. So far, all I have is using Access 2000, to connect & move the data, then extract from here.
Thanks in advance for any help.
BV

View 1 Replies View Related

Window NT Messaging Or Exchange Server ??

Dec 22, 2000

Hi

I have Outlook 2000 and SQL 7 .. do I need Window NT Messaging and Exchange Server to configure a profile for the mail to work ???

thanks in advance for the answer

View 2 Replies View Related

Problem With SQL2000 And Exchange 2000

Nov 4, 2002

We have a SQL 2000 server that resides at a client. THey recently upgraded their exchange 5.5 server to 2000. I do not believe they are using Active Directory. However, our SQL Server can no longer send email. If we test it we get the error message "Error 22022 : SQL Agent error, you do not have permissions to perform this operation on this object" I found the below url to a MS error
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q293422&
but ut seems to relate to someone using Active Directory. However this problem did start as soon as they upgraded to Exchange 2000. Has anyone else encountered this?

View 1 Replies View Related

SQL Server And Exchange Calendar Items

Jun 14, 2004

We are looking to take rows from an existing SQL server table and use them to create calendar entries in Exchange server.

Is there a way SQL server can be set up so that this can be done as a trigger when new rows are entered into the table?

Thanks
Tim Smith

View 3 Replies View Related

Impersonate And Exchange Linked Server

Mar 17, 2004

Hello,

On my SQL Server 2000, I have successfully created a linked server to my Exchange 2000 server (located on the same physical computer). I can't send request and everything is fine.

But now, I would like to apply the "Impersonate" setting. The big problem I've got is that Exchange doesn't use a login and password for the authentification but use the Windows credentials.

I have try things like :
login : <domain name><username> with the real password
login : <username>@<internet domain name> with the real password
but that doesn't work.


I would like to know if there is a way to "impersonate" user log on the SQL Server when they try to use the linked server to Exchange Server.

Thank a lot

Felix Pageau
fpageau@NOSPAM.str.ca



Print | Copy URL of this post



Expand All Collapse All

View 3 Replies View Related

Connection To Exchange Active Directory

Oct 1, 2007

In sql server 2005 i want to connect to active directory of exchange server ... there is one option in which we can search outlook but its not fruitful ... please guide ...

View 3 Replies View Related

Exchange Of Login For Database User

Aug 24, 2005

I have a database with 2 users - 'dbo' and 'user1'.Currently:=> 'dbo' is tied to login - 'login1'=> 'user1' is not tied to any login.I want to change the login tied to the database users to:=> 'dbo' tied to no login=> 'user1' tied to 'login1'I try to use:sp_change_users_login 'Update_One', 'user1', 'login1'But it give me an error said 'login1' is already tied to a user.Then I try to remove the login tied to 'dbo' with this:sp_change_users_login 'Update_One', 'dbo', ''Then I get another error said that 'dbo' is a forbidden value for thelogin name parameter.------Previously, all the while 'dbo' is not tied to any login and 'user1' istied to 'login1', but yesterday I restore the DB from the backup filebring back from customer side, then I saw the login changed to the oneI mention above, I'm not sure whether is the DBA from customer sidechange it or what, but is there any way for me to change the login backto the state I want?Thanks.Peter CCH

View 11 Replies View Related

Create Linked Exchange Server

Aug 29, 2007

I'm using sql server 2005 and exchange 2003. End result is I want to upload email attachments to a table in sql. No one seems to have any idea how do do this except with .net, which i know nothing about so not really an option for me. I found this bit of info with some extensive web searching. Can anyone help fill in the blanks? I can't get the linked server to work yet.


EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\.ackofficestoragemailservernamepublic folders'

Error received:The OLE DB provider "exoledb.DataSource.1" has not been registered.

View 1 Replies View Related

Latest Known Exchange Rates MDX Query

May 29, 2008

Hi,

I have this specific problem, that has been causing me alot of headaches for the last couple of days, and I can't seem to fiure it out on my own.

Basically i am working on a many to one currency conversion setup, where I have a fact table with exchange rates for periods and for all input currencies. The reporting currency is USD. Here is a demonstration of the data in it:

Valid Date Source Currency Rate
2008-01-01 GBP 2.0563
2008-01-01 EUR 1.4634
2008-04-01 GBP 1.9968
2008-04-01 EUR 1.5197

Normal period by period conversion is easy enough, but I want to convert the measures at the latest known rate, based on the period selected. Lets say I run an analysis without slicing on time, then it want it to convert at the last entered rate of all time, and if the user wants to run the analysis as of March 08, then it should convert all data to the rate as of January, since this is the latest one known.

I have tried to set the measure to a semi-additive behaviour, with "lastnonempty", but the problem with that is the conversion over time. Here is an example:

I want to show a measure summed "all to date" as of June 08. What I want is it to convert everything at the rates entered in April 08, but what I get is that it convert everything up until Jan 08 and the rates entered in January, and thereafter it starts to use the rated entered in April.

Period Amount LCY Currency Code Exchange Rate
Dec 07 100 GBP 2.0563 (Wrong, should be 1.9968)
Dec 07 100 EUR 1.4634 (Wrong, should be 1.5197)
Jan 08 100 GBP 2.0563 (Wrong, should be 1.9968)
Jan 08 100 EUR 1.4634 (Wrong, should be 1.5197)
Feb 08 100 GBP 1.9968
Feb 08 100 EUR 1.5197
Mar 08 100 GBP 1.9968
Mar 08 100 EUR 1.5197
Apr 08 100 GBP 1.9968
Apr 08 100 EUR 1.5197
May 08 100 GBP 1.9968
May 08 100 EUR 1.5197
Jun 08 100 GBP 1.9968
Jun 08 100 EUR 1.5197

How do I create a measure containing the latest known rates based on time selection?

Thanks in advance

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved