Answer Questions

• Seth Demsey Report subfolders

  Within a single project, is there a way to move reports to subfolders without deleting and moving Thanks! BobP Hi Bob, You can create Linked reports from the properties page of the report on the report server. There is a button named create linked report, which creates a copy of the report on the target report folder. After the report has been created you can change parameters, etc and use it. You can implement reports for ...Show All

• ckress-vbstuff To find all pairs in table that fits to given criteria.

  Task: To find all pairs in table that fits to given criteria. For example: I have a table with id's and weight of people. The task is to find all pairs of people (id's) that their weight in range of 0-5 kg. The result need to be without repetitions of data. id  weight 1   80 2   84 3   81 4   90 So results should be: 1 2 (or 2 1) 2 3 (or 3 2) 1 3 (or 1 3) but not both I'm using MS SQL Server 2000. Question: How to do ...Show All

• Brian Lounsberry MSFT Setting Passwords In Connections Using Script Task

  I have a situation where I have to read an encrypted password from a table and set the password and userID for the connections. I wrote functions to retrieve the data from a table, decrypt the password and UserID, and set the connection string for the connection. What happens, though, is that the connection string I wrote to the connection gets changed when reading it back so that the password is no longer included. Also, in testing the connecti ...Show All

• Gnugs Page error in Report Subcription Properties Page

  Dear Anyone, I have an RS report that has about 7 multi-select parameters. Each of those parameters gets it's value, both content and default in their corresponding data sets. Whenever I try to make a subcription for this report and I try to change the parameters used in the subscription, the page goes to "Error On Page" mode. Afterwhich nothing else happens. Can anyone please shed a light on why this is happening We're using the RC1 build of S ...Show All

• NewbiePhil OLE DB Provider - Saving SQL UserName and Password error

  I have created an SSIS package, which uses an IBM OLE DB Provider for DB2 to access some data. In this case it is not possible to use Windows NT Integrated Security, so therefore I stored the username and password in the connection. It works fine for the current user,  but if I log on to Windows with another user and try to change the OLE DB connection I recive the following error:   Error 1 Error loading B ...Show All

• YesK IS_Member

  Hi, IS_Member function Indicates whether the current user is a member of the specified Microsoft Windows group or Microsoft SQL Server database role. If I want to test this for different user other than the current user, How I can do this Thanks I don't think there's any alternative. If you think about it, it wouldn't be too safe if just anyone could go SETUSER <someonelse> and then do stuff with another identi ...Show All

• Joe A Which Package Configuration Type is best

  Hi, I understand there are different package configuration type like... · XML configuration file · Environment variable · Registry entry · Parent package variable · SQL Server Of the above which is best configuration type to use. Regards, Balaji Thiruvenkataraju Hi Donald, According to me a good configuration type is one which ...Show All

• James Manning MSFT How do you find out whether PC is 32bit or 64bit

  I would like to install MS SQL Management Express, and I would like to make sure I am downloading the right files. Could you tell me how I can find out whether my PC is 32bit or 64bit Many thanks W aka Gauguin If you don't know whether it's 32 bit or 64 bit, it's fairly safe to assume it's 32 bit. Thanks, I reached that conclusion too. W ...Show All

• Devender How to append a new values like uniqueidentifiers, sequence numbers to data flow?

  Hi, I would like to know different possible ways in appending extra values like new uniqueidentifiers, sequence numbers, random number. Can you please tell what type of data flow components helps us yes..i want to append values to a path with in the data flow task. If i use Derived Column Transformation, how can i generate uniqueidentifiers and sequence numbers for each row Thanks Go ...Show All

• Jantheman How do I get the value of a column in the last row of my table?

  With out using @@identity or count(*) how do i retrieve a value in a column in the last row of my table. here is the situation. ASP.net project has several sessions open. a user needs to get the value of a column in the last row inserted in a particular table. Select CallID from Calls where 'it is the last row inserted' thanks in advance. you can email me at ! cbmorton!@!gmail.com ! Chris Morton ...Show All

• eriks70012 saving DTS package to sql server

  hi, I have a "Transfer sql server object task" in SSIS that transfers few tables from one database to another. The task works fine and the project is saved on my c: drive. I was trying to save the project on the SQL server and don't know if i am doing somehting wrong I have the following selections made: Package Location: SQL server Server: ServerName Authentication Type: Windows Package path: /TransferTables ...Show All

• Pat 34847 generate table or database schema

  what is the sql servre equivalent to 'describe' keyword. how do we generate the schema of the database and tables of a database. schema here refers to column names and its types. Thanks, that was very helpful. If you are using SQL Server 2005 the following query should work for you. select name as ColumnName, TYPE_NAME(user_type_id) as TypeName, OBJECT_NAME(object_id) as ObjectName from sys.columns WHE ...Show All

• feilng Excel as a data mining client

  Can I use MS Excel to generate the diagrams and charts that are being generated in your data mining project when you use VS.NET 2005   If so, how   I am trying to bring this technology to marketing people the simplest way possible without having to create my custom application.  They just love the graphs, diagrams, and charts generated by VS.NET 2005 when you create data mining projects but I don't want to install i ...Show All

• Tim M About OLE DB for DM!

  I am a new comer in data mining, so I have some question that: Which MicrosoftR OLE DB Providers supported in Data Mining Services 2005 Is MSDMine provider supported in Data mining Service 2005 Why no mining model is created (althought there is no exception) when I run the program like that: (I use C# in Microsoft Visual Studio 2005). I look forward to hearing from you soon. Thanks and regards. using System.Data.Oledb; using System.Data; ...... ...Show All

• Sebastian V Basic Mirroring Setup Help

  After going through the Enterprise Manage mirroring setup, I get the error message ... The server network address "TCP://MYMACH.mynet.net:5022" can not be reached or does not exist. Check the network address name and reissue the command. (Microsoft SQL Server, Error: 1418) I have three instances of SQL Server 2005 Enterprise Edtion MSSQLSERVER (primary) endpoint 5022 MSSQLSERVER (partner) endpoint 5023 MSSQLSERVER (witness) endpo ...Show All