Answer Questions

• FredP Distributed Transaction Persistent Error

  When I try to make a distributed transaction, I always get this error: Server: Msg 7391, Level 16, State 1, Line 14 The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. [OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ] OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d0 ...Show All

• Penn Wallace How to change login in linked server (From Sql Security to Integrated Sec)

  We are having some commercial applications that are running on sql servers at different sites, all with sql security. The software vendor wants to copy data into staging tables on our BI server. But our BI server only support Integrated security. But how can i say, in the definition of a linked server (at the remote machines) to swicth security system If it is possible i could enter a fixed domain-account in that users fields, but i suppo ...Show All

• _Igor Error message setting up System DSN: Setup routines not found. Please reinstall driver.

  Hi, I'm running W2K3 SP1. The MDAC Configuration Checker reports MDAC 2.8 SP2. The only discrepancy is MSADCO.DLL, where the expected version is 2.82.1830.0 and my actual version is 2.82.2651.0 (svr03_sp1_gdr.060301-1546). The error message I'm getting when I use the ODBC Administrator dialog to set up a new entry is: "The setup routines for the SQL Server ODBC driver could not be found. Please reinstall the driver." This is f ...Show All

• Bigforky Identifying the ErrorColumn (in rejected data rows)

  I've noticed that when a row fails to transform/parse, (I.E., the data was truncated) you can use the DFT audit component to see which column contained the error. However, this error column displays the ID of a particular column, NOT the actual order in which the columns are setup (defined in the conn mgr). Is there any way to modify this so that it will show the sequencial column number, or at the very least, the ext ...Show All

• Pete Richards Hello

  Hello, I get the same error. I use sql server 2000, I added the account aspnet, but I always get the error and I'm not retriving any data from the database yet. Can anyone help me Thank you, Augusto What error are you talking about This forum is for .NET Integration in SQL Server 2005 that allows you to build stored procedures, functions, triggers etc. in .NET languages. You can try asp.net forums for your q ...Show All

• Jens Stjarna Transactions in Data Flow

  If I want my data flow task to require a transactions, both Control and Data Flow have the TransactionOption property. Do I need to set both properties, or would setting the TransactionOption to Required in Control Flow imply a transaction in the Data Flow Just curious. Greg. Greg, When you say the control-flow has a TransactionOption property do you mean the package has a TransactionOption property If ...Show All

• MicroAdmin Display Dynamic Column in the report

  Hi Friends, I need to display dynamic columns in the report. I have to show column list to the end user then he/she will select his usefull column and then I have to display the selected coumn in to the Report. other column should not be visible in the report. Any body know hot to do it Nilay I think Cross Table may be a good Idea for dynamic Columns in Crystal Report. Hi, I am designing a report where user can ...Show All

• Idgaf problems in creating report (parent child hierarchy)

  hello, im working with as/rs 2005 and need help in creating a report. my cube has a parent child hierarchy in "category". structur is as follows: A a 1 2 b B C f g 10 11 12 I like to have a function or something, that gives me the unique names of all children of maybe A (result should be: a,1,2,b,3,4,...) there is a functio ...Show All

• AJB123 Parametrized Report with Analysis Services didn't work

  Y made 2 report with parametrized MDX queries and they only work with the default values. But when I select some values from the combos with legal values the report is empty. The weird thing is when I test the report in visual studio it works really fine. But when I go from http://somemachine/reports it fails. Can anybody try this The MDX querie is ok. I have a lot of experience with MDX in SQL 2000. It says something like this. WITH & ...Show All

• ErikHedlund miscellaneous prompt issues on Report Builder 2005

  Hey I've got a few questions regarding prompts on the Report builder Can I change caption of the prompt I intend to let the users know what kind of prompt that is, if the date they're choosing is a upper limit or a lower limit How can I create a Between date prompt I tried using the From..To but it disabled my option to tranform the Filter into a prompt, and from some reason it didn't let me execute report which had After and Befor ...Show All

• Russ1L How to convert Dynamic Properties to SSIS Package Config?

  I'm currently trying to convert over packages from SQL 2000 to SQL 2005. The biggest obstacle at the start has to do with converting my "Dynamic Properties" control. I use it to read an .ini file and load the user name and password to my connections. With 2000 it's nice and easy 1 file 3 lines. While trying to convert it I’ve had nothing but problems. I've tried the Registry Entry but it forces everything into the Current User and I c ...Show All

• Andy White Displying rtf database field properly formatted

  I am a simple user- I have a SQL Server database that stores a particular field as rtf, including all of the formatting characters in addition to the actual user-entered text. I use the report wizard to easily build reports, but this particular field outputs all of the gobbldygook but I just want the user-entered text. Crystal Reports easily translates rtf- why can't Microsoft easily translate their own format Any help would be appreciat ...Show All

• Siang Green Bar Report for matrix

  I have a matrix and I am trying to create a green abr report by adding a group called rowcolor and setting it equal to 1.  Then the hitchhiker's guide says to put =ReportItems!RowColor.Value for the background color but I keep getting the error (The background color expression for the textbox ‘textbox4’ refers to the report item ‘RowColor’.  Report item expressions can only refer to other report items within the same grouping scope or ...Show All

• connie graham Ambiguous Complex Type definition with XML Source. Workaround?

  Hi, This could well be down to my _limited_ knowledge of XSD. I have a document and SXD supplied by 3rd party. Both documents are valid, according to XMLSpy. When I give the document and xsd to SSIS XML Source it complains about ambiguous complex types. In the XML doc there is an element called Allowance that has child elements. There is also a group which references many other elements including Allowance. When I re ...Show All

• frankie70 exit job within a step

  Hi, I have a job with 6 steps. before I run steps 2 to 6 I check to see if there is data to process. I want to exit the job reporting success without running the other steps. How do I do this Thanks Thanks, This what I have done before. I was looking for a difference way. Hi I would add 2 additional steps to your job Step1: Test if there is any data to load. I ...Show All