Answer Questions

• shauli Using expressions in custom data flow transformation

  Hi, I'm creating a custom data flow transformation in c#. I would like to use expressions within this component in the same way as in the derived column component: specifying the expression as a custom property of an output column, then evaluating this expression for each row of the buffer and using this evaluated expression to populate my output column values. So I've added an custom expression on my output column, and set its expression type to CPET_NOTIFY IDTSCustomProperty90 exp = col.CustomPropertyCollection.New(); exp.Name = "Expression" ; exp.ExpressionType = DTSCustomPropertyExpressionType .CPET_NOTIFY; But in the ProcessInput method I don't manage to get the evaluated expressions, when I use exp ...Show All

• SweetTrombonist Line Break formatting

  I have a report with a narrow column. The column contains a comma delimited number list. If the length of the string exceeds the width of the column then the line breaks. No problem with this, except that there are breaks between the numbers. Example: 123,124,125,126 can be formatted as 123,12 4, 125,1 26 I'd like to force a break at a position within the string if its on the comma. Any thoughts on doing this in the Expressions window TIA anyone please Use vbcrlf. I'm putting a line break in my address with the below code. I tried \r\n, <br>, all kinds of stuff. vbcrlf is what I needed. =Fields!SHIPTO.Value & vbcrlf & Fields!SHP_TO_CTY.Value & ", " & Fields!SHP_TO_ST.Valu ...Show All

• Masoud Farahani Assign a value to a variable without using SQL Task

  Greetings once again, I am trying to achieve a seemingly simple task of assigning datetime value to a user variable at the point my package starts running. How can I do this without using a SQL Script Task Should I be using a script task for this or is there a simpler way to achieving the same thing Thanks in advance. Hi Rafael, Yes thank you. I am now using the System variable StartTime which is the start time of the package when it's run. That's perfect! There are a couple System variable that might have have what you are looking for: StartTime and ContainerStartTime. To see them go to variables and click in the gray icon with the X. ...Show All

• Eagle 101 Threat due to SQL Injection

  I have gone through a terrible situation a week ago. One website was working fine since couple of years and suddenly it was hacked. I checked the entire code in all the pages and it was not at all modified. When I checked the database, I found that javascript was inserted in it. As soon as a recordset was displaying it, javascript redirected that page to the hacker's site.. This was the mechanism was used by hacker. Which database can be more secure in such situations Nishith Shah it is better to have some client validation than no validation at all, and helps in terms of fixing out any possible attacks on the client side than on the server side, as there will be some perf issues trying to deal with validation on the server ...Show All

• s441 Remove SP1 or install SP2 Dec. CTP

  This sounds trivial but it has become an issue here. We had the original RTM of SQL2005 with Reporting Services installed and running fine. We were explicity NOT installing SP1 because of a feature that was removed from reporting services (the select-all checkbox in the multi-value parameter). This feature is supposed to be back in SP2. So wouldn't you know it, somehow someone inadvertently installed SP1 in the course of doing windows updates and now users are complaining about the missing select-all checkbox. I figure my options are to either install the SP2 Dec CTP or try uninstalling SP1 (if that's even possible). Any recommendations Ah! there is a hotfix addressing this very issue. I will try it. ...Show All

• Mikepy Reporting Services for SQL 2005 Standard

  How do you enable reporting services in SQL 2005 When i initially installed SQL 2005 i allowed everything to be installed, but now i do not see how to get into reporting services to get it started. I also look in the Surface Area Configuration Tool to see how to enable it but did not find anything. Can someone please help me yes, but it does not the correct instance as a choice Can you find the RS Config tool by going to Start->Programs->Microsoft SQL Server 2005->Configuration Tools->Reporting Services Configuration Also, can you get to Report Manager by going to http://<servername>/Reports Not sure if this is what you are looking for. Thanks, Sha ...Show All

• corne_mo Problem starting and using SQL Server Mangement Studio

  I am interested in working with SQL Server Mangement Studio instead of always having to set-up my data in visual web developer. I downloaded and installed it and when I start it I receive an error "Cannot create a stable subkey under a volitle parent key." I am including the details of this message below in case that helps. My only option is to continue. Not sure if this is causing the next problem, but I thought I should include it anyway. When I continue and try to open a database I receive the error "SQLWB - SQL Server Management Studio has encountered a problem and needs to close. We are sorry for the inconvenience." What am I doing wrong I have tried uninstalling it and then reinstalling it. I am pretty new to vis ...Show All

• enric vives Generate script of ALL database objects

  I need to be able to programatically generate the CREATE scripts for all objects for a given database. Basically, I need the same results as if I generated the script using SSMS and choosing to script all objects in the selected database. I'm hoping I could do this using the Scripter w/in the SMO Utility Classes. Can anyone help me out Thanks in advance! Hi, use the transfer method of the scripter: http://blogs.msdn.com/mwories/articles/smosample_transfer.aspx HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Well, yes, I see your point, but then wouldn't I have to write a decent amount of conditional code to to determine if I need a "GO" line or ...Show All

• Rykin Poe Cursor and order by

  I noticed that I cannot use ORDER BY in cursor, but in my case I need to order data in cursor. I'm thinking about selecting data for cursor from temp table where data is ordered but may be there are other decisions to get data in cursor ordered declare CR cursor ... for select .. from ... order by ... This query works: select MembersElectroValues.Date, MembersElectroValues.StartValue, MembersElectroValues.CurrentValue, (MembersElectroValues.CurrentValue - MembersElectroValues.StartValue) as [Difference] from MembersElectroValues where UserID = 11 order by [Date] Works Now I try declare @MembersValues c ...Show All

• Philipp Lamp need advise of basic knowledge

  I dont know where to put this thread, I just wanna ask a question..actually what is happen when subscription synchronized the publications among IIS process.. (SQLMobile) could you guys give me a diagram/schema of it thanks before What are you looking for If you want a detailed process regarding security and logins that get used using web synchronization, refer to this: http://msdn2.microsoft.com/en-us/library/ms345212.aspx If you have any other specific questions, please do post them. If the subscriber updates data and there are no conflicting publisher updates, the subscribers updates will be propagated to the publisher. If there are conflicts (publisher and subscriber update the same row or same column - ...Show All

• Warren LaFrance Receiving error when trying to backup master transaction log

  Hello: in sql serve 2k5 sp1 - I have all the dbs including master's/msdb's recovery model set to full. I am running the following command to backup master --> BACKUP DATABASE Master TO DISK = N''F:\DTS\backups\Master\Current\Master_full.bak'' WITH INIT, NAME = N''Master_full'', NOSKIP, RESTART, STATS = 10, NOFORMAT' which works fine but when i run a backup command to backup and truncate the transaction log i get the following error message... BACKUP LOG Master TO DISK = N''F:\DTS\backups\Master\Current\Master_log.bak'' WITH INIT, NAME = N''Master_log'', NOSKIP, RESTART, STATS = 10, NOFORMAT' 00:00:00 Sql Severity 16 Sql Message ID 3013 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message ...Show All

• Joannes Vermorel - MSP using Dts.LOG within event handler

  Hi, I am trying to Log my activities when OnError event handler fires I have defined few tasks in OnError event handler section so when there is a failer on the main package my OnError task runs ( which it work fine) now I am trying to add Dts.LOG from inside OnError evend handler task, and it seems like SSIS doens't give that function. I can use dts.log outside on the main package but not inside OnError section! any ideas Thanks Kolf wrote: Thanks for getting back to me I have created a log file and I'm using DTS.LOG("logging content",0,nothing) command in script task to write to the specified long now the problem is if an error happens in the package I have defined an onError event hand ...Show All

• neely Matrix control

  Hi all, I'm using matrix control as my reporting tools. But i found one trouble, how can i do my matrix become like this. Product A Product B Customer Price Qty Price Qty Customer A 10 10 140 160 Customer B 12 120 120 160 Customer C 10 10 110 140 The price and qty is the static column, and i would like to make the static row also. (show in red color) but i can't. Please help... Thanks Kendy Can you send me the RDL or upload a print screen of youe design mode Hi Idanl ...Show All

• AlexKL Create the package on the server, and execute through sql server agent

  Hi, Some of you guys seem to be gurus with the new Integration Services technology, so I hope someone can lend me some advice, as I haven't worked much with integration before. Ok, here we go. What I want to do is select some data from my database and export the result to a flat file (really a .csv file with values delimited by semicolons). Sounds like a simple thing to do Well, I'm sure it is when you know how to do it :) I know I could manage the same thing by writing a C# class that creates that .csv file, but the decision has been made to use Integration Services for these kind of operations. I created an SSIS project in Business Intelligence Development Studio, and created a package (I defined the task flow etc.). By choosing ...Show All

• CET PRG455 Data Flow Components

  Does anyone know a good place to download (or even purchase) custom data flow components Some ideas I've had (and I'm sure I'm not the first): Transformations: Filter Sometimes I just want to filter out certain rows. Unicode Converter Convert all unicode columns in place. Sequence Column Adds a column with a sequence of numbers. Or perhaps even random numbers. GUID Column Adds a column with a GUID. Destinations: Garbage Would act as a visual indicator in the designer that these rows are being discarded. You could add a data viewer right before it too. Log File Good for redirected error rows, writes them to various log files. Email Along the same lines as Log File, but sends off all the rows in a single email. ...Show All