Answer Questions

• fly2moon2 Import export failed : Data conversion failed

  [Source - chn_employee_vew_test_txt [1]] Error: Data conversion failed. The data conversion for column "Column 42" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". [Source - chn_employee_vew_test_txt [1]] Error: The "output column "Column 42" (136)" failed because truncation occurred, and the truncation row disposition on "output column "Column 42" (136)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. I using Locale (People's Republic of China) and code page of 936 (Simplied Chinese GBK) with header row delimiter {CR}{LF}. I am us ...Show All

• AlanKohl Can't uninstall Reporting Services

  I need to reinstall Reporting Services but during uninstall I face the following error: "The setup failed to read IIsMimeMap table. The error code is -2147024893" Nothing seems to help with the problem. Regards, Ksenia Paul, were you ever able to find a way around this I'm also having this problem. Any suggestions Thanks KDog! Uninstalling IIS worked! FOUND FIX! 1) Uninstall IIS 2) Disable my primary web server Apache 3) Uninstall RS Worked like a charm!     Kristian Wedberg The suggestion works great...thanks Sumit I ran into the same problem. Based on KDog's suggestion, I ...Show All

• the_chad Handling flat files that do not exist

  Hello, I have a package that contains 22 data flow tasks, one for each flat file that I need to process and import. I decided against making each import a seperate package because I am loading the package in an external application and calling it from there. Now, everything works beautifully when all my text files are exported from a datasource beyond my control. I have an application that processes a series of files encoded using EBCDIC and I am not always gauranteed that all the flat files will be exported. (There may have not been any data for the day.) I am looking for suggestions on how to handle files that do not exist. I have tried making a package level error handler (Script task) that checks the error code ("System:: ...Show All

• Lars Larsson MDMP files and SQLDmpr

  These two file types are eating up my AS2005 log folder. What are they Can I delete them Thanks in advance. Mark I am having the same problem: the files inetinfo.exeRandomNumber.mdbp or .hdmp and RadomNumber.cab and .txt are eating away my Disk Space and I do not know how to stop it. Please help me. TIA. Gilda This forum is about SQL Server Analysis Services - your question seems to be about Internet Information Services. Please post in the appropriate forum. These files are generated when Analysis Services crashes. If you have a lot of them - it means AS crashed a lot. You should contact PSS and send these minidumps to them - they should be able to diagnose the problem and work w ...Show All

• fripper How to display money type data properly?

  How to display money type data properly, with commas every 3 digits I've tried : CONVERT (money, ProjectCost, 1) AS ProjectCost but it gives me the type as 1234.56 no commas in it can anyone help me with that thanks! Convert (varchar, ProjectCost,1) as ProjectCost The convert Style parameter only works when converting to a character data type. BobP I got it. Thank you! ...Show All

• davros51 share variable with child

  How a parent package can share its variables with child when calling it using Execute Package Task Andy Leonard wrote: Hi Fahad, Phil is correct. A couple things to note: the variable shared between the parent and child packages must have the same name and data type. Hope this helps, Andy They shouldn't need the same name, is my understanding, as you choose the "value" parameter of the variable you'd like to map to. Hi Fahad, Phil is correct. A couple things to note: the variable shared between the parent and child packages must have the same name and data type. Hope this helps, Andy Thanks guys, You're very smart. :) Parent Package Variables.... R ...Show All

• xcvzzzzcv Cannot connect to SQL Server 2005 April CTP from remote computer

  Hi, I am trying to connect to a SQL Server on a Windows2003 w/sp1 Server from a remote computer but always seem to get the infamous "Access is denied or Server Does Not Exist" error.  However, if I try to connect from the machine that is running the server, there is no problem. (Used sql account, server=mixed authentication) The windows 2003 Server is a single server installation with .Net 2005 Beta 2 Team Suite, Team Foundation Server and Sql Server - Installing these items  took me a while, but eventually I managed to install from scatch to end without any installation errors. I have triple checked that both TCP 1433 and UDP 1434 is open on my router and under windows firewall. I have ensured that TCP/IP is enabled in SQL Ser ...Show All

• delas Replicating DDL in Sql 2005

  I am using Sql 2005 and merge replication. I am relying on the feature where schema changes are replicated to subscribers but I have come across a situation where schema changes stop being replicated. This is the scenario: I create a database and publish it for merge replication. I add subscribers. If I need to change the published database I can use ALTER TABLE ddl and the subscriber gets the changes. If I have to add or remove a merge article as part of a database change I specify the @force_invalidate_snapshot=1, @force_reinit_subscription=1. No any ALTER TABLE statements following the article change will NOT be replicated. Is this a known 'feature' Is it because @force_reinit_subscription is set to 1 Can anyone ...Show All

• UtterMan internal activation of service broker

  Hi, there, I'm a Chinese fan of Microsoft SQL Server 2005. Through studying for MS SQL Server 2005, now I have a question about ‘internal activation of service broker’. At the moment I have done a test. The description of test is as following: Firstly I set the status of the activation to be off (ALTER QUEUE [dbo].[TargetQueue] WITH STATUS = ON , RETENTION = OFF , ACTIVATION ( STATUS = OFF , PROCEDURE_NAME = [dbo].[Usp_HelloWorld] , MAX_QUEUE_READERS = 5 , EXECUTE AS N'dbo' )). And filled the queue with 100000 Messages. Then that running another application caused the usage of the CPU achieve 100%. Secondly reset the status of the activation to be on and monitored the ‘ sys.dm_broker_activated_tasks ’. The insta ...Show All

• NorCis Security in Linked Server

  I have setup a linked server on the same computer but different instances of sql. When I call the sprocs an error occurs... The message is... The OLE DB provider "SQLNCLI" for linked server LINKEDSQL does not contain the table ""product"."dbo"."AccountTable". The table either does not exist or the current user does not have persmissions on that table. I've checked the table "AccountTable" and it does exist. The database exist also which is "product". I also configure the linked server's RPC to "true" and timeout to "200". The linked server is also configured to use a single username and password which exist on the instance of sql that the linked serv ...Show All

• John Zolezzi Importing data from MS Access using DTS 2005

  Guys, I am new to DTS 2005; having trouble on how to connect to MS Access to pull data what kind of connection manager should I use (OLE ) and what specific Data Flow Source type Please respond. Thanks Glenn, Thanks; still having some issues; am trying to connect from access and dump to an excel spreadsheet. I used the OLE DB to connect; and in my data flow task, I created a connection manager for Excel (specifing file path where the spreadsheet was located). I then identified an Excel Spreadsheet as my data flow destination point. When I executed, I got the following errors: Error: 0xC0202009 at Pull From Access, Excel Destination [357]: An OLE DB error has occurred. Error code: 0x80040E21. Error ...Show All

• JavaBoy Count(*)?????

  I am trying to find the significance of using the Count(*), does that mean it only pulls one value according to the query that the procedure calls or what i am a lil lost on this particular feature CREATE PROCEDURE dbo.Sales ( @UserName varchar(256) ) AS DECLARE @Exists int SELECT @Exists = COUNT(*) FROM SalesPerson WHERE UserName=@UserName IF (@Exists <> 0) BEGIN SELECT SalesPersonId FROM SalesPerson WHERE UserName=@UserName END ELSE BEGIN SELECT -1 END RETURN GO because exists returns after it finds the first value count continues until it counts all the values Denis the SQL Menace http://sqlservercode.blogspot.com/ For this particular SP, y ...Show All

• Musa_Tariq_Raza Reference the reports DataSet from Code

  Hi All, From my reports code I would like to do some things with the reports DataSet. Is it possible to reference this object from within the report code Thanks, Eric http://msdn2.microsoft.com/en-us/library/ms157274.aspx ...Show All

• Ori&amp;#39; MSMQ

  Does anyone know or have any idea what's the use of msmq or how can this apply in ssis. Thanks Find out what MQ is- Message Queuing (MSMQ) ( http://msdn.microsoft.com/library/default.asp url=/library/en-us/msmq/html/ff917e87-05d5-478f-9430-0f560675ece1.asp ) Find out about the MQ task you have in SSIS- Message Queue Task ( http://msdn2.microsoft.com/en-us/library/ae1d8fad-6649-4e93-b589-14a32d07da33.aspx ) can you help me how am i going to use this the "MSMQ task in SSIS" thanks Sean Schade wrote: Do you have a requirement to use MSMQ, or are you just curious about it If you're just curious about it then google both terms and do some research. If you have ...Show All

• Gregoryew Group By Question

  The snippet below is from a log parser script that works fine: 'Create Select Criteria strSelect = "SID, " _ & "resolve_sid(sid) AS UserName, " _ & "count(*) AS Number_of_Logons " ' Create query text strQuery = "SELECT " & strSelect _ & "INTO 'C:\CitrixLog.csv' " _ & "FROM \\acsbcitrix\security, \\acsbcitrix2\security, \\acsbcitrix3\security " _ & "WHERE EventID = 528 " _ & "AND to_string(timegenerated,'yyyy-MM-dd HH:mm:ss') like '2006-10%' " _ & "GROUP BY SID " _ & "ORDER BY Number_of_Logons DESC" I wanted to change the script so that rather than getting a given months worth of data, I could get a vari ...Show All