Answer Questions

• Joe Mirwaisi Change the type of an expression container

  Hi, I use expressions to build the SQL query that is executed by the data flow. Today, I ran into an issue. For the first time the SQL query has exceeded 4000 char so the expression cannot be validated and it is not possible to use it. Is there a way to change the expression datatype to nvarchar(max) instead of the default nvarchar(4000) Thanks, Philippe So i am back in the business of using mu ...Show All

• Adrian Griffith dataflow and expressions

  Greetings! I am attempting to implement the following case statement BEFORE getting the data in to my destination table but I don't know how to create an expression for it. In the mapping section of my OLE DB destination component I can only do mapping but I can't actually manipulate the data before it gets to the destination table. What do I have to do to implement : case when SOPD.PRICE_TOP_NUMBER is NULL then -8 else S ...Show All

• CajunReaper SP1 Question Report Builder Question

  Will the new Service Pack allow us to use a connection to Oracle and Report Builder Thanks, SP1 does not yet allow Report Builder to connect to Oracle. We currently have a Beta in place to try out this new feature that should appear in SP2 of SQL Server 2005. If interested, you can contact JonHP(AT)Microsoft.com ...Show All

• VISHAL VIDHALE Reporting services

  Hi all, I have three data sets to populate a report. and after this I have to use these datasets in an expression but they cause these error s which says that the report item needs to be in the same scope as the dataset and that it cannot be used in an aggregate function. Can we use multiple dataset in an expression inside the a report if so how (p.s one of the datasets is a stored proc) what this sproc does is that it give a header name for my ...Show All

• Global IT Solutions string to int????

  Hi, I need to convert a string to an integer. I've tried using CAST and CONVERT but the problem is that my data also contains alphanumeric characters, in wich case I want the result of the conversion to be 0. The above commands gives an error if the data is not pure numeric. What can I do Here is a quick example. select case when isnumeric(i)=1 then cast(i as int) else 0 end from( select '123' i u ...Show All

• Varun Krishna XSLT transform dropping spaces, CR's

  I have an XSLT transform that works perfectly using the msxsl.exe utility. When the same XSL file is run through an SSIS XML transform, the character spacing and carriage returns embedded in the XSL templates are mostly (but not completely) dropped. Any comments on why SSIS is behaving differently than msxsl.exe What to do Thanks in advance, Richard Michael - Thanks for the response. Yes, I unde ...Show All

• stepanielauym "Cummilative Sum"

  Hi all, I've got a view with the following data: (Sample) Class Date Month Year Day Target Actual Variance MName ==================================================================== DropBalling 01/07/2005 7 2005 1 165000 117850 -47150 July DropBalling 02/07/2005 7 2005 2 165000 92550 -72450 July DropBalling 03/07/2005 7 2005 3 165000 171900 6900 July DropBalling 04/07/2005 7 2005 4 165000 66850 -98150 July Lancing 01/07/2005 7 2005 1 90000 44100 ...Show All

• Jonas Beckeman Linked Server in SQL(2005) Job

  I have a linked server to Sybase using MSDASQL. I can query the tables from the linked server using SQL Management Studio (windows login). When I put the same query into a job, it failed to work. The query is simple: SELECT * from MyLinkedSvr.RemotDB.dbo.RemoteTable The linked server setting include the login mapping, which maps my windows login and sa to the remote sybase login. I'm using SQL 2005 9.0.1339 on Windows2000 Pro w/ SP4. SQ ...Show All

• Rajashekar connection error

  When i am running the package using dtexec utility on the command prompt i'm  getting this error for every connection that is not windows authenticated. however in the debug mode it is always working    Source:  Connection manager "connection_name"    Description: Failed to decrypt protected connection string for server "server_name" with error 0x8009000B "Key not valid for use in specified state. ". You may no ...Show All

• _mubashir Migrating from Non-SQL Server/Windows Sources

  Our company has an enterprise product that uses SQL Server as its db server.  When we implement our system for new customers, it is quite a chore to move their historical data from their legacy system(s) to our system.  I am evaluating tools to make this process easier. Given that our product runs only on SQL Server and SSIS comes free with 2005, SSIS seems like the logical choice.  I have performed numerous tests in SSIS using SQ ...Show All

• BrianD65 MergeSynchronizationAgent must be instantiated on a Single-Threaded Apartment (STA) thread

  I am using the exactly same sample code on http://msdn2.microsoft.com/zh-cn/library/microsoft.sqlserver.replication.mergesynchronizationagent.synchronize(SQL.90).aspx to synchronize a push subscription and get this error while executing the statement: subscription.SynchronizationAgent.Synchronize(); I even added a [STAThread] attribute on the method but still no luck, anybody can share a light on it Thanks! mengruts Does anyone ...Show All

• LoveMeSomeCode I am not able to load two different images dynamically in an Image control

  HI, Base on pagenumber, i need to display a particular image in first page and another image in next page. there are two images and has to be displayed alternatively in the pages. but, it is displaying only one image everytime. I am using Exteranl and URL based concept and using parameters to pass the values from the front end to the report One more thing I did was, I place two image controls and passing the URL through two parame ...Show All

• Schenz74 Error processing events

  Let me start by saying this is my first crack at NotificationServices.  I installed a sample from "Microsoft SQL Server 2000 Notification Services" that processes stock events (I think it may be a copy of the one in the help file).  I get the following error when I place a file in the EventsWatchDirectory.  I have uninstalled and reinstalled SQLXML and MSXML3 (I already had MSXML4 sp2).  Any help is appreciated. <Notific ...Show All

• pcgeek1011 Unable to synchronize the row because the row was updated by a different process outside of replication.

  Hi All I am getting this error during Merge Replication "Unable to synchronize the row because the row was updated by a different process outside of replication." I could not reproduce this error in my development enviornment, can anyone tell me what is cause of the above error and how do I reproduce this error in my development machine I am able to get which is outside process The Conflict Type is 10 for above error whic ...Show All

• maliakkas IS install after SP1 fails

  Subject says it all; I need to install IS, but the installer says v.2047 of IS is already installed; it it NOT installed. When I go to add/remove programs, under the Sql Server 2005, it allows me to try to install IS, but that also fails, as no components are found for installation. This is SS dev edition, W2003. I can uninstall SS2005 and start over, but is there a quicker way to fix this 1. yes 2. yes ...Show All