Import Outlook/ACT Etc Contacts To SQL Server Table
Guys
Does anyone know of a 3rd party module/plug-in for VS or even some
downloadable code that enables the import of Outlook/ACT and similar contact
information through an ASP.NET page into a SQL Server table with ongoing
1-click button sync.
I need to replicate something similar to the Intellisync tool used in Yahoo
Mail.
regards
Andy
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Synchronization Of Business Contacts In Outlook With Small Business Accounting
Can anyone take me through synchronization of contacts within Business Contacts Outlook into Microsoft Small Business Accounts? I run a stand alone PC with NO network. When SBA came SQL was also installed. Apparently you can synchronise Contacts within Business Contacts with SBA but both SBA & Outlook should work through the same SQL server. Has anyone tried this? Can someone walk me through the process? Thanks Debbie
View Replies !
View Related
Script To Import SQL Server Data To Outlook?
is it possible to write a script for Microsoft outlook that will execute a query to an sql server 2005 and populate a public "contacts" folder? i know there are expensive syncing applications, but i would just like to script and buttonize the manual export-import process. is it possible? macros? what is required? ADO/DAO/other is there a basic example of this or just a script sample of connecting and retrieving a dataset from the server? thanks, Leon
View Replies !
View Related
Help With Duplicate Contacts In Contact Table
I'm new to SQL with 2 weeks under my belt....lol, so this may be a simple edit: When I run the following query, I can get a list of all dups in the contact field: ++++++++++++++++++++++++++++++++++ SELECT full_name, COUNT(full_name) AS NumOccurrences FROM contact GROUP BY full_name HAVING ( COUNT(full_name) > 1 ) ++++++++++++++++++++++++++++++++++ However: I need to make sure I am de-activating (active = 0) only the contacts where they are listed more then once within the same company table (company.company_id) and the condition is that phone is NULL. I can't seem to make it work. Does anyone have any suggestions for an UPDATE I can use?
View Replies !
View Related
SQL Data Import Into MS Outlook.
Hello all, I am trying to build some sort of interface either directly in MS Outlook on the client comp. or a stand-alone app. The requirement works somewhat like what is done between a PDA and MS Outlook, with the exception that the data only goes one way - SQL Server --> Outlook. I want to allow for the user to choose from their data in SQL Server and have it bring that data down into their contacts folder. It will need to work over the internet, and MS Exchange is not a preferred method. Clients are not on the same network as the server, they only connect to the internet via IP and use simple POP mail accounts. Thanks ahead of time. Dave
View Replies !
View Related
Outlook...export To Csv....manipulate In Web Page....import
Guys Still trying to nail something down on this in more detail. Does anyone have or know of a script...utility...example, that enables the importing of Outlook contact data (typically a csv file) into an asp.net page. Then once this data is displayed the ability to manipulate that data to sync up with a table in a SQL Server database and ulimately save that data to SQL Server for use in a web app. This is for a CRM app and everything is web hosted and thus the need for the import/export ability for users to upload their Outlook contact data for use in the web app. regards Andy
View Replies !
View Related
SQL Server Import And Export Wizard Fails To Import Data From A View To A Table
A view named "Viw_Labour_Cost_By_Service_Order_No" has been created and can be run successfully on the server. I want to import the data which draws from the view to a table using SQL Server Import and Export Wizard. However, when I run the wizard on the server, it gives me the following error message and stop on the step Setting Source Connection Operation stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Error) Messages Error 0xc020801c: Source - Viw_Labour_Cost_By_Service_Order_No [1]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0014019. There may be error messages posted before this with more information on why the AcquireConnection method call failed. (SQL Server Import and Export Wizard) Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap) - Setting Destination Connection (Stopped) - Validating (Stopped) - Prepare for Execute (Stopped) - Pre-execute (Stopped) - Executing (Stopped) - Copying to [NAV_CSG].[dbo].[Report_Labour_Cost_By_Service_Order_No] (Stopped) - Post-execute (Stopped) Does anyone encounter this problem before and know what is happening? Thanks for kindly reply. Best regards, Calvin Lam
View Replies !
View Related
Email Report In Outlook 2007 Not The Same As Outlook 2003
I have a Reporting Services 2005 report that is emailed to users. I created/formatted the report based on how it looked in Outlook 2003 which all of our users had at that time. The report is wide, but just fit in the email window when it was full size. Now I have a user who has been converted to Outlook 2007 and he emailed me a copy of the report he received in Outlook 2007 and it looks like it reduced the column sizes; it does not fill the entire email window and wraps the wording on most lines because the column sizes have been reduced. The report is: Delivered by: Report Server E-mail Include Report is checked Render Format is Web archive Any ideas on how I can fix this? Thanks in advance.
View Replies !
View Related
How Can I Import Records From A Sql Server Table In Project1 To Another Sql Server Table In Project2
Hi, i have a table with all employee bio-data in a completed project. Iam now working on another project with a table that needs the same data and here iam talking about 300 records that rarely change. Instead of re-entering this data in this new table, i want to import the data from the completed project into a table in this new project. Does any one have any idea how to achieve that or is there a better option to do the same. One more thing iam realising here is that iam going to use this same data in very many applications and some one from one department is going to enter this data in all these different applications. so i was wondering if there could be a way of having a central database that this guy can mantain and then i be able to use that table data in different applications that iam going to develop. I dont want to kill this unlucky guy with data entry tasks every time i deploy a new application. So basically, how can make one database application sever several different applications with its data.
View Replies !
View Related
Table Column Widths Size Differently When Emailed To Outlook
I am able to get reports going with tables sized properly. They look fine on the ReportServer website and I adjust the column widths so that the headings and data look nice. When I set up a subscription to be delivered by "Report Server E-Mail," though, the table formattings get completely distorted. In particular, I have two tables, with some column headers being two short words (e.g. Max Height). When rendering on the site, I adjust the columns so the full column header is visible on one line. When I receive the email and read it in Outlook, the header row is now about twice as tall and everything is scrunched together. Both the headings and the data in the fields do not format the same as on the website. The two tables tend to actually have the exact same width in the email version, although occasionally they are a little different (in the web version one is about half as wide as the other). I have tried just making the columns bigger and that has not worked. I've tried making the font sizes smaller, which didn't work. If I do that, leaving the columns the same width, the email version just gets scrunched into a smaller area with the same text-wrapping problems. If I open the email in a browser (in a web mail interface) the report renders perfectly as on the site. I have almost all the default settings, and haven't been messing around with page sizes and things like this (except after, to see if that would fix the problem). Any ideas, similar experiences, or suggestions? If there is a book I should read or any reference you could point me to in order to figure this out would be helpful. I haven't been able to understand this either using web searches or the two SQL reporting services books I have.
View Replies !
View Related
How Would I Update These Contacts?
I use this query: SELECT TOP 4000 * FROM wce_contact where website not like '' and expressemail like '%@%' and idstatus like '' and salutation not like '%there%' and task not like '%x%' I know that I can update a field like this... update wce_contact set task = '' where task in ('x') But how would I update a field that matches the above query? If you read my other post, this would eliminate the need for me to select a range of contacts.
View Replies !
View Related
Quicker Way Of Selecting Contacts
Instead of selecting records like this: Select website from wce_contact where uniqueid like 'O,U4Ba-l2Nmc' or uniqueid like 'O90kja8,aofc' or uniqueid like 'OIiZnaAHj1fc' or uniqueid like 'oho9mc2HA4fc' or uniqueid like 'ogJrMa.YV9mc' or uniqueid like 'PNocYaQtA6fc' or uniqueid like 'NLWTfcUSbXec' or uniqueid like 'O_eHjaNhPtfc' or uniqueid like 'OK(Qkau,H(fc' or uniqueid like 'nYcUfcCQbXec' or uniqueid like 'O-R5oa2C-2fc' or uniqueid like 'O-R5oa2C-2fc' or uniqueid like 'nPYhfat5eJec' Is there anyway i can select these contacts without having to copy and paste 'or uniqueid like' numerous times? Thanks!
View Replies !
View Related
Help On Double Contacts In My Database
Hello! I am currently workin on clearin a litte in our data collation, Can anyone tell me how i will get this to work.. I have this selected so far [URL=http://img247.imageshack.us/my.php?image=sqlresultatct2.png][/URL] But i only want those selected who have the highest value in the last 3 columns in relation with their counterpart.... Anyway of doin that?? this is what i have to get the result-set SELECT contact.contact_id, contact_p.p_name, contact_adr.adr_zip_code, contact_p.p_first_name, contact_p.p_last_name, form_land_i_os.cdp_1y81__, form_land_i_os.cdp_totalha, form_land_i_os.cdp_ha_krak FROM contact, contact dub_contact, contact_p, contact_p dub_contact_p, contact_adr, contact_adr dub_contact_adr, form_land_i_os, form_land_i_os dub_form_land_i_os, po_userdw WHERE (contact.deleted IS NULL AND dub_contact.deleted IS NULL AND dub_contact_adr.adr_zip_code IS NOT NULL AND contact.contact_status = 3 AND dub_contact.contact_status = 3 AND contact.p_id = contact_p.p_id AND dub_contact.p_id = dub_contact_p.p_id AND contact.adr_id = contact_adr.adr_id AND dub_contact.adr_id = dub_contact_adr.adr_id AND form_land_i_os.id = po_userdw.id AND dub_form_land_i_os.id = po_userdw.id AND po_userdw.relation_id = contact.contact_id AND contact_adr.adr_zip_code = dub_contact_adr.adr_zip_code AND contact_p.p_first_name = dub_contact_p.p_first_name AND contact_p.p_last_name = dub_contact_p.p_last_name AND contact.contact_id <> dub_contact.contact_id AND contact.adr_id <> dub_contact.adr_id AND contact_p.p_name <> 'X') ORDER BY contact_p.p_name Thank you in advance wise gentlemen Dont cross the road, if you cant get out of the kitchen
View Replies !
View Related
Outlook And SQL Server
Can anyone recommend a source of info on connecting Outlook to a SQL database of contacts? Also interested in third party tools/solutions that I could just buy and customize. I need to be able to get at data from my own VB apps, but it would be nice to dump contacts into Outlook for people taking laptops and CE machines on the road. Even nicer if they could use Outlook to update addresses and upload to SQL Server. Or am I just dreaming?
View Replies !
View Related
Text Import Finding Table To Import To Problem
Dear All,I'm trying to import a quite large text file (25mb) I had this workingfine by using the transfertext command and having a schema.ini file,however having changed the username and password for my connection toSQL server all my tables and queries come with dbo attatched, which isfine as I've now edited all the relevent code and macros.However, on the transfer text command, it doesn't recognise the table Iwant to import into, it says it can't find it.I've edited it to put dbo.tablename and I've tried importing the filethrough the menu and selecting the table from the list using the wizardand it still can't find the table to import to.Any ideas?Matthew
View Replies !
View Related
How To Import Xml Spreadsheet Data Into Sql Server Table ?
Hi, I am trying to import "XML Spreadsheet" data into sql server table without using Excel Interop classes or objects because I am not having MS Excel installed on my web server on which my application is deployed, but I am not getting exact method how to do this. I have searched a lot but I couldn't get any information anywhere. All the articles or information I got was not useful to me because everybody is using XML file as a source and not "XML Spreadsheet". Can anybody help me for this problem. Please note that I am not having XML file instead I am having "XML Spreadsheet". Please help me.
View Replies !
View Related
T-SQL: Import Excel List Into SQL Server Table
Hi everyone! I asked a similar question like this yesterday but i didnt work the way I wanted it to work. So I will ask in a diffrent way: I have an Excel list which i want to import into a table in my SQL Server 2005. The ServerTable has one more column (for the the primary key which is created automatically) than the ExcelList. How can i import the ExcelList in a way so that I the first column of my ServerTable is not filled by a column of my ExcelList?? That is how far I came: select * into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D: esting.xls;HDR=YES', 'SELECT * FROM [Sheet1$]') many thanks and greetings from austria landau
View Replies !
View Related
Import Excel Data To A Sql Server Table
Hi, I need to import data from more than 10 excels having the same format in to a single sql server table. I tried to use INSERT INTO MyTempTable SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 11.0;Database=C:Book1.xls', [Sheet1$]) but got the below error Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server. If DTS package is used then I am not sure how I can place 10 excels at a time so that they can be picked one by one and data is imported in to table. Please help. Thanks, Vimalraj
View Replies !
View Related
Moving One Table From One Server To Another Server Using Import/export?
I have two databases on two different servers (an old hosting solution and a new). I need to get all the data from one server to the other but I have no clue as how to do it with MS SQL Server Management Studio Express. I can easily make the create table scripts that will allow me to create the tables on the new server but what about all the data. I wondered if there is some way to export and import data from one server to another? With the old SQL Enterprise Manager I was able to import or export as I saw fit but I can't seem to find anything like this with the express manager. Anyone has any advise as I would like to avoid coding somekind of export program myself, Many kind regards Weinreich
View Replies !
View Related
Outlook Distribution List And SQL Server
We have email addresses in a table in SQL server and these addresses increases every week. We want them to link to our Microsoft Outlook distribution list so that we can email them on weekly basis. Can someone please tell me how we can link table information to outlook or some other way to proceed to implement this. Thanks.
View Replies !
View Related
Sql Server Agent And Outlook Problems
Just recently my SQL server agent has been causing problems with my Outlook. When the Agent is started, it causes all processes on Outlook to hang. As soon as I stop the Agent, then Outlook works just fine again. Does anyone know a possible cause for this. Up until a couple days ago things were working just fine, and then this problem seems to have popped out of nowhere. joe
View Replies !
View Related
Syncing SQL Server 2005 And Outlook
Hi all, I'm looking for a way to sync Outlook Contacts with records in an existing SQL Server 2005 database. Ultimately I'd like all of the syncing to be done on a schedule on the server side but am open to any and all options. Updates to the data can be done on both the Outlook and the SQL side. We're running SQL Server 2005 on Windows 2003 and have both VSTO and SSIS available to get this accomplished. Many thanks. -Matt
View Replies !
View Related
SQL Server 2005 Conflict With Outlook BCM
Hi, I just installed the SQL Server 2005 eval version on my laptop to try it out and now Outlook crashes. There appears to be a conflict with Outlook Business Contact Manager, which might be running its own database under the covers. When I try to start Outlook I get the error message "Business Contact Manager has encountered a problem and needs to close. We are sorry for the inconvenience". The button choices are Debug, Send Report Later and Don't Send. Clicking Don't Send closes Outlook. I found some info on modifying the registry to disable BCM, which I did, but I still get the same error and Outlook won't start. I also tried removing all of the SQL Server 2005 stuff from my path environment variable but it didn't work either. Any suggestions would be appreciated because I depend on Outlook for my email and contacts. Thanks, Mike
View Replies !
View Related
C# Application - Method To Import Delimeted CSV To Sql Server Table
Hi,I'm writing a telecom billing system where it is necessary to import csv delimited files into a sql server table. 1) The csv files to import differ in column arrangement i.e SQL server table arrangement = A, B, C, D whilst CDR = - , A, -, C, D2) The csv files are delimited via different characters i.e some are del.. by commas some by semi colons I can import a CSV file from my application using a BULK INSERT query but only using CSV that resembles the structure of the table exactly How can I pass a CSV to the table and state where I want each CSV column to fill a column in the SQL SERVER table Below is how I am managing to pass a CDR to the SQL table that I have pre manufactured to resemble the structure of the SQL table Is there a way I can state which values from the CSV I want to pass to corresponding columns in the SQL table: string conString = @"Provider=SQLOLEDB;Server=(local);Database=Billing;Uid=sa;Pwd=sa;"; for (int i = listBox1.Items.Count - 1; i >= 0; i--) { string strSQL; OleDbConnection objConnection = null; OleDbCommand objCmd = null; objConnection = new OleDbConnection(conString); string cdr = listBox1.GetItemText(listBox1.Items[i]); strSQL = "BULK INSERT Campaign FROM '"+ cdr +"' WITH (FIELDTERMINATOR = ',', ROWTERMINATOR = '')"; OleDbDataReader objDataReader; try { objConnection.Open(); objCmd = new OleDbCommand(strSQL, objConnection); objCmd.ExecuteNonQuery(); objCmd = null; objDataReader = null; objConnection.Close(); listBox1.Items.Remove(listBox1.Items[i]); } catch (Exception ex) { objConnection.Close(); } objCmd = null; objConnection = null; } Regards Simon
View Replies !
View Related
Sql Server 2005 Express: Export/Import Content Of A Table
I want to export data in a table from one database to another database. And I would like it bo be clone of the source table, if it's possible. Is there any tools out there that can help me with this or do I have to write my own code?Is it possible to query the database to get all columns and datatypes for å requested table? If possible, can you give me an example?If I have to write a tool myself I guess I would do something like this: Export - Query the database for columns and datatype for the requested table. Dynamically generate a query to retrieve all rows from the table and save it to an xml file. Import - Turn off the Identity Increment, loop through the xml file and generate insert queries to insert a clone of each row, turn off the Identity Increment. Viola! If programming only could be that simple :-) Regards, Sigurd
View Replies !
View Related
How To Get Receipients Email Address In Access 2007 Table From Outlook 2007 Using VBA?
Hi everybody. I am new to VBA,.,, I Have created a folder under inbox in Outlook 2007 which stored the receipients information like name, E-mail, which is not present in the address book of outlook. I have imported this folder in access 2007. My problem is ... it does not display the email address. Rest of the informations is displayed... Is there any way i could do this.?? is there any way i could get the email addresses to appear(import/get) in to the access table??? Is there any module i mite have to create?? Plz help... thanks a million
View Replies !
View Related
Import Excel Spreadsheet Data Into SQL Server Database Table Using SqlBulkCopy
Hi, I'm a Student, and since a few months ago I'm learning JAVA. I'm creating an application to call and compare times. For this I create in Excel a time table which is quite big and it would be a lot of typing work to input one by one the data in each cell in SQL Server, considering that I have to create 8 more tables. I was able to retreive the data from excel usin the JXL API of JAVA but it doesn't give all the funtions to perform math operations as JDBC. That's why I need to move the tables from Excel to SQL. I found this site http://davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx which gives a code to do so, but I guess that some heathers are missing or maybe I don't know which compiler to use to run that code, I would like you help to identify which compiler use to run that code or if there is some vital piece of code missing.// Connection String to Excel Workbook string excelConnectionString = @"Provider=Microsoft .Jet.OLEDB.4.0;Data Source=Book1.xls;Extended Properties=""Excel 8.0;HDR=YES;"""; // Create Connection to Excel Workbook using (OleDbConnection connection = new OleDbConnection(excelConnectionString)) { OleDbCommand command = new OleDbCommand ("Select ID,Data FROM [Data$]", connection); connection.Open(); // Create DbDataReader to Data Worksheet using (DbDataReader dr = command.ExecuteReader()) { // SQL Server Connection String string sqlConnectionString = "Data Source=.; Initial Catalog=Test;Integrated Security=True"; // Bulk Copy to SQL Server using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConnectionString)) { bulkCopy.DestinationTableName = "ExcelData"; bulkCopy.WriteToServer(dr); } } } On the other hand in this forum I that someelse use that link but implements a totally different code which I'm not able to compile also http://forums.asp.net/p/1110412/2057095.aspx#2057095. It seems this code works as I was able to read, but I do not know which language is used. Dim excelConnectionString As String = "Provider=Microsoft .Jet.OLEDB.4.0;Data Source=Book1.xls;Extended Properties=""Excel 8.0;HDR=YES;""" ' Using Dim connection As OleDbConnection = New OleDbConnection(excelConnectionString) Try Dim command As OleDbCommand = New OleDbCommand("Select ID,Data FROM [Data$]", connection) connection.Open() ' Using Dim dr As DbDataReader = command.ExecuteReader Try Dim sqlConnectionString As String = WebConfigurationManager.ConnectionStrings("CampaignEnterpriseConnectionString").ConnectionString ' Using Dim bulkCopy As SqlBulkCopy = New SqlBulkCopy(sqlConnectionString) Try bulkCopy.DestinationTableName = "ExcelData" bulkCopy.WriteToServer(dr) Finally CType(bulkCopy, IDisposable).Dispose() End Try Finally CType(dr, IDisposable).Dispose() End Try Finally CType(connection, IDisposable).Dispose() End Try Catch ex As Exception End Try The Compilers I have are: Eclipse, Netbeans, MS Visual C++ Express Edition and MS Visual C# Express Edition. In MS Visual C++ Thanks for your help. Regads, Robert.
View Replies !
View Related
Creating A Web Page For A Report Generated In Outlook From Within MS SQL Server Procedure
Hello, I have a stored procedure (QC_LookupChanges) below that is called by another proc QC_LookupModels and this proc has the table that drives the report. Right now the report output is received via e-mail in outlook. I need to write a page in Dot Net that will show the output in a similar format as the one e-mailed in outlook from the within the stored procedure. The user would need to compare the current set of edges(today) for a selected Edge model with the most recently archived set of edges(previous business day) got from our archived database. Also, I would need to allow them to filter the edge model universe based on the criteria: Membership in a Universe Definition, Country, Market Cap, Edge Change Threshold Would it make sense for me to reuse the same proc that does a similar process with some modifications or rewriting new procs altogether for displaying/editing the data? If I need to use the same proc/s, I would need to comment out the piece that calls procs for sending e-mails. I am fairly new to both SQL and Dot Net and I will be using C# for the code behind. OUTPUT ******************************************************************** This is a list of securities from the Long Term EM Edge Model w Fwd Earn where the Edge values vary more than 2 % If necessary, please fix individual securities by entering financial overrides into system Number Of Edge Changes: 1 ********************************************************************* EMPRESAS IANSA SA ID: 13745 EXT: 245656 COUNTRY: CHILE INDUSTRY: FOOD & HOUSEHOLD PRODUCTS Values Prior: 0.0196 Current: 0.0421 DIFF: 0.0225 Cap BP FEP FCEP EP CEP 20060202 $524.14 0.6349 0.0623 0.0886 0.0100 0.01 20060203 $549.20 0.6046 0.1182 0.1432 0.0100 0.01 Time Stamp: Feb 3 2006 6:00AM Mail message queued on: Feb 3 2006 5:47AM Server : APdbMIS_PRD1, Database : db -- CREATE INITIAL OBJECTIF OBJECT_ID('QC_LookupChanges') IS NULLBEGIN EXEC( "CREATE PROCEDURE QC_LookupChanges AS SELECT 'Message' = 'Created object stub for: QC_LookupChanges'" )ENDGO /* Called by : QC_LookupModels *//* *//***********************************************************************************/ ALTER PROCEDURE QC_LookupChanges( @ModelID INTEGER, @ModelName VARCHAR(40), @DataDate INTEGER, @UniverseID INTEGER, @Subject VARCHAR(255), @CapThreshold FLOAT, @PerentChange FLOAT, @FilterSecurityGroupID INTEGER, @Debug BIT , @ErrorOutput VARCHAR(255) = NULL OUTPUT )AS BEGIN SET NOCOUNT ON /****************************************************************************/ /* General Variables Declaration */ /****************************************************************************/ DECLARE @ErrorNum INTEGER /* keep track the global @@error */ , @ProcName VARCHAR(32) /* the current procedure name */ , @DomainCode CHAR(02) , @ReturnStatus INTEGER /* actual return value (0 or 1) */ , @RecordCount INTEGER /* keep tracks global @@rowcount */ , @TransactionStarted BIT /* avoid nested transaction */ , @CurrentDate DATETIME /* current datetime */ , @m VARCHAR(255) /* general procedure messages */ , @ErrorRoleID INTEGER /* for LogError Email recipient. */ /*--- Email Variables Declaration ---*/ DECLARE @Line1 VARCHAR(70) , @Line2 VARCHAR(70) , @Line3 VARCHAR(70) , @Line4 VARCHAR(70) , @Line5 VARCHAR(70) , @Line6 VARCHAR(70) , @Line7 VARCHAR(70) , @Line8 VARCHAR(70) , @Line9 VARCHAR(70) , @Line10 VARCHAR(70) , @Line11 VARCHAR(70) , @BatchID INTEGER , @EmailRoleID INTEGER , @RecipientListID INTEGER , @Ordinal INTEGER , @NewMessage INTEGER DECLARE @RowCount INTEGER , @iLineCounter INTEGER , @Line0 VARCHAR(70) DECLARE @iMaxLines INTEGER , @iCurLine INTEGER , @USource VARCHAR(100) , @txtMsg VARCHAR(100) , @tCapUSD MONEY , @SecurityID INTEGER , @ComponentDesc VARCHAR(100) , @FilterDesc VARCHAR(100) /****************************************************************************/ /* Initialize General Variables */ /****************************************************************************/ SELECT @ProcName = 'QC_LookupChanges' , @DomainCode = 'GO' , @ReturnStatus = 0 , @CurrentDate = GETDATE() , @m = '' , @ErrorRoleID = 100001 -- Global Research MIS , @ErrorNum = 0 , @EmailRoleID = 107004 -- create new role and default to BuySide Research SET NOCOUNT ON SELECT @m = '*** Started ' + @ProcName EXEC LogInfo @DomainCode, @ProcName, @m, @Debug = @Debug /****************************************************************************/ /* Initialize Application Level Variables */ /****************************************************************************/ SELECT @ReturnStatus = 0 , @iLineCounter = 1 , @iMaxLines = 10 , @iCurLine = 1 SELECT @USource = @ProcName SELECT @FilterDesc = '' IF @FilterSecurityGroupID IS NOT NULL BEGIN SELECT @FilterDesc = Description FROM OptMod..GO_SecurityGroups WHERE SecurityGroupID = @FilterSecurityGroupID END -- Setup temp table and load with dataCREATE TABLE #today( UniverseID INTEGER NOT NULL, SecurityGroupID INTEGER NOT NULL, cap_usd money NULL, BPR decimal (11, 4) NULL, EPR decimal (11, 4) NULL, CEPR decimal (11, 4) NULL, FCEPR decimal (11, 4) NULL, FEPR decimal (11, 4) NULL, MOMR decimal (11, 4) NULL) CREATE TABLE #yest( UniverseID INTEGER NOT NULL, SecurityGroupID INTEGER NOT NULL, cap_usd money NULL, BPR decimal (11, 4) NULL, EPR decimal (11, 4) NULL, CEPR decimal (11, 4) NULL, FCEPR decimal (11, 4) NULL, FEPR decimal (11, 4) NULL, MOMR decimal (11, 4) NULL) INSERT INTO #today(UniverseID, SecurityGroupID, cap_usd, BPR, EPR, CEPR, FCEPR, FEPR, MOMR)SELECT UniverseID, SecurityGroupID , SUM(CASE WHEN DataTypeID = 22 THEN CONVERT(money, Value) ELSE NULL END) AS cap_usd, SUM(CASE WHEN DataTypeID = 2 THEN CONVERT(decimal (11, 4), Value) ELSE NULL END) AS BPR, SUM(CASE WHEN DataTypeID = 5 THEN CONVERT(decimal (11, 4), Value) ELSE NULL END) AS EPR, SUM(CASE WHEN DataTypeID = 8 THEN CONVERT(decimal (11, 4), Value) ELSE NULL END) AS CEPR, SUM(CASE WHEN DataTypeID = 11 THEN CONVERT(decimal (11, 4), Value) ELSE NULL END) AS FCEPR, SUM(CASE WHEN DataTypeID = 15 THEN CONVERT(decimal (11, 4), Value) ELSE NULL END) AS FEPR, SUM(CASE WHEN DataTypeID = 43 THEN CONVERT(decimal (11, 4), Value) ELSE NULL END) AS MOMRFROM OptMod.dbo.GO_SecurityGroupFundamentals WHERE DataTypeID IN (22,2,5,8,11,15,43)AND UniverseID = @UniverseIDAND ValuationTypeID = 4GROUP BY UniverseID, SecurityGroupID INSERT INTO #yest(UniverseID, SecurityGroupID, cap_usd, BPR, EPR, CEPR, FCEPR, FEPR, MOMR)SELECT UniverseID, SecurityGroupID , SUM(CASE WHEN DataTypeID = 22 THEN CONVERT(money, Value) ELSE NULL END) AS cap_usd, SUM(CASE WHEN DataTypeID = 2 THEN CONVERT(decimal (11, 4), Value) ELSE NULL END) AS BPR, SUM(CASE WHEN DataTypeID = 5 THEN CONVERT(decimal (11, 4), Value) ELSE NULL END) AS EPR, SUM(CASE WHEN DataTypeID = 8 THEN CONVERT(decimal (11, 4), Value) ELSE NULL END) AS CEPR, SUM(CASE WHEN DataTypeID = 11 THEN CONVERT(decimal (11, 4), Value) ELSE NULL END) AS FCEPR, SUM(CASE WHEN DataTypeID = 15 THEN CONVERT(decimal (11, 4), Value) ELSE NULL END) AS FEPR, SUM(CASE WHEN DataTypeID = 43 THEN CONVERT(decimal (11, 4), Value) ELSE NULL END) AS MOMRFROM intldbArchive.dbo.GOSecurityGroupFundamenSaveD WHERE DataTypeID IN (22,2,5,8,11,15,43)AND UniverseID = @UniverseIDAND ValuationTypeID = 4AND ArchiveDataDate = @DataDateGROUP BY UniverseID, SecurityGroupID CREATE TABLE #tmpResults( ModelID INTEGER NULL, RelativeUniverseID INTEGER NULL, SecurityGroupID INTEGER NULL, SecurityID INTEGER NULL, ModelValueT decimal (8, 4) NULL, ModelValueY decimal (8, 4) NULL, ModelDiff decimal (8, 4) NULL, tCapUSD varchar(17) NULL, tBPR decimal (11, 4) NULL, tEPR decimal (11, 4) NULL, tCEPR decimal (11, 4) NULL, tFCEPR decimal (11, 4) NULL, tFEPR decimal (11, 4) NULL, tMOMR decimal (11, 4) NULL, yCapUSD varchar(17) NULL, yBPR decimal (11, 4) NULL, yEPR decimal (11, 4) NULL, yCEPR decimal (11, 4) NULL, yFCEPR decimal (11, 4) NULL, yFEPR decimal (11, 4) NULL, yMOMR decimal (11, 4) NULL, Name char(50) NULL, EXT_ID varchar(20) NULL, CountryName char(50) NULL, IndustryName char(50) NULL) INSERT INTO #tmpResults (ModelID, RelativeUniverseID, SecurityGroupID, SecurityID, ModelValueT, ModelValueY, ModelDiff, tCapUSD, tBPR, tEPR, tCEPR, tFCEPR, tFEPR, tMOMR, yCapUSD, yBPR, yEPR, yCEPR, yFCEPR, yFEPR, yMOMR, Name, EXT_ID, CountryName, IndustryName)SELECT ModelID = today.ModelID , RelativeUniverseID = today.RelativeUniverseID , SecurityGroupID = today.SecurityGroupID , SecurityID = today.SecurityID , ModelValueT = CONVERT(decimal (8, 4), today.ModelValue) , ModelValueY = CONVERT(decimal (8, 4), yest.ModelValue) , ModelDiff = CONVERT(decimal (8, 4), today.ModelValue-yest.ModelValue) , tCapUSD = CONVERT(varchar(17), tSGF.cap_usd, 1) , tBPR = tSGF.BPR , tEPR = tSGF.EPR , tCEPR = tSGF.CEPR , tFCEPR = tSGF.FCEPR , tFEPR = tSGF.FEPR , tMOMR = tSGF.MOMR , yCapUSD = CONVERT(varchar(17), ySGF.cap_usd, 1) , yBPR = ySGF.BPR , yEPR = ySGF.EPR , yCEPR = ySGF.CEPR , yFCEPR = ySGF.FCEPR , yFEPR = ySGF.FEPR , yMOMR = ySGF.MOMR , Name = sec.name , EXT_ID = ISNULL(cusip.external_id, sedol.external_id) , CountryName = cty.name , IndustryName = ind.nameFROM OptMod.dbo.GO_SecurityGroupModelValues todayJOIN intldbArchive.dbo.GOSecurityGroupModelValSaveD yestON today.SecurityID = yest.SecurityIDAND today.ModelID = yest.ModelIDAND yest.ArchiveDataDate = @DataDateJOIN OptMod.dbo.GO_SecurityGroupMembers mem ON mem.SecurityID = today.SecurityIDAND mem.UniverseID = @UniverseIDAND mem.GroupClassID = 1JOIN #today tSGF ON today.SecurityGroupID = tSGF.SecurityGroupIDJOIN #yest ySGF ON yest.SecurityGroupID = ySGF.SecurityGroupIDJOIN OptMod..GOSecurities gsec ON today.SecurityID = gsec.SecurityIDJOIN intldb..security_table sec ON today.SecurityID = sec.security_idLEFT JOIN intldb..external_id_snapshot_table sedol ON sec.security_id = sedol.security_id AND sedol.external_id_type = 2 LEFT JOIN intldb..external_id_snapshot_table cusip ON sec.security_id = cusip.security_id AND cusip.external_id_type = 1JOIN intldb..iv_eq_security_table esec ON today.SecurityID = esec.security_idJOIN intldb..country_table cty ON esec.primary_country = cty.countryJOIN intldb..industry_table ind ON esec.primary_industry = ind.industry AND esec.industry_type = ind.industry_typeWHERE today.ModelID = @ModelIDAND ABS(today.ModelValue-yest.ModelValue) >= @PerentChangeAND gsec.CapUSDMM >= ISNULL(gsec.CapUSDMM, @CapThreshold)AND (@FilterSecurityGroupID IS NULL OR (@FilterSecurityGroupID IS NOT NULL AND today.SecurityID IN (SELECT SecurityID FROM OptMod..GO_SecurityGroupSecurities WHERE SecurityGroupID = @FilterSecurityGroupID ) ) ) SELECT @RecordCount = COUNT(*) FROM #tmpResults IF @RecordCount = 0 BEGIN SELECT @m = 'There are no problems detected with Edge Values for ' + @ModelName EXEC LogInfo @DomainCode, @ProcName, @m, @Debug = @Debug END /*--- Reset Email Batch ID ---*/ SELECT @BatchID = NULL EXEC @ReturnStatus = IB_ResolveRolesToUserID @ID = @BatchID OUTPUT , @RoleID = @EmailRoleID , @Verbose = 1 , @Debug = @Debug SELECT @m = 'The BatchID for this report is ' + CONVERT(VARCHAR,@BatchID) EXEC LogInfo @DomainCode, @ProcName, @m, @Debug = @Debug SELECT @m = 'Add the analysts that are responsible for that security to the email list.' EXEC LogInfo @DomainCode, @ProcName, @m, @Debug = @Debug /* Add the analysts that also should receive this email */ INSERT IB_ResolveEmailWorkTable ( ID , UserID , Removable , EntryDate ) SELECT DISTINCT ID = @BatchID , UserID = OSMUserID , Removable = 1 , EntryDate = GETDATE() FROM #tmpResults tem JOIN intldb..vEquitySecurity sec ON sec.SecurityID = tem.SecurityID LEFT JOIN intldb..Analyst ana ON ana.analyst = sec.Analyst WHERE ana.OSMUserID NOT IN ( SELECT UserID FROM IB_ResolveEmailWorkTable WHERE ID = @BatchID ) /* Add the other personnel that are interested in this universe */ SELECT @m = 'Add the other personnel that are responsible for this universe.' EXEC LogInfo @DomainCode, @ProcName, @m, @Debug = @Debug INSERT IB_ResolveEmailWorkTable ( ID , UserID , Removable , EntryDate ) SELECT DISTINCT ID = @BatchID , UserID = ID , Removable = 1 , EntryDate = GETDATE() FROM OSMUser WHERE ID IN (37,172,78,5371) AND ID NOT IN ( SELECT UserID FROM IB_ResolveEmailWorkTable WHERE ID = @BatchID ) EXEC @Ordinal = IB_ResolveOSMUserToEmail @WorkTableEntryID = @BatchID , @RecipientListID = @RecipientListID OUTPUT , @RemoveWorkEntry = 'Y' , @Verbose = 1 , @Debug = @Debug IF (@Ordinal < 0) BEGIN GOTO ProcError END ELSE BEGIN SELECT @ReturnStatus = @Ordinal END SELECT @m = 'The RecipientListID for this report is ' + CONVERT(VARCHAR,@RecipientListID) EXEC LogInfo @DomainCode, @ProcName, @m, @Debug = @Debug /** CREATE A CURSOR TO HOLD THE DATA FROM THE TABLE **/ Declare Report INSENSITIVE cursor FORSELECT DISTINCT CAST(CAST(Name as char(30)) + ' SCB: ' + CAST(SecurityID as char(8)) + ' EXT: ' + CAST(EXT_ID as char(8)) as char(70)) as txtMsg, CAST(tCapUSD as money)*ABS(ModelDiff) as tCapUSD, SecurityID, '1st row' as ComponentDescFROM #tmpResultsUNIONSELECT DISTINCT CAST(' COUNTRY: ' + CAST(CountryName as char(20))+ ' INDUSTRY: ' + CAST(IndustryName as char(25)) as char(70)) as txtMsg, CAST(tCapUSD as money)*ABS(ModelDiff) as tCapUSD, SecurityID, '2nd row' as ComponentDescFROM #tmpResultsUNIONSELECT DISTINCT CAST(' Values Prior: ' + ISNULL(CONVERT(char(10), ModelValueY), 'NULL ') + ' Current: ' + ISNULL(CONVERT(char(8), ModelValueT), 'NULL ') + ' DIFF: ' + ISNULL(CONVERT(char(11), ModelDiff), 'NULL ') as char(70)) as txtMsg, CAST(tCapUSD as money)*ABS(ModelDiff) as tCapUSD, SecurityID, '3rd row' as ComponentDescFROM #tmpResultsUNIONSELECT DISTINCT CAST(' Cap BP FEP FCEP EP CEP PM' as char(70)) as txtMsg, CAST(tCapUSD as money)*ABS(ModelDiff) as tCapUSD, SecurityID, '4th row' as ComponentDescFROM #tmpResultsUNIONSELECT DISTINCT CAST(CAST(@DataDate as char(8)) + ' $' + ISNULL(CONVERT(char(12), yCapUSD), 'NULL ') + ' ' + ISNULL(CONVERT(char(7), yBPR), 'NULL ') + ' ' + ISNULL(CONVERT(char(7), yFEPR), 'NULL ') + ' ' + ISNULL(CONVERT(char(7), yFCEPR), 'NULL ') + ' ' + ISNULL(CONVERT(char(7), yEPR), 'NULL ') + ' ' + ISNULL(CONVERT(char(7), yCEPR), 'NULL ') + ' ' + ISNULL(CONVERT(char(7), yMOMR), 'NULL ') as char(70)) as txtMsg, CAST(tCapUSD as money)*ABS(ModelDiff) as tCapUSD, SecurityID, '5th row' as ComponentDescFROM #tmpResultsUNIONSELECT DISTINCT CAST(CONVERT(char(8), getdate(), 112) + ' $' + ISNULL(CONVERT(char(12), tCapUSD), 'NULL ') + ' ' + ISNULL(CONVERT(char(7), tBPR), 'NULL ') + ' ' + ISNULL(CONVERT(char(7), tFEPR), 'NULL ') + ' ' + ISNULL(CONVERT(char(7), tFCEPR), 'NULL ') + ' ' + ISNULL(CONVERT(char(7), tEPR), 'NULL ') + ' ' + ISNULL(CONVERT(char(7), tCEPR), 'NULL ') + ' ' + ISNULL(CONVERT(char(7), tMOMR), 'NULL ') as char(70)) as txtMsg, CAST(tCapUSD as money)*ABS(ModelDiff) as tCapUSD, SecurityID, '6th row' as ComponentDescFROM #tmpResultsUNIONSELECT DISTINCT CAST('' as char(70)) as txtMsg, CAST(tCapUSD as money)*ABS(ModelDiff) as tCapUSD, SecurityID, '7th row' as ComponentDescFROM #tmpResultsORDER BY CAST(tCapUSD as money)*ABS(ModelDiff) DESC, SecurityID, ComponentDesc Open Report Fetch Report INTO @txtMsg, @tCapUSD, @SecurityID, @ComponentDesc -- Start Batch Mail SELECT @BatchID = NULL , @NewMessage = 1 , @Line1 = '*****************************************************************' , @Line2 = ' This is a list of securities from the ' , @Line3 = ' ' + @ModelName , @Line4 = ' where the Edge values vary more than ' + CAST(@PerentChange * 100 as char(4)) + '%' , @Line5 = CASE WHEN @FilterDesc = '' THEN @FilterDesc ELSE ' for ' + @FilterDesc END + ' ' + CASE WHEN @CapThreshold IS NULL THEN '' ELSE 'where maket cap > ' + CAST(@CapThreshold as char(10)) END , @Line6 = ' If necessary, please fix individual securities by ' , @Line7 = ' entering financial overrides into AWKS. ' , @Line8 = ' ' , @Line9 = 'Number Of Edge Changes: ' + CAST(@RecordCount as varchar(5)) , @Line10 = '*****************************************************************' EXEC @BatchID = IB_PostMailMessageByID @BatchID = @BatchID , @Source = @USource , @Sender = 'dbo' , @RecipientListID = @RecipientListID , @NewMessage = @NewMessage , @Subject = @Subject , @Line1 = @Line1 , @Line2 = @Line2 , @Line3 = @Line3 , @Line4 = @Line4 , @Line5 = @Line5 , @Line6 = @Line6 , @Line7 = @Line7 , @Line8 = @Line8 , @Line9 = @Line9 , @Line10 = @Line10 , @RemoveWorkEntry = 'N' , @Verbose = 1 , @Debug = @Debug SELECT @m = 'The BatchID returned from IB_PostMailMessageByID is ' + CONVERT(VARCHAR,@BatchID) EXEC LogInfo @DomainCode, @ProcName, @m, @Debug = @Debug -- ONCE A CHUNK OF MAIL IS SENT, RESET ALL THE VARIABLES FOR THE NEXT ITERATION SELECT @iCurLine = 1 SELECT @Line2 = '' SELECT @Line3 = '' SELECT @Line4 = '' SELECT @Line5 = '' SELECT @Line6 = '' SELECT @Line7 = '' SELECT @Line8 = '' SELECT @Line9 = '' SELECT @Line10 = '' SELECT @NewMessage = 0 /** LOOP THROUGH THE CURSOR DATA **/ WHILE (@@FETCH_STATUS = 0) BEGIN If (@iCurLine = 11) BEGIN --Write the Body Header Information EXEC @BatchID = IB_PostMailMessageByID @BatchID = @BatchID , @Source = @USource , @Sender = 'dbo' , @RecipientListID = @RecipientListID , @NewMessage = @NewMessage , @Subject = @Subject , @Line1 = @Line1 , @Line2 = @Line2 , @Line3 = @Line3 , @Line4 = @Line4 , @Line5 = @Line5 , @Line6 = @Line6 , @Line7 = @Line7 , @Line8 = @Line8 , @Line9 = @Line9 , @Line10 = @Line10 , @RemoveWorkEntry = 'N' , @Verbose = 1 , @Debug = @Debug SELECT @m = 'The BatchID returned from IB_PostMailMessageByID is ' + CONVERT(VARCHAR,@BatchID) EXEC LogInfo @DomainCode, @ProcName, @m, @Debug = @Debug -- ONCE A CHUNK OF MAIL IS SENT, RESET ALL THE VARIABLES FOR THE NEXT ITERATION SELECT @iCurLine = 1 SELECT @Line2 = '' SELECT @Line3 = '' SELECT @Line4 = '' SELECT @Line5 = '' SELECT @Line6 = '' SELECT @Line7 = '' SELECT @Line8 = '' SELECT @Line9 = '' SELECT @Line10 = '' SELECT @NewMessage = 0 END --ADD THE DATA TO THE LINES TO BE INSERTED FOR MAIL IF @iCurLine <= 3 SELECT @Line0 = @txtMsg if @iCurLine = 1 BEGIN SELECT @Line1 = @Line0 END if @iCurLine = 2 BEGIN SELECT @Line2 = @Line0 END if @iCurLine =3 BEGIN SELECT @Line3 = @Line0 END if @iCurLine =4 BEGIN SELECT @Line4 = @Line0 END if @iCurLine =5 BEGIN SELECT @Line5 = @Line0 END if @iCurLine =6 BEGIN SELECT @Line6 = @Line0 END if @iCurLine =7 BEGIN SELECT @Line7 = @Line0 END if @iCurLine =8 BEGIN SELECT @Line8 = @Line0 END if @iCurLine =9 BEGIN SELECT @Line9 = @Line0 END if @iCurLine =10 BEGIN SELECT @Line10 = @Line0 END -- INCREMENT THE COUNTERS AFTER EACH READ SELECT @iCurLine = @iCurLine + 1 SELECT @iLineCounter = @iLineCounter + 1 SELECT @Line0 = '' -- FETCH NEXT RECORD Fetch NEXT FROM Report INTO @txtMsg, @tCapUSD, @SecurityID, @ComponentDesc END -- WHEN THE LAST FETCH IS DONE AND THE DATA IS WRITTEN TO THE LINE VARIABLES -- THE CURSOR COMES TO THIS PLACE AND TRIES FOR THE NEXT FETCH, AT WHICH POINT -- IT EXITS THE LOOP WITHOUT POSTING THE MAIL MESSAGE. -- SO WE HAVE TO EXPLICITELY POST THE MAIL MESSAGE AGAIN BEFORE IT TRIES TO -- DO THE EOF FETCH. EXEC @BatchID = IB_PostMailMessageByID @BatchID = @BatchID , @Source = @USource , @Sender = 'dbo' , @RecipientListID = @RecipientListID , @Subject = @Subject , @NewMessage = 0 , @Line1 = @Line1 , @Line2 = @Line2 , @Line3 = @Line3 , @Line4 = @Line4 , @Line5 = @Line5 , @Line6 = @Line6 , @Line7 = @Line7 , @Line8 = @Line8 , @Line9 &nb
View Replies !
View Related
Configuring Mail For SQL Server Agent - Problem With Exchange And Outlook On Same Machine?
I would like to configure e-mail alerts on my SQL Server 2000 box.However, we also run Exchange on the same machine. I've been told therecould be conflicts/issues having Outlook on the same machine asExchange; and apparently, one needs Outlook to configure a mail profilefor SQL Server Agent.Is there, in fact, anything to worry about? If so, are there anywork-arounds beside moving Exchange to another server? (we've only gotone server, so this is not an option for us at this time).Thanks.- Dana
View Replies !
View Related
Error With SQL Server After Trying To Download Outlook 2003 Business Contact Manager
I downloaded Business Contract Manager "Update" from the Microsoft website not realizing that this was the entire Business Contact program, which I already had. I thought I was getting only an "update" to an existing Microsoft Small Business Office 2003 Suite program. After downloading, I discovered by entire existing business management database was wiped out. When I performed a System Restore back a few days, it did not recover my Business Contact Management program at all, nor did it restore my Business Contact Management database. Instead, it left me with this error message: "Your SQL Server installation is either corrupt or has been tampered with (Could not open SQLEVN70.RLL). Please uninstall then re-run setup to correct this problem." Now when I open my Outlook 2003 email program, I get this same message each time. Can someone help me understand what happened here and how to fix it?
View Replies !
View Related
Import Data From MS Access Databases To SQL Server 2000 Using The DTS Import/Export
I am attempting to import data from Microsoft Access databases to SQL Server 2000 using the DTS Import/Export Wizard. I have a few errors. Error at Destination for Row number 1. Errors encountered so far in this task: 1. Insert error column 152 ('ViewMentalTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow. Insert error column 150 ('VRptTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow. Insert error column 147 ('ViewAppTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow. Insert error column 144 ('VPreTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow. Insert error column 15 ('Time', DBTYPE_DBTIMESTAMP), status 6: Data overflow. Invalid character value for cast specification. Invalid character value for cast specification. Invalid character value for cast specification. Invalid character value for cast specification. Invalid character value for cast specification. Could you please look into this and guide me Thanks in advance venkatesh imtesh@gmail.com
View Replies !
View Related
Error Trying To Import MS Access 2003 Database Via SQL Server Import And Export Wizard - Too Many Sessions Already Active
I am trying to simplify a query given to me by one of my collegues written using the query designer of Access. Looking at the query there seem to be some syntax differences, so to see if this was the case I thought I would import the database to my SQL Server Developer edition. I tried to start the wizard from within SQL Server Management Studio Express as shown in one of the articles on MSDN which did not work, but the manual method also suggested did work. Trouble is that it gets most of the way through the import until it spews forth the following error messages: - Prepare for Execute (Error) Messages Error 0xc0202009: {332B4EB1-AF51-4FFF-A3C9-3AEE594FCB11}: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Could not start session. Too many sessions already active.". (SQL Server Import and Export Wizard) Error 0xc020801c: Data Flow Task: The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009. (SQL Server Import and Export Wizard) Error 0xc004701a: Data Flow Task: component "Source 33 - ATable" (2065) failed the pre-execute phase and returned error code 0xC020801C. (SQL Server Import and Export Wizard). There does not seem to be any method of specifying a number of sessions, so I don't see how to get round the problem. Does anyone know how I can get the import to work?
View Replies !
View Related
ReportServer.asmx Contacts Web Service To Retrieve Dataset As ANONYMOUS, Report.asmx Does Not
Dear SQL Server Reporting Services gurus, Before I begin describing our problem, let me first start off with a description of our environment and current configuration. Background/Configuration Specs We have SQL Server Reporting Services running on a Microsoft Windows Server 2003, Standard Edition, Service Pack 1 server. It is configured so that the Reports and ReportServer virtual directories run under a sql server domain account. The datasets for our reports are xml datasets returned from calling a web service on a second IIS server, Microsoft Windows Server 2003, Standard Edition, Service Pack 1. The web service runs under a service account and is not set to impersonate the user. The web service contacts a database located on the same server as reporting services to retrieve the data. So, it should receive the request, login to the database it is trying to access using the service account, and return the dataset. We are programatically accessing reports via a client application, specifying the virtual directory via the reportserver url (e.g. http:\hostname\reportserver\virtual directory path\report name). Kerberos is enabled on both the sql box and the iis box with constrained delegation allow the sql account access to the iis box. Problem When I try to browse to the report from Report Manager in IE, (http:\hostname\Reports\...etc) I am able to successfully view the report. When I try to view the report in the client app, (http:\hostname\reportserver\...etc.) the report fails. Looking at the iis logs, it appears that in the first case, the web service is receiving the request from the sql server domain account. In the second case, it appears that the web service is receiving the request from an anonymous login. Questions What exactly is the difference between rendering/viewing a report via ReportManager versus programatically via ReportServer? Is there any configuration we need to be aware of when configuring ReportServer? Any help you can provide would be very much appreciated. Thanks, prettybrneyes81
View Replies !
View Related
Import Into More Than 1 Table
Hi everyone, im trying to import data using a query...how ever i can only insert data into one table, and i need to insert data into many...this is at the part where you map the fields... is there a way to do this? or something similar? Thanks, Justin
View Replies !
View Related
Outlook 97 And SQL 7.0
On our SQL 7.0 servers we have always used Outlook 97 as our mail client and until last week we've had no issues with this setup. A week ago a number of the servers with this set up started hanging on jobs with mail statments using xp_sendmail and the only solution was to reboot the server. All the servers use the same NT account and the same mail box for the mail. I've talked with our Exchange guys and they say that nothing has changed on the mail server. I found a Q article (Q315886) that suggests starting sql as an application not a service to see if pop ups could be causing the problem. Well no pop ups. I installed Outlook 2000 on the boxes and that seems to have fixed it. Or at least no problems today with those servers. Has anyone seen this before or have any idea what might be the cause of it? thanks Donna
View Replies !
View Related
|
TRACKER
