Answer Questions

• MYMMB How to skip records in script component

  In DTS activex task, you can use skipinsert to skip a row, how to do that in script component I have a really easy solution to this: Don't do any filtering your script component. Simply add a conditional split task after your script component that only allows rows you want (via an expression) to pass to the next task... I had the same problem :) Finally I've used the Conditional Split component. ...Show All

• Steve Strong Forms authentication fun

  Anyway, I finally get forms authentication up and working (I think).  I use the included example.  I finally get to the point where I register a user.  Then I modify the rsreportservice.config file to make the new user the 'admin' user.  Now when I login, I have no permissions to anything.  I restart the entire server.  Now when I login I get a "Key cannot be null. Parameter name: key:".  Any ideas here   ...Show All

• Paul_P Cannot generate SSI Context

  New install of SQL Server 2005 (x64) Standard after uninstalling previous version SQL Server (x86) Standard. After installation, client connections are receiving "Cannot generate SSI Context" error messages. TCP/IP Integrated Authentication is being used. Kerboros authentication is failing when SQLService is running under a domain account and works when running under local system account by reverting back to NTLM authentication. ...Show All

• Luka79 File Format for exporting

  Hi. Is it possible to control the type of file formats available for exporting reports from Report Manager   I would like to remove Excel option to prevent users from exporting large reports into Excel. TIA! Rgds Stephie   The configuration changes would always affect the entire report server. If you implement your own custom application (front end) to report server, you could probably anal ...Show All

• gl3nn86 Unattended installation woes

  Hi, I have tried to do a new SQL 2005 install via an unattended install script. I have tried both a modified version of the template.ini and just from the command line. The installation starts and successfully installs some of the components I have selected through the ADDLOCAL option. Unfortunately it then reports an execution error and exits. The errors I find in the install log files are as follows... SQLSetup..._Core.log: Erro ...Show All

• etki New Query button -- always prompts for authentication

  Every time I click the "New Query" button, or drag a file into the editor, the system prompts me for authentication. This time and time again leads to executing commands on the wrong database, and the only workaround is basically to accept the necessity to hit the enter key when prompted for auth, and to always double-check which database you're about to execute your query against. If the user account you are authenticating as has acce ...Show All

• SQL Sifu Internal Activation - calls stored procs in other DBs

  Hi all I am using internal activation on a queue to process the messages, should an error be encountered I call stored procedure A in the same database to log the error. Part of the processing in stored procedure A is a call to stored procedure B in another database (on the same server), however I have not been able to get this call to B to work. Currently I get the error "The server principal XXXXXX is not able to access the database YY ...Show All

• PureOrange FixedHeader JavaScript Bug?

  Hi I have a report with a table containing 26 columns, the tableheader is fixed when scrolling (nice) and I have set the leftmost column to FixedHeader. It is possible via paramters for the user to select which columns that should be visible. But when some columns not are visible then I get a script exception after rendering, 'children.0.style' is null or not an object, resulting in no fixed headers at all. If I remove som columns so that the ...Show All

• Adrian Nicolaescu How automatically process a Cube periodically

  Good morning, I have create a solution with two cubes, but I want that these cubes process automatically, with a batch or a windows task. But I don't find how to do this. Do I need to create a script or something like that. I'm totally lost. Thanks for your help, I see this in another article, but I don't found Analysis Services Processing Task. Is it install with sql server 2005 or not ...Show All

• SHISHIR Derived Column Task failing with error 0xC0049067

  I have a package that fails as soon as it hits the first Data Flow that contains a Derived Column task. The task takes three date columns and looks for a date of 6/6/2079. If it is there, it is replaced with a NULL. This task worked fine until I installed the Non-CTP version of SQL 2005 SP1, earlier today. (I went from RTM 9.0.1399 to SP1 9.0.2047)Does anyone have any ideas Here is the error I am trapping: An error occurred while evaluat ...Show All

• Khurram01 RDL Spec 2005 pg 34 error

  On the RDL Nov 2005 Specification page 34 there is a table. This shows that the "Action" element does not apply to charts. This must be wrong as I was pleasantly surprised when I added a hyperlink to a chart yesterday. Has this been added since the Spec or is there a newer version of the Spec than the Nov 2005 The published RDL Spec is actually correct. Actions do not apply on the entire chart, but only on chart datapoints . ...Show All

• gshad37 I would propose the following workaround ...

  I setup my ExecuteSQL task to have a "Single Row" resultset.  The query returns no rows.  It fails.  I don't think it should but then maybe this is consistent with the lookup transform piping rows down the error output if there is not a lookup value returned. The error returned is Error: 0xC002F309 at Execute SQL Task, Execute SQL Task: An error occurred while assigning a value to variable "Variable": "Single Row result set is spe ...Show All

• markfield88 Package configuration not used after deployment?

  I've been searching for an answer to my question quite some time now and I've not been able to figure it out yet. Situation: - I've created a SSIS package containing a bulk insert task. - I've added a package configuration containing the appropriate connection manager (i.e. dev, beta or live) - CreateDeploymentUtility = true - I've copied the deployment folder to our beta server and I started the manifest file to install the package to the ...Show All

• Sushil Saini SQL Express instances not displayed remotely on SSME on SQL Browser

  SQL Server Express, Express Managment Tools, are to be installed in an Instance called myinstance. A client installation will be made, either on the local machine, a machine on the local network or a machine connected via VPN. The client machine must be able to connect to a database on that installed server instance. Problem description The installed SQL Server Express instance is not always visible on any list of servers. On one machine it w ...Show All

• SIR Alex Transactional Replication sp question

  Why in some of the MS generated procs is there a secondary create proc statement I believe it has something to do with primary and foreign keys but it is not consistent accross all tables that have primary keys. I have included the code of one of the procs. create procedure "sp_MSins_AH_MEMBER_ALERTS" @c1 bigint,@c2 smallint,@c3 bigint,@c4 int,@c5 datetime,@c6 datetime,@c7 bit,@c8 uniqueidentifier AS BEGIN insert into ...Show All