Answer Questions

• nabe Changing SSIS property defaults

  To make certain SSIS features work there are many properties that need to be set over and over for most containers in the package. For example with Checkpoint\Restart, you need to set (in most cases) all of the tasks' FailPackageOnFailure to True. If you miss one, the package may not restart properly and you might never know. There are other situations where as a development team we want certain properties to be usually set the same but differently from the SSIS default. Is there a way to control the defaults that the SSIS IDE uses I remember back in classic VB that if you wanted to change the defaults of a bare form you could create a template form adjusted the way you like and put it in a templates folder. Then new forms added t ...Show All

• Friendly Dog uncorect calculation

  Hi .I just got a serious problem.the problem is I have a table with to field as money and as real.so I try to have expresion like * but I get uncorrect answer . for eaxample if is 1805957.1429 and is 110 the answer will be 1.986553E+08 and I try to convert to meney it comes to 198655280.00 what should I do  smilleys in the question . please edit hi dear thanks for ur help. finaly I didn't understand that if I want multiple quantity (float or real) by price(money) what should I do and what kind of variable should be defined to keep resault You may not want to use money actually for representing currency values but use decimal/numeric instead ...Show All

• Rod Yager Thanks a lot i was able to connect

  TITLE: Connect to Server I have downloaded the sql server express edition 2005 .When i open Sql Server Management Studio i am unable to connect this is the error message Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456) hi, are you sure this is the exact exception you are reported with, or does the error message say "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection" if this is the case, SQLExpress install by default disabling standard SQL Server authenticated connections.. only WinNT trusted connections will be available.. you can thus connect via a local Windows account member of the local\administrators group, as this group is by default granted logi ...Show All

• Jorne Calling stored procs based on a code table

  I need to run stored procs based on a list in a code table. In other words, it reads the name of a stored proc from a table and runs it and does this for all the rows in the table. I think the ForEach loop container will do what I need and there is an ADO enumerator option but the documentation does not tell you how to use this. From what I can tell, you need to get a dataset into an SSIS variable first and then you plug the variable name into the ForEach ADO enumerator. Is that correct If so, can someone tell me how to get a dataset into a variable Thanks Perhaps kirk's blog will help you: http://sqljunkies.com/WebLog/knight_reign/archive/2005/03/25/9588.aspx ...Show All

• mNilysg NC file into sql file

  Hi, I was wondering if its possible to change a .nc file into a .sql file If yes, what program should I use ...Show All

• Osiris43 Can't see the SQL Server Express Instance on SQL Browser

  Hi All, I am using SQL Server Express to connect to the network using VPN on a local machine. I have done the following.. a.) Enabled the remote connections for the Express Instance and rebooted the machine. b.) Connected to the machine with Express Edition locally and can also connect other SQL Server instances from it to verify connectivity. c.) Yes, SQL Browser Service is running. d.) Firewall is not turned on, so I do not have to configure any exceptions. Now here is the big problem: When I browse for SQL Servers on the network the machine does not show up on the list, i.e "macinename\SQLExpress". I had uninstalled and reinstalled the Express edition and rebooted the machine several times with no luck on t ...Show All

• kennm Common Generation Watermark error for Merge Replication

  Hello, We have a sqlexpress subscriber that is receiving the error below. SQL Server 2005 We have tried: Generate new snapshot. Reinitialize the subscription. Dropped the subscription. Reboot the web server box. Reboot the sql server box. Yet we still get the errors for these specific subscribers. Any ideas Error in replication monitor.... Error messages: The merge process failed because it detected a mismatch between the replication metadata of the two replicas, such that some changes could be lost leading to non-convergence. This could be due to the subscriber not having synchronized within the retention period, or because of one of the replicas being restored to a backup older than retention per ...Show All

• Nick Gravelyn This expression doesn't work.

  I'm trying to write an expression in a text box and the expression is as below. =IIF( Parameters!Days.Value >=0 and IsDate(Parameters!FromDate.Value)=True ,Format(DATEADD(DateInterval.Day,Cint(Parameters!Days.Value), Parameters!FromDate.Value ),"yyyy/MM/dd"),"") It works ok when Parameters!Days.Value >=0 and IsDate(Parameters!FromDate.Value)=True, but when Parameters!Days.Value =0 and Parameters!FromDate.Value is nothing (i.e. Parameters!FromDate.Value=""), it doesn't work and comes up with '#Error'. However, if I change the expression to the below, it works with the exact same parameters used in the above expression. it looks to me that RS doesn't want to deal with a tiny bit complexit ...Show All

• huynh xuan vinh Force Package Completion?

  Is there a way (during the Control Flow) to force a package to complete successfully when a specific condition is met Here is what I'm trying to do: A package will be scheduled to execute once a day The first thing it does is downloads Excel files from an FTP site. If there are no files to download, I don't want the package to fail, I simply want the package to stop (preventing the subsequent Data Flow tasks from executing), returning a successful completion. The reason, I need a successful completion is because I plan to have MOM monitor the Windows event logs, notifying us of any errors that this package logs. Brian.Nelson wrote: Is there a way (during the Control Flow) to f ...Show All

• flypp3r Cannot bulk load because the file could not be opened. Operating system error code 5(Access is denied.).

  I am facing a issue with bulk upload on Test Server. Issue: When running Openrowset command from SQL server other that Test Server query runs fine when trying to run the same command from Test Server it gives error. Msg 4861, Level 16, State 1, Line 1 Cannot bulk load because the file " \\ServerName\input\FileName.csv " could not be opened. Operating system error code 5(Access is denied.). For example: If the command is run from System A connecting to SQL Server instance on Test Server Test Server it gives this error. If the same command with same rights is run from any other SQL server instance say Dev1 its running fine. If the command is run from Test Server connecting to any SQL Server instance includin ...Show All

• Mahesh kumara SQL Server 2005 SP2 Fails

  I have a Windows Server 2003 Enterprise Edition SP1 with a couple of SQL Server 2000 instances on it and two SQL Server 2005 instances on it.  I tried to install SQL Server 2005 SP1, but kept getting failures.  I saw that SP2 fixed some of the issues with installation issues that SP1 had.  So, I tried to install it.  Some of the smaller components install successfully (VSS Writer, Backward Compatibility, SQLXML4, MSXML 6.0 Parser, Native Client, Support Files), but all of the base services fail to install (Database services, Reporting Services failed for two different instances).  I've downloaded the SP2 from the Microsoft site local to that server and install from there.  I don't have space problems on ...Show All

• YoungEngineer Word Wrap database query results

  In Visual Studio 2005, when you are looking at the results of a database query, or table (show table data) etc., how can you make the results field values wrap like we use to be able to do in VS 2003 and in Visual Interdev. If the field values were longer then what was display in the grid output results, you could expand the column width and row height and the field values would wrap to fit. If I try to do the same thing in VS 2005 or in sql enterprise manager 2005 the field values don't wrap, they remain displayed in one long line and they just get cut off after a specific number of characters. What tool are you using, and what output did you choose If you're in grid mode in SQL Server Managemen ...Show All

• Eric Brinkerink sqlxml error

  I have a number of apps which use SQLXML 4.0 Bulk Load. But, in a new program I am getting an error when I attempt to execute the following statement. SQLXMLBULKLOADLib. SQLXMLBulkLoad4Class bulkLoadObject = new SQLXMLBULKLOADLib. SQLXMLBulkLoad4Class (); The error is "Unable to cast COM object of type 'SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class' to interface type 'SQLXMLBULKLOADLib.ISQLXMLBulkLoad4'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{88465BA7-AEEE-49A1-9499-4416287A0160}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE))." The same statement executes fine in other apps on th ...Show All

• laserbeam Cannot open user default database, login fails

  hi: I got the problem, which lots of people might encounter before. In my case, I use login control and sqlexpress to build a login page. when password & user name were entered. It gave me: "Cannot open user default database, login fails" The solution given by msdn is: SQL Server 2005 You can use the sqlcmd utility to change the default database in SQL Server 2005. To do this, follow these steps: 1. Click Start , click Run , type cmd , and then press ENTER. 2. Use one of the following methods, depending on the kind of authentication that the SQL Server login uses: ? If the SQL Server login uses Microsoft Windows authentication to connect to the instance, type the following at the command prompt, and then press ENTER: ...Show All

• NinetyNine howto set permissions on dimension data using AMO

  I need programmatically set permissions on CostCenter Dimension on Subregion Attribute. I have made saparate role for each subregion code. Now I want only to limit access for the roles to appropriate dimension data. All other data should be accessible for reading. I have found following piece of code on MSDN. This code fires an "Unexpected exception " on the last row of code (by the cubeperm update). All other code before works. Please, where is the problem Thanks a lot! martin DatabasePermission dbperm = mDatabase.DatabasePermissions.Add(myRole.ID); dbperm.Read = ReadAccess .Allowed; dbperm.Update(); CubePermission cubeperm = mCube.CubePermissions.Add(myRole.ID); cubeperm.Read = ReadAccess .A ...Show All