Answer Questions

• psmanii SSIS tasks execution order problem

  Hi, I'm facing a problem with my SSIS package regarding the execution order of tasks. I am using my package for the purpose of loading data from XML to staging tables in the database, and have a loop to process all XML files. As a precondition to the loading action itself, I am running a stored procedure against the database (using the ExecuteSQL task) to check whether all staging tables are empty. The output parameter of that stored proce ...Show All

• Dato SQL Server 2005 SP1 Webchat on March 22nd 9:00 am PST

  We will be hosting a public web chat discussion: March 22 nd 9:00 – 10:00 am PST about the March CTP of SP1. It is the customers’ opportunity to engage with the dev team and provide feedback and ask questions. Strong participation from customers will act as a motivator for stronger participation by the dev team and will increase their interest in having these in the future, so we urge you to join and participate. For more information ...Show All

• baty Access Permissions on server scoped objects for login

  We are having problems with the response times from UPS WorldShip after switching from SQL Server 2000 to 2005. I think that the problem can be fixed from the database end by setting the permissions correctly for the user/role/schema that is being used by WorldShip to connect to the server but, I'm not sure how to do it. The Setup Client UPS WorldShip 8.0 running on XP Pro SP2 Connecting via Sql Native Client via SQL Server Login Connec ...Show All

• JAIPAL Single Parameter/Multiple ORs

  Trying to construct a SELECT statement in my dataset that looks something like this: SELECT column1, column2 FROM table WHERE (column1 = @parameter) AND (column3 > 0 OR column4 > 0 OR column5 >0) Report Designer re-constructs this as: SELECT column1, column2 FROM table WHERE (column1 = @parameter AND column3 > 0) OR (column1 = @parameter AND column4 > 0) OR (column1 = @parameter AND column5 > 0) and as a result, the ...Show All

• BonnieF SSIS will not start after SQL Server 2005 SP1 upgrade

  Hi guys, I have experienced a problem with a SQL Server 2005 SP1 upgrade, where hotfix.exe reported an error during the SSIS component upgrade, and then the SSIS service would not start back up. I have since attempted an additional SP1 upgrade on the server, which completed successfully, however the SSIS service still will not start. The server is running Windows Server 2003 Standard Edition SP1 with SQL Server 2005 Standard Edition (x86), wh ...Show All

• birima Slowly Changing Dimension Task Bug???? Got it working.

  I am working with the latest build of SQL Server 2005. VS 2005 8.0.50215.44 (beta2.050215-4400) SSIS version 9.00.1187.00 I had a package that was working fine while using the Slowly Changing Dimension Task. However, with the new version the Historical Attribute for the type II change does not work anymore. I’ve created a very simple test and while running the same package twice, without make any changes to the staging table, I ended up with d ...Show All

• Bideldotnet Add-In Support For Management Studio

  Is there add-in support for SQL Server 2005 Management Studio I want to build a script management add-in that is callable from the popup menu of the query window. I haven't been able to find anything on building add-ins for Management Studio on MSDN or the web. Did I miss something Or is SDK/add-in support not available yet for Mangement Studio Thanks. - Grant Grant, We do not current support third-party add-ins in Mana ...Show All

• cinnagingercat Microsoft.SqlServer.Management.Trace.TraceServer - Examples ?

  I'm trying to find ANY examples of using the Microsoft.SqlServer.Management.Trace namespace. What I'm looking for is an example of being able to create and initialise a new trace, haing this processed on the Server, and then initializes some sort of traceReader against this. e.g the equivalent of:    MyTraceConnection = new Something ("localhost");    MyTrace = new SqlTrace (CaptureTSQL || CaptureLogonEvent || CaptureLogoutEv ...Show All

• a1call Problems installing SQL Server 2005 SP 1

  SQL Server installation fails with the message: "A recently applied update, KB913090 failed to install" The last executed task was: Integration Service The last installation message was: Checking for lock files via Windows installer sqlrun_tolls.msp Here is my MSP file - I am having a similar issue.... === Verbose logging started: 4/19/2006 23:51:20 Build type: SHIP UNICODE 3.01.4000.2435 Calling proce ...Show All

• mcgyver74 Data Export Wizard - Drop Table option not available

  I was using the Export Data Wizard to transfer my data to hosting provider, however the option to drop detsination table first is greyed out. Any Idea Als Why do I need to do in for each table by clicking Edit Is there a global setting like in the old Wizard   Does anyone have a solution for this As soon as the database name is the same this option is disabled Is this a bug I have full permissions so it can't be a security issue. ...Show All

• nokushi0 SQL Server Authentication + SSL

  Hi! I noticed that with SSL authentication (On SQL Server 2005), the SSL handshake is kind of "truncated" : * Certificate is not sent from Server to client; (Which may be OK according to TLS) * The client does not send Client-Key-Exchange message (Which is not conforming to TLS) This is clearly evident from tcpdump output. However with Windows authentication, the client -server handshake is "compatible" with ...Show All

• Andrei Plinda SQL Server 2005 on Windows XP Pro

  I'm running on a Windows Xp Pro system and need to install sql server 2005. I will be doing development as well as having the need to use the reporting services. What version of sql server 2005 should I install I looked for sql server 2005 Developer edition and was unable to find it in the download section from MS. Any pointers here would be appreciated. thanks. I agree that Developer Edition is one of t ...Show All

• Brian Kuhn How to edit a subquery in query designer

  Hello! Is it possible to edit a subquery in the diagram and grid pane,without using the texteditor in the SQL pane The way i do it now (hopefully not the best way): 1 Create a tmp dataset with sql statement for the subquery 2 Rightclick in the original dataset and "Add a new derived tables" 4 Paste the sql code from tmp query to the original dataset. After linking the original query with many subquerys, it is difficult to c ...Show All

• chadr - msft SQL Server 2005 JDBC Driver 1.0 error in using XA datasource

  We are in the process of configuring a j2ee application with SQL Server 2005. We have downloaded the new version of SQL Server 2005 Java Database Connectivity (JDBC) Driver 1.0. We are having some issues in getting it to work using the XA datasource. Description of the error is as follows: javax.transaction.xa.XAException: java.sql.SQLException: Failed to create the XA control connection. Error: Could not find stored procedure 'maste ...Show All

• Prashant Utekar Rounding number with ending equals 5

  Hi, How do I round when number is ending with 5 for example: When the number next to number 5 is an even number 24.5 = 24.0 round down 0.245 = .24 round down 1265 = 1260 round down when the number next to number 5 is an odd number 23.5 = 24.0 round up 0.235 = .24 round up 1755 = 1760 round up Thanks in advance! You can use the round function.   ...Show All