Answer Questions

• Cassiopeiaxy how to do this in SSIS? soory if i m a noob

  Hi all, Am trying to setup a SSIS package between a sql2000, sql2005 source and a sql2005 destination. I have 2 concerns, firstly, due to performance reasons (we have 2 huge legacy databases): After 1st run, Source table has: 1 - 1000 records Destination table has: 1 - 1000 records For 2nd run, Source table has: 1 - 1500 records Destination table has: 1 - 1500 records How I insert only the 1001th record - 1500th record, without touching the 1st to 1000th record Secondly, if there are any changes in values in the records 1st to 1000th record, how to I compare and only update the value that has changed Is there any particular configuration setting in sql that I can use Many thanks for any help provided. ...Show All

• Treasa Merge 2 columns from the same table

  Hi *, I have a table with 2 columns A1 and Firm. A1 holds "dirty data" and there are no NULL values. Firm holds "clean data" for some of the rows in A1 but not for all. So there are quite a few NULL values in this column. I want to replace the value in A1 if there is any data in Firm (value <> NULL). Rigth now, I solve this issue with a simple VB.NET script: Public Class ScriptMain Inherits UserComponent Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer) ' If Row.Firm_IsNull Then Row.Standard = Row.A1 Else Row.Standard = Row.Firm End If ' End Sub End Class Any ideas how to solve this issue without custome code Thanks! It sounds to me like you can use Derived ...Show All

• PeterPan1120 DBCC CHECDB REPAIR does not fix errors ?

  Hi There This is on Sql Server 2000, SP3. When i run DBCC CHECKDB i get the following errors: ============================================================================================ Server: Msg 8928, Level 16, State 1, Line 1 Object ID 2, index ID 255: Page (1:76914) could not be processed. See other errors for details. Server: Msg 8939, Level 16, State 1, Line 1 Table error: Object ID 2, index ID 255, page (1:76914). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1. CHECKDB found 0 allocation errors and 2 consistency errors in table 'sysindexes' (object ID 2). CHECKDB found 0 allocation errors and 2 consistency errors in database 'OLTP3PRO'. repair_allow_data_loss is the min ...Show All

• giarnz Does anyone know MS SQL 2005 support multiple instances?

  Hello everyone, Does anyone know SQL 2005 server support multiple instances if It does, can you tell me how to create another new instance Thanks in advance!! Stephen It does it by naming the instances. To install another one run setup and on the instances page of the setup change from "default" instance to a named instance. and heh presto it will install a new instance. ...Show All

• jturpin Date format in Convert()

  I'm trying to get smalldate from the date field in Sql table. I want the format mm/dd/yyyy ( american format) The query goes like this: CONVERT([SmallDateTime],StatusDate,101) still the result is: 2006-09-28 00:00:00 This works but I also want to retain the DateTime data type. How do I do it in a query here are all the formats: Date Time in SQL SERVER To get only the date select convert(varchar, getdate(), 101) ------------------------------ 12/15/2006 select convert(varchar, getdate(), 102) ------------------------------ 2006.12.15 select convert(varchar, getdate(), 103) --------------- ...Show All

• Can-Ann uninstalling sql server express

  i installed sql server 2005 express by running SQLEXPR_ADV.EXE....now i can not uninstall it because the exe created a temp file to unpack the install files....of course those files are cleaned up after install or whenever i cleaned up the temp files on my pc.....so how do i uninstall part of the solution is simply to look in the log file or registry for the file location uninstall wants to reference...then recreate the temp location by extracting the install dir structure to the temp location using SQLEXPR_ADV.EXE /x ....after doing so, uninstall has most of what it needs..this enabled me to uninstall everything except report services....report services is proving to be extremely painful to remove....pe ...Show All

• digitalsuperman What is the best most efficient performant way to do a Control break in SSIS?

  I have an EDI file with Different Transaction types. I would like to read for a Header, capture some specific info on the header, and read for another specific tran type that comes after and capture additional info. I have a couple of ideas like tagging the records with a key and loading into two temp tables for matching later but that means I would have to do double processing. Maybe a conditional split for the two transaction types and then unioning them downstream, but not sure if the right records would be associated. Possibly tagging sequential key and writng to raw files and matching on the raw file keys downstream. I have a lot of ideas but I am looking for the best proven practice here so i don't spin my wheels or have to g ...Show All

• Eswans2000 .NET FW SDK QuickStart SQL-Express Error: Msg 102 ... Incorrect syntax.

  Hi, I have followed the steps from the .NET FW SDK QuickStart Configuration (C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Samples\Setup\html\ConfigDetails.htm), and have got an error message trying to grant the ASP.NET User account access to the databases by the command sqlcmd -E -S (local)\SQLExpress -Q "sp_grantlogin LEONEW\ASPNET" where LEONEW is my local machine name, and the ASPNET account exists in the Users group. I am getting the error message: Msg 102, Level 15, State 1, Server LEONEW\SQLEXPRESS, Line 1 Incorrect syntax near '\'. Please help if you know how to resolve this. Thanks in advance. Alex. Did you try putting apostrophes around the login name: 'LEONEW\ASPNET' ...Show All

• Nicolas Dupras somebody plz help me.

  want to do a login in vb.net, when the user enters username and password, it looks into ms sql to find user then compare password with database then select user in database and closes form to open another form with selected database. please help, i am stranded with my project and i am getting nowhere. OK, so you implemeted your own authentication, right But SQL Server will authenticate the user first and check the authorization. Therefore you will nedd to either connect to SQL Server using SQL Server authentication OR Windows Authentication. Appropiate Connectinstrings can be found on www.connectionstrings.com . YOu will need to connect with a user who is able to access the database and your storage for ...Show All

• tattoo Microsoft.Data.SqlXml.SqlXmlCommand in asp.net 2.0 web application

  Hi guys, I met a problem when I use Microsoft.Data.SqlXml.SqlXmlCommand in asp.net 2.0 web application. The following is the code: using Microsoft.Data.SqlXml; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { ConnectionStringsSection secConn = (ConnectionStringsSection)ConfigurationManager.GetSection("connectionStrings"); string strConn = secConn.ConnectionStrings["sqlXmlConn"].ToString(); try { SqlXmlCommand cmd = new SqlXmlCommand(strConn); <-- error occurs here } catch (Exception ex) { } } } If <trust level="Full" originUrl="" /> is set in web.config of machine, the code works fine. i ...Show All

• andrealisp SELECT consecutive dates

  I have a table called MachineDtl in SQL Server 2000 with the following fields: Date Machine# Value 1/1/06 100001 50 1/8/06 100001 -90 1/9/06 100001 -60 1/10/06 100001 -900 1/1/06 100008 10 1/2/06 100008 12 1/25/06 100008 -1 1/26/06 100008 -1 Is there a way to select only the records where a machine has a negative value on 2 or more consecutive dates For example I would only want the following returned from the sample above: Date Machine# Value 1/8/06 100001 -90 1/9/06 100001 -60 1/10/06 100001 ...Show All

• Fulankazu Yet another 1603

  I am trying to install SQL Server 2005 Developer over an existing 2KDE install on a W2KP-sp4 workstation. I always die in the same place during the Tools install with an error 1603. I have tried moving the install files from the DVD media to a local hard drive with no luck. I will tack on the last core.log Microsoft SQL Server 2005 Setup beginning at Fri Sep 08 18:21:29 2006 Process ID : 3748 D:\sql2k5_install\tools\setup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2006/8/8 18:21:29 Complete: LoadResourcesAction at: 2006/8/8 18:21:29, returned true Running: ParseBootstrapOptionsAction at: 2006/8/8 18:21:29 Loaded DLL:D:\sql2k5_install\tools\xmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2006 ...Show All

• une Cannot change SSIS installation directory.

  Hi There I installed Sql Server 2005 and SSIS to the C: drive of a server. However i am going to install 3 more instances on this server and i want to install SSIS on the RAID drive. So i uninstalled SSIS, then i installed another Sql Server instance on the D drive. Now when i try to install SSIS, when i go to advanced and browse for installation path it is greyed out and it says that the path has already been bound to the 90\DTS\ folder of the first instance i installed on the C: drive, so basically i dont know how i can install SSIS to another drive Please help. Thanx thanks Hi Raviv Yeah sorry i have had no feedback and found nothing, i had to ...Show All

• Dan Heidel Any help on this SMO request?

  My evaluation copy ran-out and I uninstlaled the previous and installed anothrer evaluation edition. The installation was successful. I created a SSIS package importing a tale from Oracle 10G XE to the SQL 2005 on my machine. I saved the package on the server. The SSIS service is working but when I try to refresh the node, I get this message. The help linl leads to no where: -------------------------------------- TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: Login timeout e ...Show All

• tattoo 1 Flat file to 2 destination tables with different mappings :Please Help

  Here is the Scenario. I have a flat file with name " Employee.txt " (Full url: C:\Employee.txt ) .The File content is like this Anil,Engineering,1997 Sunil,Sales,1981 Kumar,Inventory,1991 Rajesh,Engineering,1992 ( Note: Items are Comma Seperated ) Now, i have a SQL Server database called " EmployeeDB" which has 2 tables " TblEmp1 ", " TblEmp2". The Table is like this. TblEmp1 : Columns EmpName EmpDept EmpjoinDate TblEmp2 : Columns EName EDate Edept using integration services (SSIS) i need code(vb.net or c#) to Create a dtsx package so that i can push the flat file content to these 2 tables. And the condition is : After Executing the package Data loaded in TblEmp1 should be like this EmpName ...Show All