Answer Questions

• Bruno Stocker How to run package with variables using dtexec?

  Hi, I am running my package in this way: exec xp_cmdshell 'dtexec /SQL "\SBLoadExcelDBLog" /SERVER test /USER **** /PASSWORD ***** /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW /LOGGER "{6AA833A1-E4B2-4431-831B-DE695049DC61}";"Test.SuperBowl" /Set \Package.Variables[User::varExcelFileName].Properties[Value];"aaab" /Set \Package.Variables[User::varExcelWorkbo ...Show All

• Laputa09 Pivot currency problem when aggregating on time

  Hi! I'm using the currency conversion (using the BI wizard - having SEK as pivot currency, many-to-many option, going through division (organizational dimension) to find the currency to use to convert to pivot from local currencies SEK and DKK, and then having reporting currencies CHF, USD, DKK and SEK). Everything works fine when I'm at time_key level (lowest level - which is month). However - when I choose a quarter the pivot currency (SEK) ...Show All

• Soaring Skies Query Designer

  I am executing this query and it runs fine as an sql query in designer but if I select Generic Query Designer (see second query), it adds quotes and will and I get an error. This works: SELECT POL_NUM, MAX(case [POL_CNT] when 1 then SAID else '' end) as [1], MAX(case [POL_CNT] when 2 then SAID else '' end) as [2], MAX(case [POL_CNT] when 3 then SAID else '' end) as [3] FROM ( SELECT Policy_Number 'POL_NUM' ,PA_Policy_Agent_Code ...Show All

• clevershark 2005 Cursor Looping Issue

  I've just begun to work in 2005 and am trying to run a cursor without any modification, which has proven to work in SQL 2000 and it's not looping. the cursor has a few declared variables, running a select statement and assigning the returned value to the variables, then executing a sp using the variables as input.  It is really written out textbook, for example: declare @var1 int declare cuMyCursor Cursor For (Select etc...) ...Show All

• curiousbeginner Configuration files and variables

  Hi .. I need some information on the package configuration files. i.e how to set the configuration parameters from outside the packages. Pls provide me some detailed information along with examples. I want to make my packages to read paramaters from the configuration files as we have in .NET(web.config)//// Secondly I want to know how to play well with variables.. i.e setting a variable.. reading a variable.. passing a variable in the ...Show All

• RenegadeMinds How to configure sql reporting services and iis through dmz

  I am trying to setup an application on the dmz who will connect to a reporting services on the inside but I cant get the security to work. This is how the configuration is: One server on the DMZ running windows server 2003 in aworkgroup running IIS,ASP One server on the LAN running windows server 2003 and sql2005 std with reporting services and the server is in a domain. The web application is running on the DMZ server and I am trying to g ...Show All

• Danielk62 Disable the "All" option in a parameter

  Does anyone know how to disable the option "All" in a parameter which is in a 2005 reporting Services Report based on a 2005 AS Cube Thanks in advance, Pieter The only way I found, is to build another dataset based on sql query returning the same data. Regards Ayzan Thanks for your reply This is not a good option because the options given in ...Show All

• domfos SSMA extension

  Hi, I am trying to install and use SSMA to convert an oracle database to SQL Server.  When I install the extension pack I receive some errors.  These errors are either one of two types: Return code: [1] Msg 207, Level 16, State 3, Server NYCWS0022, Procedure TO_CHAR_DATE, Line 9 Invalid column name 'LCID'. or Return code: [1] Msg 2760, Level 16, State 1, Server NYCWS0022, Procedure UTL_FILE_FOPEN$IMPL, Line 65535 Specified ...Show All

• Radhakrishnan Proper Procedure to change servername of replicated environemnts?

  Hi There Firslty this is a question concerning sql server 2000 hope this is not just a 2005 forum I need to change the servername of a few of our sql 2000 database servers. I know the procedure to change the name and reconfigure sql with the new servername. What i am concerned about is that these databases are being replicated via a remote distributor. Obviously the subscriptions stipulate the servernames , i am concerned about what will happen ...Show All

• Chris0144 what is the meaning of "64(error not found)" in sys.transmission_queue

     as Christopher Yager say in "Need distributed service broker sample", I also test sending messages between two SQL Server 2005 instances,and after I setup the test environment with instance1 and instance2,I find queue [q2] in ssb2 can't receive message from ssb1. when I query by "select * from sys.transmission_queue",I get some message records that transmission_status is "64(error not found)".  &nb ...Show All

• Noelle Fit dataset on one page

  Hey guys, Let's assume I have dataset with two columns (A,B) and it has 100 records. I'd like to split this dataset on the same page with 25 records in every column. Side by side. Example: ColA ColB ColA ColB ColA ColB ColA ColB 25 rec 25 rec 25 rec 25 rec What should I use and what properties I have to play with Thanks. I'm guessing again, because I've not tried this ...Show All

• Quinch Using SSMS to Manage SSIS

  (Also posted on the beta newsgroups...) I'm having problems using SSMS on a workstation to manage SSIS on a server.  I cannot connect to SSIS on the server.  The SSIS service and the RPC service are both running on the server, but I get an "RPC server is unavailable" error message. I have CTP 15 running on the workstation but CTP 14 running on the server.  Probably not a great idea, I know.  Anyone know if that is defini ...Show All

• Daan63 use SSIS to normalise data

  Hi all. I have a SQL Server table which I need to normalise. To simply what I'm trying to achieve, here's an example table... Create Table Sample( Id Integer Identity(1,1) Not Null, Data VarChar(6000) ) Insert Into Sample( Data ) Values( 'This is the first line This is the second line' ) What I'm trying to achieve is to pass the entire table. Then split each line of the Data column into it's own row. Does anyone have an ...Show All

• CsharperNow navigation on subtotal

  I have a matrix and a subtotal footer summing up a group of numbers. Each row has a primary key. I use the primary key to drill-through another report through "Navigation". Unfortunately, the generated subtotal column also have a link but it has a primary key of whatever the first row is, which shouldn't have a primary key. So I can drill-through the subtotal but it returns the wrong result. I have not been able to override the subtota ...Show All

• Bone SQL 2005 Enterprise June CTP Installation Error

  Tried to install several times (on Win2003 Ent. SP1) but I always get the following error: Failure adding user NT AUTHORITY\NETWORK SERVICE to local group SQLServer2005MSSQLServerADHelperUser (1388) The user varies (sometimes NT AUTHORITY\SYSTEM) and so does the local group (sometimes SQLServer2005SQLBrowserUser). Any tips Regards Roger Same deal here too. Different groups appear for different services, but my ...Show All