Answer Questions

• mahima VS 2005 standard prevents using free SQL Express functionality?

  Hi, *relative newbie warning* I use Visual Studio Standard edition with the built-in version of SQL Server. Now I chose a new image catalogueing app, IDImager, that uses SQL Server Express to store photo info. The idea is that I can use the database also with my own code, or transfer the data to another app/database in the future if necessary. IDImager needs SQL Express with the 'connectivity components' installed using 'mixed mode'. This is their instruction page: http://www.idfoxx.com/support/idipro/install/ However, that option is not available in VS 2005 Standard and when I try to install these components with SQL Express I get the message that's not possible because VS 2005 restricts the install options. So far I gat ...Show All

• Kris M. Problems by upgrading MS SQL 2005 with SP 1

  Hi, I have 3 servers running MS SQL 2005. The other 2 servers upgradet fine, but the last one failed on the databasepart. I am running the upgrade as administrator. And I am able to start the databases after the failed upgrade, but the maintanance plans and so on doesn't work. This is a production server, and I would be happy to get feedback saying it is OK to keep running producton on this machine The error thas was provided was: 02/04/2007 22:15:18.750 ================================================================================ 02/04/2007 22:15:18.750 Hotfix package launched 02/04/2007 22:15:19.468 Product discovery successfully completed during the install process for MSSQLSERVER 02/04/2007 22:15:19.484 SP Level check successfully ...Show All

• nomer Deleting duplicate records from a table.....

  I loaded one table via SSIS and found that it contained many duplicate records (from the input source). I can create a SQL task to delete them, but I wonder if SSIS offers and task "out of the box" to delete dups TAI, barkingdog Use a Sort transform from SSIS is a possible alternation - Sort on certain keys and check "remove duplicate records" at Sort transform. hth wenyang I don't know about anything in SSIS to do so but here's a great way to do it using CTE's and Row_Number() http://www.sqlservercentral.com/columnists/chawkins/dedupingdatainsqlserver2005.asp ...Show All

• Xancholy Error Creating Data Source View in VS 2005 BI Tool for SQL Server 2005 View with > 32 Columns

  I keep getting an error message in Visual Studio 2005 (SQL Server Business Intelligence Development Studio) = "Cannot have more than 32 columns" when I use the wizard to create a data source view using a view I created in a SQL Server 2005 database, which I use as a data source. The view does have more than 32 columns; however, I have been successful in creating data source views for other DB views with more than 32 columns. It seems that for some DB views with more than 32 columns the wizard ignores this problem, but for others - admittedly with a larger number of columns - it does not. Any insights and potential workarounds Thanks! Please file a bug on http://connect.microsoft.com/SQLServer/Feedback and we'll look in ...Show All

• Matt354245 Oracle 7 query

  Within a VS 2003 BI project, I can create a parmeterized query against an Oracle 7 database by using a for the parameter(s). Example: SELECT LTrim(RTrim(SWO_ISS.REF)) ACCT, CUS_LOC.NAME CUSTOMER, SWO_ISS.TRAN_DATE, SWO_ISS.ITEM, ITM_DESC.ITEM_DESCRIPTION, SWO_ISS.QTY, LSTPRC.AMT FROM MYDB.SWO_ISS, MYDB.CUS_LOC, MYDB.ITM_DESC, (SELECT LP.ITEM, LP.REVISION, LP.AMT FROM MYDB.LIST_PRC LP WHERE LP.EFFEND > SYSDATE) LSTPRC WHERE SWO_ISS.REF = CUS_LOC.CUS_LOC(+) AND SWO_ISS.COMP_ITEM = ITM_DESC.ITEM(+) AND SWO_ISS.COMP_ITEM = LSTPRC.ITEM(+) AND SWO_ISS.COMP_REV = LSTPRC.REVISION(+) AND SWO_ISS.REF = AND SWO_ISS.TRAN_DATE >= TO_DATE( ,'MM/DD/YYYY') AND SWO_ISS.TRAN_DATE <= TO_DATE( ,'MM/DD/YYYY') Unfortunately, as soon as the dataset is ...Show All

• ahmed921983 Import works but no data? Part 2

  Now I got a little bit further on my own. But, I have run into this issue with, "Not being able to import the data to the database". I can import the column headings, then that is were it ends. I was reading up on this and it made it seem as if you are to go back after you get the column headings. Then do the same to get all the rest of the data. But, for some reason the "Query or Copy" menu doesn't display to do the query action to import this data. Is there anyone who knows what I am talking about, please help.. I am using SQL SERVER 2005 and I am trying to import via the import wizard. I'm not able to catch if this is a continuous problem you have had previously, that helps if you can refer your old ...Show All

• AlexBB Install SQL Server 2005 Exp with ToolKit

  Hi, I would like to have SQL Server 2005 Express with the most features as possibles. It seems to be correct about 'AdvancedEdition' but, when I installed the "ToolkitEdition", in order to get "Business Intelligence Development Studio", I was not able to open this option. The file 'devenv.exe' is missed. Do you have some procedure and links to get best set up with theses features for SQL Server 2005 Express Thanks. Hi Peter, I've installed the SQL Express Toolkit along side VS Express a number of times without problems. As you've pointed out, the VS Express Editions don't include devenv.exe, or more properly, they contain a customized development environment that ...Show All

• Yash Purohit Capture errors from SSIS Execute Process Task

  I have an Execute Process Task within my package that executes a BCP command which outputs the resultset of a query to a file in the network share. It works fine most of the time, however sometimes for unknown reasons, the following error message gets logged in my log table - In Executing "c:\Program Files\Microsoft SQL Server\90\Tools\Binn\bcp.exe" "Select Comments, SoldToCustomerNbr, ProductGroupingCode, ProductGroupingName, RevSumCategoryCode, RevSumCategoryName, ValidFromDate, DTSCollectPct, DTSPrepaidPct, DTSPickUpPct, DCCollectPct, DCPrepaidPct, DCPickUpPct From ShipmentTypeCustomerBlend" queryout \\xxx\LOG\ShipmentTypeCustomerBlendLog_060719201440.txt -c -t"\t" -SDummyServer -T -e"d:\SSIS Error ...Show All

• r3n OLEDB Destination Error in SSIS Package not returning error column/desc

  I have a SSIS package that reads data from a dump table, runs a custom script that takes date data and converts it to the correct format or nulls and formats amt fields to currency, then inserts it to a new table. The new table redirects insert errors. This process worked fine until about 3 weeks ago. I am processing just under 6 million rows, with 460,000 or so insert errors that did give error column and code. Now, I am getting 1.5 million errors. and nothing has changed, to my knowledge. I receive the following information. Error Code -1071607685 Error Column 0 Error Desc No status is available. The only thing I can find for the above error code is DTS_E_OLEDBDESTINATIONADAPTERSTATIC_UNAVAILABLE To add to the confus ...Show All

• Ray Dyce SQL Server 2005 "Login failed for user" sa

  I have not been able to install SQL Express SP2 (standard or advanced) on Vista Ultimate (RTM). Every time I try to install, I get the following error message: SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. When I check the logs, the only information I can find that is at all useful is: Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Mar 01 21:35:42 2007 Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Mar 01 21:35:42 2007 SQL service MSSQL$SQ ...Show All

• Jeff Weber Convert row with text field to column

  Hi experts; How can I generate the result using typical SQL statement based on the following tables Table a - Salesman (salesId, Name) pk : salesId Table b - Invoice(InvoiceNo, salesId, InvoiceAmt) pk : invoiceNo fk : salesId -> Table a The result set : salesId, Name, sum(InvoiceAmt), InvoiceNos with comma separator For example: Table a SalesId Name S001 Peter S002 Alice Table b InvoiceNo SalesId InvoiceAmt INV001 S001 $100 INV002 S001 $100 INV003 S001 $400 INV004 S002 $200 Result set SalesId Name Sum(InvoiceAmt) InvoiceNos S001 Peter $600 INV001, INV002, INV00 ...Show All

• thukralz SSRS: Generate Report Without RDL file

  Hi all the good people here, Can I generate a report without having RDL file physically at the server According to any "Generic Report Builder" logic, the report builder must stores the properties of Report in one form (RDL/XML) or the other (in database) and at the time of generating the "Report Output", builder must be reading those properties, assigning those to any class object's (say objRPT) properties/members and calling the method to generate the report in perticular file format. I need a way where I can assign these values stored in the database (i.e. meta data of report is stored in database) to the objRPT directly. Can I do that. I need this because I want to see whether I can switch from "Act ...Show All

• Pockey Best approach

  I have what I feel like is a simple package I am working to create. I am teaching myself SSIS as I go along. Source server SQL 2000 database allows NULL values in columns. Destination Server also SQL 2000 but the database required a value in each column. So I do a basic source select what I want. I next need to read the values and determine if null then insert a space, do some column matching and insert them into the destination sever. I believe I should use a Derived Column and an expression ISNULL to accomplish what I want. Maybe there is a better way. Suggestion and comment appreciated. Ryan Try using the T-SQL ISNULL() function in your initial query, replacing any null va ...Show All

• MattyBoy4444 Microsoft report builder is a very BAD product

  This product can't make a report selectin measures from more then on cube at the same time crossed by to shared dimensions, it's a shame. Please don't say you have a web base ad-hoc query if you can’t even do same basic stuff like this. I can do what I want in visual studio I have no problem there buillding my owne query and customize the sql ou mdx. The problem is that the end users can't, the end users use report builder and this tool does the "stupid navigation", and does not allow the selection of two measures from diferente fact tables or in you are working with analysis server form tu measures grups, and select more the one dimension. This really is a serious question be ...Show All

• woodland30033 Specing out a new SQL2k server...need help

  We are currently running these specs... CPU: Dual 2.4Ghz Xeons RAM: 4GB HD: Raid 5 OS: Windows 2000 SP4 SQL: SQL 2000 32bit Our RAM is constantly at 75% of the physical memory. The CPU usage ranges from 10-90%. I need recommendations on brand and specs. I would like to keep the cost under $10k. It needs to have RAID 1 for the OS and at least 200GB RAID 5 or 10 for the data. We would also like to have hot swappable drives. Here's the configuration I am considering... Brand: Dell (Not sold on this yet) CPU: Dual Quad 2Ghz Xeons RAM: 8GB HD 1: 36GB RAID 1 HD 2: 300GB RAID 10 OS: Windows 2003 64bit SQL: SQL 2005 64bit What are the pros/cons of upgrading from SQL 2000 32bit to SQL 2005 64bit Also, any recommendations on the ha ...Show All