Answer Questions

• Quack! Object reference not set to instance of the object while trying to sync.

  Hi, I am trying to configure web syncronization using the wizard for a merge replication. However when I am trying to add users (in authentication mode), I get an exception "Object reference not set to instance of the object ". Please let me know if you have any inputs on this. It will be highly appreciated.. Can you tell what OS you are using and what SP Has it worked in the past On clicking which button do you see this error Some more details will help us to troubleshoot the problem. I was using an admin account while configuring the wizard. Also was running the wizard and configuring the local server (same box). I was using windows server 2003 sp1. How can I setup permis ...Show All

• FM_AX Memory release

  I am using SQL Server 2000 SE. When I used my application, the SQL server memory go on increasing & it will never come down. Application runs very slowly. Can anybody suggest how to release memory from sql server. Thanks in advance. Hi Michael, thank you very much. I'm a SQL new programmer. I want to ask more. Suppose some users use my application concurrently. They run different reports and these reports use almost server memory. I saw this in server. After that these users close reports. I watch memory in server, it isn't released. If new report runs, in this case SQL sever/OS will automatically reallocate memory for new task-report. SQL server/OS work this way, isn't it Thanks. ...Show All

• slugonamission Displaying Multi parameter info : Report builder

  Hi All, Is there is any way to display the User selected parameter information if the parameter is multiselect I was able to display if the parameter is single valued but if it is multivalued (list), i was not able to . Any help is greatly appreciated. Regards, Can you elaborate your question Regards, Ramesh KS Here is the sample code =String.Format("Organization Name: {0}",Join(Parameters!OrganizationName.Value,";")) Thanks, Bala Hi. Thanks a lot , it worked. HI Bala_SSRS: Could You Post Your Sources for a code sample ...Show All

• vua_rua Login error after automatic failover

  I have setup a mirror configuration with a witness to be able to use the automatic failover. The principal is DBSP01, the mirror is DBSP02 and the witness is DBSP03. I have an application running an DBCP01. When the mirroring is working, the application can connect to the database on DBSP01. I disconnect dbsp01 from the network, so that DBSP02 becomes the principal. When I try to connect the application to the database on DBSP02, the login fails. Whithout the mirroring I was able to logon to DBSP02, but as soon as it is part of the mirroring, I'm not able to connect to it anymore, whatever the state of the database is. What could be the problem Can anybody help Remco I found the problem. The services of SQL were not running unde ...Show All

• &#169&#59; Ţĩмό Şąļσмāĸ Should IsSorted metadata be stored in raw files

  Hello, I have an input into a raw file destination that has IsSorted=TRUE. Any output from a raw file source that uses that raw file will have IsSorted=FALSE.   So, a question for Microsoft. Is it a legitimate request to ask that the IsSorted and SortKey metadata be stored in a raw file If so I shall raise it at Connect. -Jamie   Hiya Jeff, Jeff Bernhardt wrote: hmm. must have missed those. not that it helps you too much Jamie, but the IsSorted metadata was added to the pipeline late in development, after the raw files (and the tests for the raw files) were written. Fair enough! Jeff Bernhardt wrote: ...Show All

• 1Deepthi "Synchronize Connection Strings" Dialog box with XML Config file

  Hello, This has been happening to me since I started using Configuration files.  I use one XML config file that stores Machine Specific settings and one connection string to my Metadata database.  The problem is the database connection. When I set the conection in the Configuation file, save, close and reopen the package, a dialog box opens with the title "Synchronize Connection Strings". To reproduce the problem: 1. Ceate New SSIS Project 2. New Data Source Localhost.Adventureworks 3. In Package.dtsx  create an New Connection from Data Source... 4. Choose AdventureWorks 5. Save Package 6. Close Package 7. Open Package There is no problem at this point. 8. Enable Package Configurations 9. Create a new XML C ...Show All

• talk2uman Help with a special stored procedure

  Hi I have a table there have a primary key, this value have i also in another table as a forreignkey, so good so far. Here it is If the number in may primarykey in table 1 , dosn't exits in table 2 then delete records in table 1 I have made this in a ASP page with a view there list all records where the forreignkey in table 2 are NULL and then delte all records in table one Can i made this as a stored procedure regards alvin I try to explain and maybe you can help In table 1 i have a ID theis ID can bee many times in table 2 Table 2 have also a int there connect to table3 all works fine When a date field in table3 is over current date then i delete the record in table And when it does this it ...Show All

• dtlinker SQL Server Error 15404

  I am trying to learn replication and using Agent jobs while attached to my corporate domain. Trying to use my personal domain account to run jobs or replication, I keep getting: SQL Server Error 15404, Could not obtain information about Windows NT group\user 'MyName\MyDomain', error code 0x5 [SQLSTATE 42000] (ConnIsLoginSysAdmin) What might be preventing SQL Server from getting my account information from the domain Group ploicy Thanks in advance, Richard Hi, Are you running SQL server services with an account that is a member of the domain Has the SQL server joined the domain Moving to replication forum. Are distributor/publisher/subscriber SQL server instance on ...Show All

• eldiener Can't change sourcetable with DSO (dsoPartitionNew.SourceTable) SQL2000

  I use the standard code for creating new partitions with dmo: Everything seems fine with the name of the partition and the slice, but the sourcetable doesn't change. Tried both with and without the double quotes strPartitionFactTable = Chr(34) & "dbo" & Chr(34) & "." & Chr(34) & "New_Accounts_Month_200612"& Chr(34) msgbox strPartitionFactTable and strPartitionFactTable = "New_Accounts_Month_200612" But still dsoPartitionNew.SourceTable = _ sLQuote & strPartitionFactTable & sRQuote msgbox dsoPartitionNew.SourceTable Returns the the template table -> New_Accounts_Month_Template Can someone tell me what goes wrong . It is executed as ...Show All

• Joshizzle Import dedicated Records from a Flatfile to a DB

  Hello all I got a Problem when I try to store Data from a Flatfile to a DB. The following Error appears in the Progress Control: An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK_Products_1'. Cannot insert duplicate key in object 'dbo.Products'.". I have a Flat File Source, and would like to store the needed records in a DB. In Column 0 in the Flatfile I have multiple Entries with equal Values. In the DB this Column is set as Primary Key and can only have one Record with the same Value in this Column. How can I read out (or store) only one Record with the same Value from the Flatfile to store it in t ...Show All

• olgaF EventHandlers firing events

  I ran into a pretty bizzare behavior in SSIS: I am trying to set up a package with a built-in auditing. It has a OnPreExecute, OnPostExecute and OnError event handlers. I am trying to record when the package starts, completes, and the completion status. Each one of these event handlers has a script task that does the logging. I put in debug message boxes into each event handler script to understand what goes on. So here's the sequence of events: 1. When starting the package the OnPreExecute event fires. Right away it fires the second time. I'm guessing what happens here is the script task within the event handler fires its own OnPreExecute event - that's how the first message really pops up. The second message is generated by the act ...Show All

• SweptSquash Log shipping

  Can stand by server in log shipping host production database used by other applications if yes, what is the effect of log shipping on other databases There is a certain amount of load on the system due to the work involved in applying the transaction logs, but this should not be overwhelming. Obviously this all depends on the specifics of your configuration and workload. Other than competition for system resources, there should be no issues with this, and it is a common setup. I am not planning to use the database for which i am log shipping. The server i am planning to use as secondary server in log shipping already has production databases (not involved in log shipping). Will log shippi ...Show All

• fcatacutan Cant install SQL Server 2005 on vista..

  Ok ive tried looking everywhere for a solution but i just cant find one... please help me I need to install SQL Server 2005 on Vista, but i have issues. I have installed IIS and its checked in the pre-installation checklist, and the only thing with an exclamation point is the OS which is to be expected. The issue im having is that when i get to the screen to select the features/components i want to install, they are all disabled apart from "Workstation components, Books online etc..." Where am i going wrong with this.. I know i need the services pack to install reporting services, but i cant install anything at this point. A walkthrough or something would really help... P.S Im running on Vista Ultimate and ...Show All

• boston_sql92 How to display data

  Hi, I have a question I have a table Call “Employee” Job_Title ---------------- Administrator MarkettingMgr HR Manager Head Of IT SalesRep AccountingManager AdminManager Now I need to write a query from SQL server to get a list like this Job_Title Job_Title ------------ -------------- Administrator MarkettingMgr HR Manager Head Of IT SalesRep AccountingManager AdminManager Like each 2 rows after one new row in a new view How do I do this using SQL Server 2000 Sujith Thanks very much 4 the help,now i  understood the concept,nice work! cheers sujithf   I d ...Show All

• The_Individual For Each File Enumerator Missing

    Hi, I have been trying to find a way to add the File Enumerator Collection option to my version of BIS. Newer versions have a FileEnumerator and I can't seem to find that option. Can anyone help     found the answer to this... I had to remove the integration services component from sql server. and reinstall. ...Show All