Answer Questions

• JBG Change Data Capture

  Again, looking for the best way to do this with SSIS. I have a source table and I'd like to load it to a database daily, capturing what changed. This is not a dimentional table but a fact table. So, what I;d need to do for each record is to see if the record already exists (using business key) and if it does - compare some of the data fields and of there are changes - register it somehow and if not changes ignore. Right now, the only ...Show All

• Daniel Q Enabling remote errors

  Hi. I am trying to get remote errors to display in Report Manager. I've set the "EnableRemoteErrors" configuration value to True in the ReportServer.ConfigurationInfo table. Then I restarted both the Reporting Services Service and IIS. However, I am still seeing the following message when running a report: An error has occurred during report processing. What am I missing Thanks ...Show All

• KissDaFeetOfSean ReportExecutionServer namespace????

  I'm trying to work through this code example: http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials.aspx There is no mention of the namespace or assembly for the 'ReportExecutionServer' web service. Anyone know where this lives, or any other info how I can get this working in the above example code Thanks. The ReportExecutionService is a web service so an assembly does ...Show All

• sellison14 Losing umlauts in SQL Templates

  Hi there, does anybody know why I'm losing all umlauts whenever I drag a custom template to a script Double-clicking works fine, but I definitely want to avoid a unproductive workaround like double click > mark all >copy > paste in other script. We work a lot with shared templates and we cannot avoid using umlauts in the scripts. Any expericences or suggestions Thanks in advance Thomas ...Show All

• Sranger SQL 2005 how to change @conflict_retention for articles already published

  Hello,     I have some articles already published and would like to change some of the articles default @conflict_retention of 14 days to 45 days. How can I accomplish this via t-sql Thanks.   John     @conflict_retention is publication level setting. You can change it through sp_changepublication or sp_changemergepublication. But you can not change only f ...Show All

• Christian Meier remote connection error SQL2005

  I am trying to connect to a remote 2005 SQL server “A” from my 2005 SQL Server Management Studio on a different network. I have opened up port 1433 on the remote server A. I have made sure that “Allow remote connections to this server” is checked on the remote server properties under connections. I have also chosen “Using both TCP/IP and named pipes” under Remote Connections in the SQL Server 2005 Surface Area Configuration. I am using ...Show All

• OneStrayCat how to find out the names of the currently running SSIS packages in a stored proc?

  Hi all,i want to get the list of running SSIS packages in a Stored Proc.Is there any way i can do it ...Show All

• Dobriendob Mining Algorithms

  I would like to use SQL Server 2005 data mining to look at some engineering problems. In order to really do that, I would like to see some reference material on how the different algorithms work. Does anyone know where I could find some I have looked hard thru BOL and cant find any there. As I wrote in another thread , usually I need only online documentation to learn new features of applications, but ...Show All

• JACorona How can I join information from different datasets?

  I want to know how to join information that is in 2 different datasets into a single table. Thanks P.S. Also having problems with data driven subscription, it simply won't connect to the database with subscribers, always getting the logon error. Thank you for your answer. P.S. Do you have any guidelines for me for the second problem Also posted it in another thread: http://forums.microsoft.com/MSDN/ShowPost.as ...Show All

• Neelima FixedHeader Columns struggle with layout in IE

  Hi, I use a table wtih drilldown (first tree columns) where i want to freez the first tree columns. The fixedheader itself is working, but it seems to struggle with the layout and functioallity. The issues are: Tableheader is less high in fixed columns (contains some merged cells and two rows) the merged cells in the drilldown (mergend one, two or three cells) destroy the fixed layout - freezes more then the first tree columns ...Show All

• drey Extending Management Studio

  In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management Studio. If ISVs (independent software vendors) could plug their SQL Server tool(s) into Management Studio – creating a single environment for you to work in – which tools do you use that you’d like to see surfaced in Management Studio. Dan I think it would be cool to have PromptSQL integrated into Management Studio to give SQL Intellisense inside Management Stu ...Show All

• lugo Blocking Transaction

  I have a 3 simple packages get called from master package. First package populates time dimension (stored proc), second one populates transaction type dimension(stored proc) and the final one populates date dimension. I set the TransactionOption = Required in the Master package, every thing else (package & component) set TransactionOption = Supported. I have been testing transactions, basically I made time and transaction type dimensio ...Show All

• KCTami Variables Not Seen In Custom DataFlow Destination

  I have run into a HUGE problem (possibly a BUG)! I have a custom XML Destination script which uses a FILE Conn to send to another path using the original file name. (found in my foreach container (varFileNm) The problem is that my destination will not use the value found for the varFileNm. I can see the value just fine in the Flat File Receive, but I can't see the value in my custom XML Destinati ...Show All

• narechk Cannot change naming metadata

  Hello, I've found a bit of an infuriating nuance in SSAS2005. My cube used a view called view1. At some point in time the DSV was changed to use a very similar object called view2 instead. I got a failure when processing the cube. The message was: Errors in the OLAP storage engine: An error occurred while processing the 'view1' partition of the 'foo' measure group for the 'bar' cube from the foobar database. In other words...the n ...Show All

• Carlik AND OR question

    Can I set  up constraints to be AND OR.  I have 4 tasks (A,B,C & D)   I want D to fire when the follwing criteria occur:   (A or B) and C. I haven't managed to do this, as when I set up the OR constraint, all of the green lines turn to OR's as well.   Many thanks in advance for any help         Hi Jamie Yes, that works perfectly. Many thanks. By th ...Show All