Answer Questions

• thekaran New to SSIS, where to research how to normalize and re-key tables and lookups?

  I am just getting started studying SSIS with Kirk Haselden's "Integration Services" book. The problem I am trying to solve would seem easy enough to solve in code, but I am still early in the book and would like to be able to focus on the aspects of SSIS that would help me expedite this with SSIS, or to find out early whether what I need to do cannot be easily done. The problem itself is simple enough: I have a database of roughly 100 tables. Ignoring the poor normalization in the database for the moment, my more pressing problem is that that I need to rekey all of the main OLTP tables from a mashup of different key schemes to UNIQUEIDENTIFIERS. For example, Client table is presenrly keyed on an INT, Client Number. ClientFile ...Show All

• Learning VB How to handle report parameters of type DateTime?

  I have defined a report parameter StartTime of type DateTime. I would like to use it in my Chart as filter criteria for the date that is retrieved in my query to view the results beginning with the StartTime. So I defined in the Filter Tab: expression: =Fields!Date.Value operator: >= value: =Parameters!StartDate.Value A Preview fails because of different types string and DateTime. It seams to be the parameter that has to be converted to a string. The problem is that the query data are represented in the de-AT format: e.g. 31.01.2006 but even converting the date to a string using localizing formats do not end in a de-AT format but in 01/31/2006, probably because I am using english tools. Is there any easy solution to compa ...Show All

• TigerPhoenix Newbie to the server side - Connection String question

  Hi - I am an SQL user from the development side, this is the first time I have been tasked to set up SQL Server. So far so good, although I'm having some issues finding the information I am normally familiar with to build a connection string to our database server. 1) We are on a dedicated server with a hosting company. They did not provide us with a licence for SQL Server 2005, so we had to install SQL Server 2005 Express. So far everything is going well, I have: - gone through the proceedure to enable remote access to the database - installed the Northwind test database - installed msSQL Server Management Studio express, and I can see the db components. I usually use Enterprise Manager to connect to and construct/manage ...Show All

• gabegabe Setup replication job in cluster2005 failed with unknown user name or bad password

  Hi all, I am setting up the replication with the scripts which used to setup in MSSQL2005 (non-cluster server). After I run the script and start the snapshot agent, log agent or distributed agent, it prompts, Unable to start execution of step 2 (reason: Error authenticating proxy abc.com\admin9, system error: Logon failure: unknown user name or bad password.). The step failed. abc.com\admin9 is the administrator for all cluster, mssql service and I am sure that the username and password is correct. Any advise Thanks in advance. I tried through the steps, the result is '1' Kindly Advise. Thanks in advance Is abc.com\sqmin9 in sysadmin/dbowner role for SQL server On SQL 2005, I believe you need ...Show All

• A.Russell Problem with Microsoft .NET Data Provider for MySAP Business Suite

  Hello everyone, I've my SQL Server 2005 working properly on Windows 2003 R2 64bit. At this time I want to transfer data from SAP R/3 46C. I've had install the provider "Microsoft .NET Data Provider for MySAP Business Suite" but when I try to import data from sap using "import/export wizard" but the datasource of mysqp does not appear in the list. But if I run Visual Studio 2005 and try to create a datasource the data provider appears. What I did wrong I don't undestand. Please can anyone give me an idea Best regards nmarmol Hi Nmarmol, This looks like a tools issue to mee---I'm moving this thread to a more appropriate forum. Cheers, -Isaac ...Show All

• lebedinsky Save query results to Excel spreadsheet

  When I run an existing query in Management Studio I get the expected results pane. If I try to copy and paste the results to an Excel spreadsheet I lose my column headers and formatting information. How do I save the query results to an Excel spreadsheet so that column headings and formatting info are preserved Thanks for any help you can offer... I put the query in a view then export the view to excel. ...Show All

• meg1 Is it recommendable?

  Dear folks, we've got old tables with triggers which reading data from systables and some stuff... I know that it's stupid way to gather info but.. So that, now, using Sql25k is recommendable to use INFORMATION_SCHEMA tables or betther, take data from sys views Thanks in advance and regards, Hi, for my opinion it is always better to use the information from the INFORMATION_SCHEMA views, becasue you don’t have to care about version changes as objects will be renamed (like from SQL2k --> SQL2k5) and logic to retrieve the information might change. There are sure some properties which are not accessible in these views, but therefore are some sysfunctions which will get you the data. (like extended properties or if the table ...Show All

• jeff1024 SQL Server 2005 install on Vista???

  I've just done a clean install of Vista Ultimate (release). SQL Server 2005 will only install the client tools - it refuses to install any of the server components (including the default instance). I get the " SQL Server Edition Operating System Compatibility (Warning). " I installed the missing IIS 7.0 which got rid of the IIS warning message. Any suggestions please Thanks Jeremy Holt Vista's not supported until SQL 2005 SP2. The original issue posted on this thread was never addressed, but it is the exact issue I am having. I have done a clean install of Vista Ultimate into Virtual Server. The Vista install seems to be working without any issues. I have properl ...Show All

• Hadrienlc The command(s) completed successfully - but why?!!

  Forum, Perhaps I missed something ... but why did it give me this message back when I ran the report in Query Analyzer: The command(s) completed successfully. I am not running a Stored Procedure ... so why this message ... I was looking to get back rows of data. Report Code: /* Patient Insurance List Revised to Patient Insurance from Visit */ SET NOCOUNT ON CREATE TABLE #PRIMARY ( PatientName VARCHAR(200), PatientID VARCHAR(50), TicketNumber VARCHAR(50), DateOfService DATETIME, DoctorName VARCHAR(200), FacilityName VARCHAR(200), FinancialClass VARCHAR(200)NULL, CompanyName VARCHAR(200), -- VisitInsBalance MONEY, -- VisitPatBalance MONEY, -- TotalVisitBalance MONEY, PatientAddress VARCHAR(500)NULL, PatientCSZ VARC ...Show All

• Darren Mombourquette Mixing Aggregated data with non-aggregated data in a cube.

  At this stage in the project I have a simple fact table which currently holds the low level data. I have designed and built a cube around this table and everything works fine with the current data. The next stage of the project is to migrate some data into the cube from another business area. The problem is that this data is already grouped. I would like to display this data in the same cube so the users can at least get an overview of the different business areas. Is this practical and doable or are there caveats to doing this Does anyone have any suggestions as to what the best approach would be Interesting.... so is this what I need to do..(an educated guess): Add the data to the same tab ...Show All

• UNO- Flat File and uneven number of columns

  Please leave feedback for Microsoft regarding this problem at https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=126493 Ok I'm sure it just me, SSIS has been great so far....but how can you import a straight CSV file with and uneven column count. For example: (assume CR LF row delimiter) The,Quick,Brown,Fox,Jumps Hello,World This,is,a,test "Normally" I'd expect this | Col1 | | Col2 | | Col3 | | Col4 | | Col5 | The Quick Brown Fox Jumps Hello World NULL NULL NULL This is a test NULL Ok but what we get is the row delimiter is ignored in preference for the column delimiter and the row delimiter gets sucked in ...Show All

• Bryan Kardisco Package changes made and saved revert to prior state when package closed and re-opened

  I copied and added an existing package as a new package to a project and have been having trouble with settings reverting to those for the original package after I modify and save the changes for the new package. Sometimes happens with the save itself, other times it happens when I close and re-open the package. Most cases are with connections that revert back to the original file reference, but there are also control flow and data flow elements that keep reverting back to either settings from the original package or defaults that result in the re-opened package being in error. Not sure how to get around this issue short of developing the new package from scratch which I'd rather not do since it is fairly complex. Any help anyone can provi ...Show All

• Christoph De Baene Management Studio - switching between Query Editor windows

  I believe that I noticed the following after SP1 was released (and installed). In Management Studio, I used to be able to view the various open Query Editor windows exactly like you could in Visual Studio with any open files - with left and right arrows that allowed the user to scroll through the various windows. Now, it appears that I have a downward arrow that provides me a drop down list of currently hidden Query Editor windows to select from. Management Studio appears to only display 4 editor windows at a time, (at least for me, probably based upon the amount of text in the tab). Is there a way to revert back to the Visual Studio type of scrolling I haven't found an option for this as of yet. ...Show All

• AmitKa Using FreeTextTable Conditionally

  Hello all! I have a stored procedure that accepts a parameter @SearchTerm that may be null. In my WHERE clause, I check for all records where @SearchTerm is null, or are LIKE '%' + @SearchTerm + '%' when not null: SELECT (some records) FROM (some tables) WHERE @SearchTerm IS NULL OR (some fields are LIKE '%' + @SearchTerm + '%'); I am trying to use FTS with a FreeTextTable to make our search ability more robust: SELECT (some records) FROM (some tables) JOIN FreeTextTable(tableName, columns, @SearchTerm) ft ON ft.[KEY] = tableName.[KEY] However, because @SearchTerm can be null, meaning the user is not filtering our records by a search, doing a JOIN to a FreeTextTable throws an error (cannot have null as search string). Ple ...Show All

• ScottStonehouse MCAD free online test

  Hi everyone, I am searching for free online MCAD exam test. I could only find ucertify online free test. If you know any link about this, would you please inform me Thanks Sorry, I did not care the 'customized' meaning. Sorry again, Thanks, Mert The key sentence is : "the database needs to produce a customized error message that can be displayed by the data entry application." You won’t get a customized error message (Because you won’t be able to create one) if you set the column no to allow NULL values. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- Hi, While inserting a record to the table, since we modified the BirtDate not to allow null, does not it al ...Show All