Answer Questions

• Jeff Lucovsky Need suggestion on loading a 50 million records table from Oracle

  All, I need to load a 50 million records table monthly. Any suggestion about the best/fast way to do it Thanks a lot All I tried today; it used 8 hours to load the data just from the Oracle table to the staging table on sql server 2005. It is unacceptable!!! There are must be a better way to do it. In the data flow, there is only an OLE DB source (from Oracle) ----> data conve ...Show All

• Amenti OLEDB question

  This may be a newbie question but here it goes.  I have SQL Server 2000 running on a windows server 2003 machine.  When i have my database local, on MSDE everything is fine.  But when i switch my code to move to the server, (after i've attached the database within the server) it tells me that server either does not exist or login failed.  Now here is my connection statement OleDbConnection m_conn; string connectionStrin ...Show All

• BigLad Redudancy for a Standalone SQL server

  Here is my Question... I have 3 server hardware and the whole purpose is to make one as a web server and another one a SQL server. The purpose of the 3rd server is purely a backup server, what that means is, in case if my web server nor my database server fails, I should be able to use the 3rd server as a backup. How do I achive this without using MS cluster service. I can use NLB for Web, but what about SQL server All I need to know ...Show All

• Merzhin Rounding Values

  Hi, How can I round a value to the next int number like all values > 1 and < 2 I need to round to 2 and on and on...to all numbers So If I have 2.1 it's 3 if I have 2.9 it's 3 ...and so on... Thanks Thanks.. It worked There is a built-in function: CEILING(). ...Show All

• poisonem XML record from SP

  There is a requirement to return a xml record using SP. The structure of the xml looks like below. <RNetOrderResponse_20 Version="2.0"> <RNetHeader> <ThisDocumentIdentifier>ORE41688745301004467924200605220825263-20060522T082502</ThisDocumentIdentifier> <ThisDocumentDateTime><DateTime DateTimeQualifier="On">Feb 24 2006 11:21AM</DateTime> </ThisDocumentDateTime> ...Show All

• tsensenbach Your SQL Server installation is either corrupt or has been tampered with...

  Hi I have installed SQLExpress. Whenever I boot my PC (XP Pro SP2)  I get the following error just prior to logon: "Your SQL Server installation is either corrupt or has been tampered with (Error generating instance ID from name). Please uninstall the re-run setup to correct this problem." I have now uninstalled and re-installed twice with no success. SQLExpress seems to be running fine, just this worrying message all the time. Any ...Show All

• SXUgomper Setting Report Data Source Credentials Programmatically?

  Hello, I've been working on an application that uploads an RDL to Reporting Services (through the SOAP webservice method CreateReport) programmatically. I'm having difficulty setting up the data source properties for my uploaded report. In particular the Data Source Credentials property. The datasource for my report doesn't require credentials. By default after I upload the report to Reporting Services, the Data Source Credentials propert ...Show All

• weaver2045 Where are the Graphs saved from Data Mining model viewer

  Hi, all here, I tried to find the graphs I saved from Data Mining Model Viewer, but where is it saved As we see from the mining model viewer we could save the graphs there by clicking the 'save graph' button, but where is the graph Really need help for that. Thank you very much in advance for any guidance and help for that. With best regards, Yours sincerely, I'm not sure - which viewers Are you trying the Decision T ...Show All

• David W Hart SQL Server Agent control

  I have a SSIS package that is scheduled to run at the same time every hour/day/whatever using SQL Server Agent. If the package fails then I don't want to run the package again until I've fixed the problem. For this reason i want to disable the agent job at the start of the package and then enable it again at the end. Has anyone done any work on controlling SQL Server Agent jobs from within an SSIS package How have you done it Any advi ...Show All

• Andreas Kyriacou 2005 SQL Reporting Service XML Data Source (WebService)

  Does anyone know how to ensure a WebService/WebMethod needs to be serialized to ensure is compatible with Reporting Services' new XML Data Source when passing parameters to the report. I have had success on using the Report Server WebService http://localhost/reportserver/reportservice2005.asmx and using the Query designer to pass the SoapAction call <Query><SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/rep ...Show All

• elixic Doing a data import using DTS Wizard in SQL Server 2005 - being efficient with 5 flat files

  I just spent some time working out how to do a seemingly simple task. I’m sharing the steps I took to do this in hopes it saves other SQL Server 2005 users (especially newbies like myself) time. My original question posed on several SQL newsgroups was based on this goal: I'm importing a series of 5 flat files (all with same file layout) into a database on one of the SQL Servers we have using SQL Server 2005 (SQL Server Manag ...Show All

• Tekzel Error message "Interface not registered"

  Hi  I got the following error message when I make a new integration service project  Failed to save package file "C:\Documents and Settings\Administrator\Local Settings\Temp\1\tmp2B.tmp" with error 0x80040155 "Interface not registered". Can someone help Me yes it works for me too. Thanks. Hi, I have the exact same problem but it is when I try to burn a cd using Win Media Player 10. I tried registering the .dll's, but ...Show All

• Tibi Persistent BI Studio Crashes

  I am wondering if anyone has experienced the same persistent BI Studio crashes that I have. I can get the BI Studio to crash by simply opening a report and toggling back and forth on the Data/Layout/Preview tabs. Here are the steps: Launch BI Studio Open Solution Open Report in designer (layout tab defaulted) Click Preview tab, then View Report button Toggle tab to Layout, then Data, then back to Layout, then Preview Boom...Visual Studi ...Show All

• Asanga Manage Compatability : SQL Server 2005 Management Studio

  Hello Everyone, I have a Web Host which uses SQL Server 2000. I can use their interface and make tables and procedures, but I wanted to use some sort of graphical tool...Is it possible to use SQL Server 2005 Studio with SQL 2000. I'm really new to SQL Server as my past experience is largely with Oracle....and there for the same purpose I can use SQL Navigator or TOAD.... IF SQL Server 2005 Studio wont work can someone please suggest a t ...Show All

• airin Default Schema and Synonyms

  database0.User1 has a default schema of database0.Schema1 and also belongs to database1. I have the following synonyms in database0: Schema1.Customers - points to database1.dbo.customers dbo.Customers - point to database2.dbo.customers User1 has execute rights in database0. I have a stored procedure in database0 that says select * from Customers I thought since User1's default schema was Schema1, it would automatically see ...Show All