Answer Questions

• InfoDOG URGENT: Insert and Update in a transaction is getting blocked

  Hello, I have the following situation: -Package A begins a transaction (TransactionOption="Required") with IsolationLevel=Serializable -PackageA calls PackageB -PackageB has 2 data-flows. The first one inserts into TableA. The second one updates TableA. They run serially. They both have TransactionOption="Supported". The update is blocked in SQL Server by SPID=-2   (which I know is MSDTC). I tried setting RetainSameConne ...Show All

• Regent2 Convert Date Format of 00-XXX-00 to NULL

  Let me start by saying that I'm brand new to SQL Server 2005 and SSIS. I'm using the import wizard in SQL2005 to import from a flat file into a table and everything works fine except for dates. A typical date in my flat file is 01-JAN-06. 01 represents the day of the week, JAN represents the month and 06 represents the year. The flat file also contains date values of 00-XXX-00 which represent no date. For example a column containing last purch ...Show All

• NozFx RTF Image in a SQL Server Report

  Dear All, I have tryed to insert a textbox in an SQL Server Report. With normal text it is easy to show the text from an access database with the help of a dataset in the report. But in my database I have text as RTF. Is it possible to show the formated text in an Report Hopefully anyone have the answer or an idea how it is possible to show rich text formated text in a report. Thanks stefan ...Show All

• mickan Locking up after SQL Server Mobile Merge Replication

  Hi, I am trying perform merge replication programatically between SQL Server 2005 and SQL Server Mobile. Using the following code (note i have changed some of the names for the purpose of the post <*> etc:           private void Synchronise()         {             SqlCeReplication repl = new SqlCeRep ...Show All

• reO MSBUILD (or something) for command line deployment of CLR Assemblies in SQL 2005

  VS2005 has a deployment feature that uses a database connection string to automatically connect to SQL2005 and create the assembly and procedures within the IDE. I am unable to access this feature from MSBUILD or any other command prompt utility so far which is a requirement for our internal build procedures. I am looking for the ability perform a command line deployment of a SQL CLR project and pass in the proper server and database name als ...Show All

• Natalia Glagoleva - MSFT View and query optimization

  I'm have made a series of tables and views to create some reports. I have included boiled-down versions of them below. The report query that I want to run (at the bottom) takes a long time to execute and sometimes times out. Creating a rank within the query is doing the most damage, but it can still take a long time to execute without it. The usage table has almost 70k records and there are over 10k users. Does anyone have suggestions for makin ...Show All

• Shaun Collett Pubs not installed?

  Both myself and my tech editor do not have the Pubs database installed as part of SQL Express 2005 in VS 2005 Team System Beta 2 and VB 2005 professional Beta 2.  Is it 1) deliberately left out, 2) just missing in Beta 2 and will be in RC1 or 3) we did dsomwthing wrong and it should be there. Thanks! S The SQL Server Express SKU does not include Books Online or the sample databases. Books Online will be available as a separ ...Show All

• CajunReaper Union All Failed the Pre-Execute Phase

  I am getting the following error when trying to execute my package.  I have deleted and re-create the UnionAll task and have yet to figure out what the issue is. Error: 0xC004701A at Load AgencyDim, DTS.Pipeline: component "Union All" (1446) failed the pre-execute phase and returned error code 0x80070057.   Help More information.  Come to find out this is because my data flow does not contain a Source.  I ...Show All

• A9228356 SSIS Data sources and destinations

  Can someone point me to a comparison between the OLE DB data source and the Data Reader Data Source   We are starting to investigate SSIS and have stumbled through some pain points by choosing one or the other. Additionally, I found that one can not use the SQL Server Destination unless the package is actually running on the Server hosting the SQL Instance.  This seems like we are moving backwards in time.  We have been able ...Show All

• Ackworth Mining Query Builder

  On pages 123, 124 of Data Mining with SQL Server 2005, I can't finish the example. When I add 'Monthly' to the end of the expression "[Home Owners].[Theater Freq]" in the Criteria/Argument column, I usually get an error message saying the syntax is incorrect when I switch to the Results view. If I place a dot after the original expression, like this: [Home Owners].[Theater Freq].Monthly, I get an error message that "The dot expres ...Show All

• erwrwer nsInstance.Initialize errors out

  Hello,   I apologize for this total newb question. I recently purchased Shyam Pather’s book on SQLNS and am currently working through chapter 5. I hit a snag on page 149. Everything runs great until the call to nsInstance.Initialize in AddSubscribers.vbs. I verified that the registry keys are there for the MusicStore instance. I also ran the setup scripts again just to make sure everything was configured properly. The error I am ...Show All

• Ravindra Agrawal Workgroup Edition & .Net Framework Support

  Hi there, I have a problem understanding the feature comparison chart for the different Sql2005 editions. It has the two lines (right under Database Engine) - Microsoft .Net Framework - CLR runtime integration According to the chart the Workgroup Edition does not support the .Net Framework. But it does support the CLR runtime integration. So what does that effectively mean What is possible, what not (like writing SPs in C#, access to ...Show All

• Olivier Moreau How to iterate over a recordset?

  Hi All, Many moons ago I wrote a blog entry ( http://blogs.conchango.com/jamiethomson/archive/2005/02/08/960.aspx ) about how to, in a script task, iterate over a recordset that is populated into a variable using the Recordset destination. My method there was to use ADODB.DLL but that's a bit "old school". Is there anything in System.Data to which I can cast the Object variable that will allow me to navigate the recordset stored withi ...Show All

• Brandon S. multiple charts based on employees in report

  I have two charts that are subreports. I want to see if I can do one of two things. Give the user the ability once the report processes to change the employee name and refresh the chart. Format the subreports to repeat the charts for as many employees that are in the main report. Sometimes there will be 8 other times there will be as many as 20. Int he example of a table you place your chart in th ...Show All

• StevenBr designing for both pdf and excel rendering

  A report I designed looked perfect html and pdf but when exported to excel it chops off the last column when printed. Does the report grow when exported to excel How can I fix this If I change the margins it fixes on the excel side but then the page doesn't look right on the pdf side. Thank you in advance for any help. Microsoft any suggestions please. ...Show All