Answer Questions
Aditya Ganty SSMS Login failure when trying to connect to SQL 2000 server using SQL authentication
Hello all, Have a strange problem trying to get SQL Server Management Studio to connect to several SQL 2000 servers, all running with SQL Authentication. From SSMS, if I enter the server name, choose SQL Authentication and enter the username and password, the login fails with "Login failed for user 'validuser'. (Microsoft SQL Server, Error: 18456)". On the SQL 2000 server itself, the event log only shows the following when th ...Show All
Newkid SQL Agent Failing when trying to run my SSIS Package
My SQL Agent was working fine. Now when I try to run it, it failes when trying to run my SSIS package. I looked in the logs, and job history, no luck in finding any critical errors. My SSIS package runs fine through VS 2005 in debug mode. Here are the only errors: 01/04/2006 09:53:48,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect 01/04/2006 09:53:48,,Warning,[260] Unable ...Show All
Frank Corrao AdventureWorksDW database
I can not find the databases and samples for SSIS that are mentioned in the tutorial on my disks, or DVDs. Please tell me where I may get them from Did you install them from SQL Server setup -jamie Installing SQL Server copies the Samples off the CD, but doesn't install them. Start > All Programs > Microsoft SQL Server 2005 > Documentation and Tutorials > Samples > Microsoft ...Show All
benjaminm Various data access issues with June CTP
Hi, June CTP is much better than April CTP, I can get a little farther than before with data access however there are still problems. - Converting 2000 database with the wizard. now creates the database and move some data however the process times-out even with a little database - migrating DTS2000 packages, half of them now gets migrated but half of the migrated packages are unusable. it would be nice if the wizard would automati ...Show All
pelazem Asynchronous Outputs on Script Component Best practice
If you have an output that is not synchronous with the input what is the best way of processing the data. I am currently using a generic queue, and a custom class. I am creating an instance of the class in the ProcessINputRow and then adding it to the Queue. The CreateNewOutputRows Dequeues the class instances and creates buffer rows. Is there a better solution ArrayList I've seen asynch components that cache data in an ArrayLi ...Show All
Nissan Problem attaching a database using user instancing
I have a database that I am distributing with my C# 2.0 application as an .mdf file meant to be attached at run time. I created the database on a copy of SQL 2005 Developer edition, and detach it and copy it to the test machine for testing. It has recently been complaining about not finding the .ldf file. According to the article here: http://msdn2.microsoft.com/en-us/library/ms165716.aspx I am not supposed to distribute the ldf. The only way I ...Show All
igorbaITALY Testing ODBC connection manager
I am testing out the ODBC connection manager, as part of my beta testing from my company. I created a new conn manager on the palate (dsn pointing to local sql server). But I am not sure how this one can be used. I can not use any of the Data flow sources which can use this ODBC connection manager. Using the said conn manager in a Datareader source shows up the error "Can not acquire a managed connection from the run-time connection m ...Show All
Eric Lewandowski Fuzzy Grouping errors
Hi - we have been evaluating using Fuzzy Grouping and Lookup for maintaining our large list of customer records. Initial testing with Grouping on about 300K records went great but now with a larger sample of 7.3 million records we are running into problems. It doesn't appear to be system limitation - the index is built reasonably quickly and without errors but when it starts the matching we get these errors: [Fuzzy ...Show All
Senthil Kumar N.H cursor usage
hi guys i have a table that contains a tremendous amount of row. i have written a stored procedure that takes a summary of that information and updates it's master table as well as another table. the problem is it takes very long to do. is what i am doing correct or is there a better way. here is the source CREATE PROCEDURE update_cvrbatches AS declare @code varchar(25),@type varchar(3),@batchno varchar(10),@batchqty Float,@issued floa ...Show All
Bunchito Is Ad hoc reporting compatible with Web Applications
We are planning to imlement ad hoc reports in out application but somebody said that, it supports only Windows based applications. Can we access Report Builder over the internet can anybody pull me out of this question Luis, Thanks for the reply. i think Report builder is a windows form and how a remote client can access it will it be downloaded to his system automatically or he has to install something Thanks & Regards, Srikanth Ba ...Show All
Gabor Halasz SSIS Custom Component DerivedColumn programmatically problems
dear experts, i'm trying to build a package programmatically from client c# application. I'm working to create three dataflow components: - OleDB Source - Derived Column Transformations - OleDb Destination. My package works good, but i have several problems when insert an expression as Value of an IDTSCustomPropriety90 object, like this one: [LEN](#firsname.lineageID) > 5 <<if true>> : <<if false>> Simple expressio ...Show All
Daniel Rieck UserName Error in SQL Server 2000
Hi all, When i happen to install Ms-Sql Server 2000 in Windows xp it throws an error as The Logon account cannot be validated for Sql Server Service .Verify that Username and Password are Incorrect.Logon attempt Failed. This is the Error i get. can anyone help out of it. Iam running short of time. can anyone do this ...Show All
markello NameColumn
Hi all, I've got a little problem. In one of my dimensions I have a date value. This field ddate has as NameColumn my source field, but with datatype wchar. When I change it to date datatype he gives me an error. Now the wchar is no problem, till I want ot use this field in a report in reporting services. When I browse my dimension in SSAS I see 2005-02-25. When I put it in my report I see: 2005-02-25 0:00:00:00. What I want to ...Show All
TimStspry ClickOne Deployment and SQL Server Express
This is probably a dumb question. But if I embed a SQL Server Express database into my project and then attempt to deploy it via ClickOnce, will I be able to access that database using the SQL Server Management Studio Express CTP if it is installed on the same machine as the client that my app would be installed Hi, I encounter a problem when trying to deploy my project (VB2005 Express & SQL2005 Express ...Show All
Jocke Intellibis XML String into ADO Recordset
The server returns an answer to a query as an XML String. I load the XML String into a Recordset on the win32 client side. as hr = pXMLDom.CreateInstance(__uuidof(DOMDocument30)); pXMLDom->loadXML(_bstr_t(lpwszStream)); m_Rec.CreateInstance(__uuidof(ADODB::Recordset)); m_Rec->Open(pXMLDom.GetInterfacePtr(),vtMissing,ADODB::adOpenStatic,ADODB::adLockReadOnly,ADODB::adCmdFile); But thie open operation for 1000 records takes 2 seconds. I th ...Show All