Answer Questions

• cynny Stored Proc Output Parameter to a Variable

  I'm trying to call a stored procedure in an Execute SQL task which has several parameters. Four of the parameters are input from package variables. A fifth parameter is an output parameter and its result needs to be saved to a package variable. Here is the entirety of the SQL in the SQLStatement property: EXEC log_ItemAdd @Destination = 'isMedicalClaim', @ImportJobId = , @Started = NULL, @Status = 1, @FileType = , @FileName = , @FilePath = , ...Show All

• ctimko Push Merge snapshot fails with Data is Null message.

  Hi, I'm converting a replication script from SQL 2000 to SQL 2005. I am getting an error with push merge with no way to figure out what is wrong. I've configured replication on a single XP server in SQL 2005 RTM version. I have a push merge set up between A and B and between B and C. All 3 databases are 9.0 compatibility. The snapshot and merge jobs for the A to B run fine with no errors, and merge replicates ok. The snapshot f ...Show All

• sinu Speed up calculation time?

  CDI= case when A+ B- (C+ D)<0 then 0 else A+ B- (C+ D) end; if CDI is not the first case, the sql query have to recalculate A + B - (C + D) again, which means two time calculation...which means consuming extra cpu time and power, anyway to simplify the code This is simpler, and may be quicker: CDI= case when (A+ B) < (C+ D) then 0 else A+ B- (C+ D) end as when (C+ D) > (A+B), then the total will be <0. You ...Show All

• terfle RS WEB Service: No Find Users in the collection

  Dear Anyone, We are trying to create a program that will programatically add users to Reporting Services. When the time comes that we would need to create the code to delete users from Reporting services, we found ourselves trying to find a find procedure to go directly to the user info in the collection. Am I mistaken that there is no find procedure to find the user in the collection The alternative for us is to loop through the collectio ...Show All

• Manny Wolfe SELECT INTO OUTFILE?

  Hi, how do I redirect the output from a SELECT to a text-file, or Excel-file It is possible in MySQL, but what about Transact-SQL Thanks Thanks! Sten-Gunnar YOu have to use the OPENDATASOURCE method or a linked server to insert data in another destination than the local SQL Server. More information (including a sample can be found in the BOL) HTH, Jens Suessme ...Show All

• mdickin List of All SSIS packages stored in MSDB

  Hi, I am writing one program in vb.Net where I need to bind a treeview with all the SSIS packages stored in SQL server MSDB database. Is it possible to get all the SSIS packages by using T-SQL query or Object model Thanks Alternatively the following query returns the list of stored packages from MSDB database: SELECT * FROM msdb . dbo . sysdtspackages90 Thanks, Loonysan Referen ...Show All

• Marcos Barbosa SP1 Installation Failure for Reporting Services Instances

  The upgrade was alright for my first/default instance of reporting services but failed for the other 3 non-default instances. I was running SP1 using remote desktop connection. I got the following error at the report manager and the reporting services configuration's initialization. Is there any way to get around this The version of the report server database is either in a format that is not valid, or ...Show All

• Jasonlkk How to 'group by' properly?

  Hi, I'm working on a report where a customerid is passed from the application. The result are data for that specific customer. The result is something like this: Customer: <name customer> Number of hours: <hours:minutes> Average time to deliver: <days> This works perfectly. But now I have also make it possible to pass value 0 as customerid , which means all customers has to in that report. The problem now is that th ...Show All

• Krishnap Sharepoint Integration

  Hi again, I was wondering if there is any way to publish reports straight from reporting services to a sharepoint portal without creating an application to do so Thanks You need the Reporting Services web parts available here. I am looking into using the webparts as a solution for this. Is there any other way to publish reports to sharepoint, i'm looking more for a way to publish a report to sharepoi ...Show All

• Jaxidian The connection manager 'OLEDB' is not properly installed on this computer

  Please help someone from MSFT! I've just finished installing the Sep CTP on my laptop.  I previously had the April CTP and June CTP.  I followed the instructions for removing a previous installation of SQL 2005. Now, when I try to create an SSIS package, I get a message that says: TITLE: Microsoft Visual Studio ------------------------------ The new connection manager could not be created. ------------------------------ ADDITIONAL IN ...Show All

• Adrian_78787 Enable/Disable Job with SMO

  I am trying to enable/disable a job using a using smo in a script task with the following code Imports System.Object Imports Microsoft.SqlServer.Management.Common Imports Microsoft.SqlServer.Management.Smo Imports Microsoft.SqlServer.Management.Smo.Agent Imports Microsoft.SqlServer.Management.Smo.SqlSmoObject Imports Microsoft.SqlServer.Management.Smo.SmoObjectBase Imports Microsoft.SqlServer.Management.Smo.NamedSmoObject Imports Microsoft.SqlS ...Show All

• Lakshmi.A.V How to make an if in the dataflow ?

  I have a dataflow where i import 2 files. The one is the file containing a couple of million records. The other file contains rows with summed values on a specific key. The file with the millions of records is aggregated on the key, sorted, so that the 2 collums from the files can be compared. I then do a mergejoin on the key and now i have temptable with the (key,sum1,sum2). Now there must not be a difference between sum1 and sum2. I can make a ...Show All

• Roman Koreshkov Which version is best for me ?

  Hi I want to install SQL Server 2005 on a dedicated server. I will be placing around 20-25 databases on this which will be access by same number of web-sites with under 1000 pages visits each per web-site. Can you please suggest which will be the best version of SQL Server for my needs. Thanks for you help. G, Is this a Windows SBS, then this is a known issue. If this is just a "test" and sandbox you can ...Show All

• thiagooooo Advice on security model for XML Web Services for many users in Active Directory role

  I am working on the security model for an application that will be used by 100s of users with a dedicated SQL 2005 database for this application and access via SQL XML Web Services. The client has asked to make it "open" during alpha testing such that anyone can access the web services without having to set them up first. Is there a way to do this The best I can figure is to use mixed mode security and hard code a login and password ...Show All

• Finn Tennfjord Multi-line annotation?

  Is it not possible to have a multi-line annotation OR my ENTER key is stuck ;-) thanks, Nitesh I've previously entered a DCR to have this changed so that ALT-Enter works as well so that the behaviour is like Excel. -Jamie Personally, I wonder why the annotation object doesn't have word-wrapping enabled, like the tesxt in visio. That would certainly (imho) be the simplest answer. I do wish enter worked as well (again, a la ...Show All