Answer Questions

• tmorton cannot establish a connection in sql server 2005 express

  hi all here is the following error, what should i do.   TITLE: Connect to Server ------------------------------ Cannot connect to KANGALERT\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote conn ...Show All

• Agalab Custom Data Flow Transformation loosing CustomProperties

  I created a custom transform that has a custom interface and is a wizard that uses a web service. It creates custom properties and output columns on the fly. I set the dialog result to Ok and close at the end of the steps. The transform then has the custom fields and output columns I created in the wizard. I've verified this by right clicking on the transform and going to the advanced editor. If I then immediately run the package, the custom fi ...Show All

• NewbeeVFP How do I insert data from a flat file or .csv file into an existing SQL database???

  How do I insert data from a flat file or .csv file into an existing SQL database Here what I've come up with thus far and I but it doesn't work. Can someone please help Let me know if there is a better wway to do this... Idealy I'd like to write straight to the sql database and skip the datset all together... strSvr = "vkrerftg" StrDb = "Test_DB" 'connection String strCon = "Server=" & ...Show All

• George K Importing unicode data from Oracle Database

  Hi everybody, i try to import data from an oracle database configured in unicode. When i run the package i have an error message Error at Data Flow Task [Source - ACCOUNT]: Column "ACCOUNT_CODE" cannot convert between unicode and non-unicode string data types. how can i resolve this regards. have you tried using the data conversion transformation component Open up your package and set the data type of A ...Show All

• Chrissie1 ODBC Destination in SSIS

  Hi! I have a problem that stops me from using Integration Services as THE ETL tool. My goal is to load a data warehouse type of a database. The database is MaxDB (former SAP DB), but this is not the point. Let's take ANY ODBC compliant DB and assume all I have is ODBC driver - no OLE DB driver. I figured out how to read from ODBC source (using Data Reader and ADO.NET provider for ODBC). Now my question is how do I output/write my data into ODBC ...Show All

• MonktonCharlie looping through XML with xquery

  Hello, for example: declare @xml xml select @xml = (select * from table for xml raw, elements) ... now i want to iterate through @xml and get the values from field ID: declare @id int, @x int, @y int select @x = @xml.value('data(count(/*))','int') set @y = 1 while @y <= @x begin select @id = @xml.value('data(/row/ID)[' + cast(@y as varchar) + ']','int') set @y * @y + 1 end ... this is not working because for value() only string literals are ...Show All

• Hector Embedding literals in RDL that will come through in HTML

  I am trying to create some reports that when rendered in HTML are supposed to have some interactivity built into them.  I understand that there aren't any facilities in RDL itself that would help facilitate this process for me, but is there any way to embed some literal strings that will come through in the HTML The items I'm trying to finesse through are <script> blocks, checkboxes, and <object> tags.  When I use the desi ...Show All

• Schenz74 How to get the URL to access a report?

  hi, all I am just starting to use the SQL Server 2005 report service. And I also made some reports, and I am thinking how to get the URL to access the report, especially when I have some parameters need to be passed into the report. Thanks. More detail is at http://msdn2.microsoft.com/en-us/library/ms153586.aspx Basically it's something like this: http://servername/r ...Show All

• Jeevann SQL Server and Windows Update

  I've read in various places that SQL Server 2005 will be part of the Windows Update process, available at http://update.microsoft.com/ . I have SQL Server 2005 Developer edition installed on both an XP machine, and a WS2003 machine. However, on neither of these machines can I see "SQL Server 2005" as a product on the left (under "Select by Product"). Even when there are no products to install, there should still be an e ...Show All

• SandieM Updating database workflow question

  hi, i have a simple database. to test it i have the database locally and i have the same database in the server. currently when i update the database i copy the whole database (mdf file including the data) to the server. i would like to copy only the tables and not the data to the server. what is the best and easiest way to do it regards, rnv Hi, look here to see how to generate scripts: http://aspfaq.com/etiquette.as ...Show All

• HighDesert_NM Error 87 while installing SQL Server 2005

  Hi everyone! I'm not sure if this is an old issue, but I couldn't find it in any thread. Here I go: I downloaded SQL Server 2005 Enterprise Edition from the MSDN site; but when I run the installation wizard I get this error: Errors occurred during the installation Error 87 installing .NET Framework 2.0 The parameter is incorrect And then I have to cancel the installation. This machine meets the hardware requirements, and it alr ...Show All

• John.P.Scott How does service broker reprocess messages after a restore?

  I have an (as yet hypothetical) order entry system. Order data is entered into DB1 and processed in DB2. SSB is used to send the order (order header and detail) via a conversation group. DB1 goes down due to a HDD failure, and is restored from backup. What options do I have for re-processing order dialogs/conversations that were ended just before DB1 went down but do not exist in the restored version of the DB Or lets say DB2 went down and was ...Show All

• Dr SQL More Merge Join question

  All, I want to use Merge Join to join two sources, but the join condition should like this and input1.servicedate <= input2.MonthFirstDay and input2.MonthFirstDay <= getdate() Does Merge Join support this or What’s the best way to do it Thanks Here is more detail: With join with input2, the records in input1 will have multiple records based on the months ...Show All

• AJ787 SQL Server 2005 Pivot Statement Snytax error

  I keep getting a syntax error on the following statement. Please help! Select HWell, [Year], [VesselOrifice], [TubingPressure], [TotalH2OCount], [NetOilCount], [Month], [GOR], [GLO], [Gas], [Duration], [Day], [ChokeSize], [CasingPressure], [24HrNetOilCount], [24HrH2OCount], [24HrGOR], [24HrGas] From (Select Reading, HTag, HWell from #CurrentHistoryWTSerial) p PIVOT ( Max(Reading) for HTag IN ('Year','VesselOrifice','TubingPressure',' ...Show All

• Carlos Fandango Are there any good examples on the use of the “Advanced Textbox Properties (Data Output Tab)“ ?

  The help “Advanc ed ' w:st="on">ed Textbox Properties (D ata ' w:st="on">a ta ' w:st="on">ta Output & ...Show All