Answer Questions

• Sami Karaeen Delete records that don exist in the destination

  Hi all, I am developing an ETL wherein the requirement is to do an incremental load and at the same time, if there is a record that got deleted in the Source delete it from the destination too, makes sense. The approach am doing is, pick data from the SRC and Destination, pass it onto a Merge join component, do a Full Outer join, then pass the rows to a conditional split. Newly Added records and updated records I can handle, how do I handle the Deleted records Am I correct in the way I am doing or there is something better to handle this Thanks in advance Thx for the inputs Jamie. My problem of deleting the records in the destination that were removed from the Source DB was solved by using ...Show All

• Juan Carlos Trimiño create table from select result

  Hi, I need to create a table which has the columns from the select statement result. I tried in this way drop table j9a SELECT er.* into j9a FROM caCase c LEFT OUTER JOIN paPatient pp ON c.caCaseID=pp.caCaseID Left Outer JOIN paManagementSite pm ON pp.paManagementSiteID=pm.paManagementSiteID Left Join exexposure ee ON ee.cacaseID=c.caCaseID LEFT OUTER JOIN exExposureRoute eer ON eer.caCaseID=c.caCaseID LEFT OUTER JOIN exRoute er ON er.exRouteID=eer.exRouteID WHERE c.caCallTypeID =0 AND c.Startdate between '1/1/2006' and '12/1/2006' AND (ee.exMedicalOutcomeID=4 OR ee.exMedicalOutcomeID=10) AND pp.paSpeciesID=1 AND c.PublicID_adOrganization_secondary is null declare @1 int,@2 int,@3 int,@4 int,@5 int,@6 int,@7 int,@8 int, @9 int,@10 int,@11 ...Show All

• Peter Wimmer MDX - Remove a certain member from the total

  Hello everyone - I have a State dimension, the ALL level is called Total. On each report I show the total for all Members for each measure. I now have a request to remove certain states from the TOTALS. Any ideas Thanks for your time. with member [MEASURES].[Loan Count] AS '[MEASURES].[LN CNT]' member [MEASURES].[UPB] AS '[MEASURES].[CURRBAL]',format='#,###0' select non empty { [MEASURES].[Loan Count], [MEASURES].[UPB] } on columns, non empty { [STATE].total } on rows from XXXX where ([MONTHS].[TOTAL].[81]) I found a answer: let me know if you know of an easier way. Thanks! with member [STATE].[EXCEPT] AS 'aggregate(EXCEPT({[STATE].[TOTAL].CHILDREN},{[STATE].[WISCONSIN]}))' member [MEASURES].[Loan Cou ...Show All

• ChenWang rsAccessDeniedToSecureData

  I've installed a fresh load of SQL Server 2005 onto a Windows 2000 server, including all the trimmings with SS2005. Reporting Services 2005 is the main thing I want to initially check out, but I can't get it to work. In the 'Reporting Services Configuration' it shows the 'Web Service Identity' as a blank grey box which can not be edited. I can't help but think this might be where the issue is. I looked at this thread, as it describes the exact same problem, but the solution did not work for me. The RS service will start up, but then when I navigate to http://localhost/reportserver or http://localhost/reports it gives me the following error: Reporting Services Error In Internet Information Services: Open up the properties to the Re ...Show All

• yousaid Foreach loop with XML Source failure

  I can't import from XML files using a foreach loop. I load an XML file with a generated XSD. When I map the file to the table it has no errors. If I now go back and change to a different XML file, I get an error: "Error 1 Validation error. Data Flow Task: DTS.Pipeline: input column "COLUMNNAME" (129) has lineage ID 2115 that was not previously used in the Data Flow task. Package.dtsx 0 0" This is for testing purposes. When I run the foreach loop it does not work. Ironically, I do the exact same thing in another foreach loop with a completely different XML and it works fine. Here is the broken XSD: < xml version="1.0" > <xs:schema attributeFormDefault="unqualified" elementFormDefa ...Show All

• DBrett select * from mytable for xml raw - can't send to sql server destination

  Good evening, I want to use ssis to export data from relational tables in sql server 2005 and import them into an xml column in sql server 2005. Any suggestions for the best way to do this. I created an datareader source using adventure works with the sql command "SELECT * FROM purchasing.vendor FOR XML RAW" I then created a sql server destination with and mapped the output from above to an xml column. I get the following error Error: 0xC0202009 at Data Flow Task, SQL Server Destination [596]: An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "XML parsing: line 1, character 2033, unexpected ...Show All

• dez66 Management Studio Express

  I installed SQL Server 2005 Express and Management Studio Express. All was working fine. I was using VS 2005 to develop an add-in for an app that will be running on MSDE2000 in production. I found something that worked on SQL Express but not on MSDE, so I decided to install MSDE and develop on that. No problem. I decided to try to view my MSDE instance in Management Studio. It worked fine. Cool. Once I shut down Management Studio it all went pear-shaped. Now whenever I try to open Management Studio it freezes. If I press Alt+Tab it shows a "Connect to Database" dialogue in the window list but I cannot access it. I'm assuming that there's an issue with connecting to MSDE. I've tried uninstalling MSDE, reinstalling SQL ...Show All

• JohnGalt Need help in migrating from Access to SQL express

  Hi there, I am totally new at SQL/SQL express.I have downloaded the sQL express server and wanted to know how i can go about exporting my tables which i created using MS access into SQL express. Also my application is currently working by using Access and ASP...what will be the changes i would need to incorporate in my code other than the queries and Data connection string. How would the data connection string in SQL look like if i am using it in my asp code Any help or useful links would be a very good help! thanks in advance smita Try the SQL Server Migration Assistant. http://www.microsoft.com/downloads/details.aspx FamilyID=d842f8b4-c914-4ac7-b2f3-d25fff4e24fb&DisplayLang=en Have a look a ...Show All

• Phantom208 Automatic width

  Hello : It is possible to define the width of the cells of table dynamically (not Statics) Thank's. No (as of SSRS 2005). ...Show All

• SN Ngaihte Create a seperate thread for a winform in script task?

  In order to provide runtime, realtime, graphical feedback to ETL operators, I am planning to open a new winform when my packages start, and update the form via polling of events. It is my understanding that this means I need to create a new thread for the winform from within the script task. Anyone done this via script task yet Any reason why this couldn't work or shouldn't be done from the script task Would I be better off writing the winform app completely seperately and simply call it from an "execute process" task Thanks, Ken Thanks! If I encounter any unexpected issues I will raise them here. There are no known issues with the script task when it comes to creating new threads or displaying winfor ...Show All

• Raghavendra RAV problem in executing package in production environment

  hi all! This is my problem. My package executes fine when i set the connection string with the same database where i execute the query. If i execute with another database connection stirng if fails bacause while executing the pacakge it trys to access the same connection string at design mode. when i try to execute through cmd prompt by setting \conn <new database connection string> it fails. Is package configuration is the only solution. how can i change conn string depending on different server Any help would be appreciated. Thanks, Jas As far as my knowledge, package configuration is the only one solution. i am currently trying to set the variable with the /set and give c ...Show All

• benschi SOS, One .NDF file missing Can not Restore DB

  Dear All, I have a DB with four .NDF Files. The First .NDF File is corrupt. Unfortunately my Backup also Failed. So I Have no Backup. Other .NDF and .LDF and the MDF Files are intact except one .NDF file. Can anyone help How can restore/Recover my DB. I can not mount the DB. ITs OK if i loose some data and am able to use other intact .ndf files. Your help is Greatly appreciated. Thanks I need to clarify my response: If the .NDF file which is missing is NOT part of the primary filegroup, AND you are running Enterprise Edition, then you can bring the rest of the database online. Kevin Thanks Kevin. I did not notice the new 'offline' attribute. alter database testdb modify file (name='testdb_n1', offli ...Show All

• clint 2 I messed up (again) - install Error

  I have this #@!% installed on my machine and when it failed I made the major error of following some telephone instructions from their "help-less" support desk - - - well their $#@% products now runs again (oh whoopie) -but- nothing else related to sql server will work. This includes: Visual Developer 2005 Express - Database Explorer SQL Server Configuration Manager, Surface Area Configuration, etc., etc. (not found) I tried to re-install SQL Server -but- the install fails, fails, fails... The failures are always with a corrupt msi file that has just been downloaded / expanded - yet fails I have registered and sent error reports -but- I still don't have a functional sql server version running and available. I do have "their" version ...Show All

• Jon Braganza SQL 2005 Express New Login

  Hello all Im new to SQL 2005 express so please bare with me, I have set up wireless peer to peer network and I am trying to access an express database from one machine to another. I can transfer files no problem. When I try to create a new login, I am forced to only select logins local to the machine with the database. When I try and create a new login by typing <machinename><windows account > of the second PC, SQL can not see it. I have tried both Windows authentication and mixed mode... no success. Any ideas Thanks Yes, I was reading that last night ... very helpful. I understand a lot more about the problem. I will check the logs again and see what the state is . ...Show All

• vonlinkerstain Server Application Unavailable

  Hi, Report is generated output 2000 pages. I was not able to export report in excel format. I am getting following error message. Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request. Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur. Please let me know the what could be the reason. How to resolve this problem Thanks ...Show All