During SQL Server SP2 timeframe a pending security update from the .NET Framework team was announced. That fix, when released would break any SSIS package using scripts. In response to this SQL Server Integration Services provided a fix into SP2 (as well as corresponding fixes for RTM & SP1) that would mitigate this issue, including log messages that would point to the KB below. The .NET Framework fix was released on Tuesday 7/10/2007 and thus we expect to see it surfacing on SQL Server Integration Services applications using scripts (both in data flow and control flow), most likely on machines running €˜pure€™ RTM and/or 64bit installations.
The related KB article describing the impact to SSIS packages is available here:
http://support.microsoft.com/kb/931846
Here are the details of the .NET Framework 2.0 fixes:
http://support.microsoft.com/kb/928365 (for Windows XP/2003/2000)
http://support.microsoft.com/kb/929916 (for Windows Vista)
I've let my Vista Ultimate 64-bit installation on a Dell Precision M90 pretty much have its way with automatic update which has worked reasonably well...until now.
I've installed the MS CRM 3.0 laptop version into my Outlook client. Everything was working well until automatic update tried to install Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) which failed. It also rendered the Online/Offline functionality unusable and, with the installation accomplished while I was Offline, all of my CRM data is sequestered. Uninstalling the CRM client and SQL Express with it while I'm in an Offline condition has some real downsides so I thought I'd try to fix the SP2 issue through this group and then work my way back through the product teams.
The Windows Update installer returns a failure code of 2B22.
I've tried the downloadable SP2 upgrade but only the SQLEXP32.EXE seems to be available through any of the links in the SQL Express pages I've yet visited, not the WOW version.
Hi,A person from my company's IT department approached me a few days ago saying that they followed some instructions on a recent security vulnerability in IIS whereby they where told to turn impersonation off in IIS. I'm afraid I don't know the exact procedure, but I do know that it took down all of my applications with the following error:"Failed to generate a user instance of SQL Server"I do NOT have impersonation enabled in my web.config, however all of my connection strings look like the following:<add name="myConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|myDatabase.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>From what I've read, this type of connection string, which VWD 2005 generates by default, is not the correct way to go about connecting to a database. Could this be my problem??Thanks!
Hello, friends, here is my problem: I installed sql server express on a naked Windows xp pro with SP2; of course, framework 2.0 installed, and MS-installer 3.1 installed as well. I also installed ssmse. Everything worked fine. Then I installed all windows updates via Windows Update in internet. Now suddenly, when starting ssmse, I get a Warning Textbox with Header "Microsoft SQL Server Management Studio Express", then the yellow triangle with the exklamation mark, but NO TEXT AT ALL, and the OK-button. So unfortunately, I do not know what to do. Only thing I found out was, that in all updates, the culprit surely is framework 1.1 update. Before installing this, everything worked fine, afterwards, well, see above. When I click the ok-button, everything works fine, I can log in into sql server express and do what I have to do. So my only solution at the moment is just to ignore the warning - not the best way. Couldn't find a better solution until now. Could anybody help?
we have some SSIS packages using a dataflow sourcing data from DB2 using an oledb connection. These were working when we were using the oledb for DB2 drivers as supplied in HIS2004, but since upgrading to HIS2006 some of these dataflows are failing with the error shown below.
Also a DTS package running the same query against the same database(s) is working fine.
Can anyone shed any light on this? Do we need a patch?
The error text we're seeing is:
[OLE DB Source [1380]] Error: An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft DB2 OLE DB Provider" Hresult: 0x80040E14 Description: "".
[DTS.Pipeline] Error: The PrimeOutput method on component "OLE DB Source" (1380) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
[DTS.Pipeline] Error: Thread "SourceThread0" has exited with error code 0xC0047038.
I used a non-printing character (hex 97) in one of my derived column transformations which made my data flow task comopnents disappear, and throw the error during execution:
"Warning: The DataFlow task has no components. Add components or remove the task."
In order to fix the package, I thought I could open the .dtsx file in code/raw form, find the misbehaving character, remove it, and I'd be good to go.
But I can't figure out how to read the .dtsx code to find the character (despite my best efforts with a hex editor).
Anyone have any ideas? Fixing this package could save me days of rework...
Can anyone tell me where I might find the Class and Sequence Diagrams for the SSIS framework (for Custom Components)?
I've just started trying to create some Custom Transform Components and I'm really struggling to get my head around the component lifecycle (i.e what methods are called when, with what arguments, and why) with just the BOL documentation to guide me.
I have Vista Ultimate installed and within Vista .NET Framework 3.0 is installed as a part of the operating system so I can't remove 3.0 Now for MS SQL Server 2005 Express I need .NET Framework 2.0 and the SQL Server 2005 doesn't work with .NET Framework 3.0 Can't install 2.0, get the message that 3.0 is already installed. Please help me!!
I have several nested sub-total groups that are all coded to "page break at end". I don't know how to tell RS to suppress the page break if one sub-total immediately follows another. The initial HTML output seems to be smart enough to do this suppression on its own, but when I export to PDF, all the page breaks appear. This causes several pages at the end of the report with one line per page. Perhaps, if I could explicitly suppress these page breaks, the PDF would render properly. How can I do this?
I wanted to know how to insert line breaks while updating the database. Even if I have a number of paragraphs......everything is displayed as one single paragraph. How do i display text in paragraphs ?
I want to get this straight, and so far it's not really working the way I want. So, here it is.
I got a table with multiple groups (3 grouping, Manager, Sale Type and Product Type). I want the Manager name being shown on every new page (which I enabled using the "Repeat on new page" property). This works fine so far. Then, I want that every time I have a new "Sale Type", it's on a new page.
This is where it gets hard. I can't get it to work the way I want.
If I set the group 2 with a "Page Break At Start", the first page of my report is blank (which is kind of logical looking at the property name). Same thing goes with "Page Break At End", but the last page is blank.
Is there any way to just have a table grouped without any blank page? Can I dynamicaly disable page breaks if it is the last page / first page of the report?
Here's what I want:
Manager: Some guy Sale Type - Normal Product - Mitsubishi Lancer [some report detail goes here ...]
Page 1/2 ** PAGE BREAK **
Manager: Some guy Sale Type - Rent Product - Honda Civic [some report detail goes here ...]
I have a report with multiple data regions. Each region has its own dataset potentially. I want each region to appear on its own page. Sometime I get a page break where I want it and in other instances within the same report, the breaks are ignored and 2 regions will appear on the same page. I tried imbedding the data regions in rectangles and setting the page break on the rectangle but this doesn't seem to help. There doesn't seem to be any predictable pattern. Any ideas?
Hi y'all I want my written text in an textarea store in a sql database. Which format do i have to choose so sql server understands <br>. Now i use ntext and i get a scrambled <br> (2 cubes)Thanks in advance.Grtz
Hi, We have an internal mail system, but when the user writes something into the textbox (textarea), he often uses enter to get the message over several lines, our problem is that when the message is saved to the database and retrieved, all the breaks are gone and its all on a single line. In the database its stored inside a field called "message nvarchar(MAX)". How can i preserve the linebreaks? example, user writes: Hello,Nice day,to go fishing. output, after it has been saved and retrieved: Hello, Nice day, to go fishing.
When I changed the SQL sa account password (it was blank) and then tried to connect to SMS remotely via SMS Administrator Console, I get Connection Failed. It seemed to work for a about 20 minutes and then I get "Connection Failed" when I try to run the console remotely. I used the SQL Enterprise Manager to change the sa password and then I used the SMS Administrator Console to set its SQL Server account to sa with the new password under Site Properties. When I switched it to a blank password in SQL and SMS, it started working again.
From the Application Event Log I seem to be getting a lot of these messages (even now - and it's working): "The description for Event ID ( 1001 ) in Source ( SQLCTR70 ) could not be found. It contains the following insertion string(s): SQL Server not running."
I have also gotten: "The Open Procedure for service "NM" in DLL "nmperf.dll" failed. Performance data for this service will not be available. Status code returned is DWORD 0. "
I don't see any messages from SMS in Event Viewer.
I am fairly new to SQL Server. I work for an Internet sofware company building web sites for our customers.
I am trying to insert JavaScript ad tags into a text field in my db. It seems that when the calling web page is rendered the line breaks are removed from the js code and it does not function properly. I've doubled up all of the single quotes and the line breaks appear in the insert statement but do not make it to the front side of my web site.
I'm trying to figure out how to this do with TSQL and preferablythrough joins rather than by using cursors or temp tables. I havemultiple time spans for multiple individuals that I would like torollup together where they don't actually have a gap in coverage.ID StartDate EndDateZ000001 01/01/1996 9/30/1996Z000001 10/01/1996 12/31/1998Z000001 01/01/1999 04/30/1999Z000001 01/01/2000 12/31/2000Z000001 01/01/2001 12/31/2001I would like to be able to "roll these up" in order to reflect theactual time frames so that it would like this:ID StartDate EndDateZ000001 01/01/1996 4/30/1999Z000001 01/01/2000 12/31/20014/30/1999 to 01/01/2000 is, of course, a legitimate break where therewas a date difference of more than one day.Thanks in advance for any ideas.
I'm having a bit of an issue with a report that I've been working on for the last several days. The report is set up to use a table to print out information grouped by customer, with each customer's information showing up on a new page. This is all fine and well, but it seems that the table is generating page breaks after each row; in other words, since the table has twelve rows (10 group header rows, one details row, and one group footer row), twelve pages get printed, with the data from each row showing up at the top of the page, and nothing else.
The odd thing seems to be this: when I turn off page breaks (initally set to occur at the end of each group), it continues to insert these breaks, as long as the details row forces the group footer onto another page. This doesn't happen every time the report is generated. Short of getting into the XML that makes up the report definition, I've tried every trick I can think of to get this to stop.
Any suggestions?
Edit: I should also mention that the report previews just fine, but only spits out the 12+ pages when printed or exported.
We have run into a really bizzare problem after upgrading to SQL Server 2005 SP2. We have a bunch of matrix reports that have interactive sort in the upper left hand corner, the sort based on Numeric and Text fields. For Example
=Fields!City.Value
=Sum(Fields!Pax.Value)
Now for whatever reason after upgrading to SP2 and making NO CHANGES to the reports or under data sources, interactive sorts that use the =Sum(....) no longer work but interactive sorts on text values still work.
I have a sales report which is grouped by customer with a total for each customer and then a new page afterwards for the next customer - this works great however I am trying to put a grand total on (all customers) - this is appearing on a seperate page!!! - on crystal I used to put this field in the summary section, so it would appear on the bottom of the last page, has anyone got any ideas??????
I have SSRS 2000, and am trying to render a report in Excel. My report has a table, and in the properties section of the table I have the PageBreakAtEnd set to True. When I run the report and export to Excel, I get one long report, and no different sheets as expected. If I export to PDF I don't get the page breaks after the table as expected. What have I done wrong?
I face the following problem. I have a report with a list and under that list i have a table and a chart that sums the values from the dataset. In my list properties i have set that their should be a page break after the list (meaning that my table and chart should start a new page). In my listgroup properties is hava also set a page break after each group.
Now when i preview my report in visual studio, the groupdetails are displayed in one page and the summed table and chart are on a second page. when i do a print preview, i get 3 pages but my sum table is on the second page under the last groupdetail and the chart is 3rth page. When i publish my report on the reportserver and i do the same through my browser, i get the same error. Why doesn"t the page break after each group doesn't work ? Why does the page break after the list doesn't work ? is this a bug ? Is there a way to set a pagebreak manually on the report for example in a hidden textbox ???
can any one tell how to force a page break for rdl files dynamically.I mean the page break should appear at constant height in every page,if we include the page break at group level or table level then scrolling appers in webpage.so can we force a page break based on report page height so that if records are present or not page break should be down it should not shrink to top.
Hi, we run an app that is linked across a SQL Server 2000 (Server 2003), IIS (Server 2003) and a notes server. Everything has been running sweet till the daylight saving kicked in a week last sunday, the clocks re synced on monday (SQL was 8 mins out) and connection within the app was lost and needed IIS and SQL services restarted. Eventually all was up and running till today, IIS resynced Monday at 3AM but once SQL resynced at 9:45 the app stoped and only restarted after SQL services got restarted and then IIS services (IIS Admin and its 2 associated services) got restarted. Time will resync on both servers at + - 3am next Monday and i am expecting the whole thing to go the same way..... Does anyone know why W32Time would cause SQL network connectivity to 'blip'? This time, the times on both servers matched before and after.
Have checked Event logs on both and nothing on or after the time.
The server syncs fine, the other databases on the server are unaffected.
I have a field in a db table which is like a chat history.I need to update the field with a user's input (put into a multiline text box) and append that to the beginning of the field.The problem is that I want to maintain line breaks when I retrieve the field into a multiline textbox (aka textarea) and can't figure it out.I've searched around and have seen lots of solutions for converting line breaks into <br> tags, but those people are trying to output to a label.I'm using an update command in my SqlDataSource like this: UpdateCommand="UPDATE [account] SET [history] = @history + history WHERE [id] = 1"With a parameter declaration like this: <UpdateParameters> <asp:ControlParameter Name="history" ControlID="TextBox1" PropertyName="Text" /> </UpdateParameters>If I try to concatenate in a or CHR(10), the characters are literally inserted. Like this for example (this is the last variation I tried).... UpdateCommand="UPDATE [account] SET [history] = @history + CHR(10) + history WHERE [id] = 1"How do I store a CrLf programatically?
inserted a record with an identity field I had a '-- comment' right Select @data = @@identity
This select failed - @data was NULL I changed it to SET @data = @@identity This also failed @data was null
I then change to the follow which worked - Why would the different form of a comment make a difference? I was the only one in the database, there were no other changes. I could make the logic block fail or succed by just changing the comment syntax.
inserted a record with an identity field I had a '/** comment**/' right Select @data = @@identity
We are currently using continuous transactional replication from an OLTP type database to a Reporting database. We recently changed the 'sa' password for the first time since replication was introduced and now the Replication Log Reader job fails to start.
This is the error from the Job Log:
Message 2008-04-14 15:18:24.894 Copyright (c) 2005 Microsoft Corporation 2008-04-14 15:18:24.894 Microsoft SQL Server Replication Agent: logread 2008-04-14 15:18:24.894 2008-04-14 15:18:24.894 The timestamps prepended to the output lines are expressed in terms of UTC time. 2008-04-14 15:18:24.894 User-specified agent parameter values: -Publisher OASV-SQL1 -PublisherDB georgiaoas -Distributor OASV-SQL1 -DistributorSecurityMode 1 -Continuous -XJOBID 0xCE146F975BC43043AB1ECBF42F801C43 -XJOBNAME OASV-SQL1-georgiaoas-1 -XSTEPID 2 -XSUBSYSTEM LogReader -XSERVER OASV-SQL1 -XCMDLINE 0 -XCancelEventHandle 00000730 -XParentProcessHandle 0000075C 2008-04-14 15:18:25.034 Status: 0, code: 20015, text: 'Login failed for user 'sa'.'. 2008-04-14 15:18:25.034 Login failed for user 'sa'.
When we change the 'sa' password back to the previous value, we can start the Log Reader without issue.
We have tried restarting the SQL Server Agent process without success. We have not restarted the SQL Server process due to the server hosting production databases.
I have found "as have many others" that when adding dynamic visibility " tosub_reports and tables etc" to SSRS reports then pagebreaks are switched off. Has anyone found a workaround for this? Or am I doing something wrong
My report has one page per record grouped on an id. Each record has possible additonal information in another table which if present I would like to show on a new page. I can get this to work ok by just appending a subreport to the report based on the value of a report parameter, however this does not meet the requirement. I need to have the subreport on a new page for each record.
Using an MS A2K front end running on WinXP and ODBC connections to SQLServer 7 on Win 2K server; there are about 10 users who access thefront end via Terminal Server and use the same front end; there areabout another 10 users who run a copy of the db on their local machine.SQL server has 2 databases, with approx. 20 tables between them (oneis for processing ckts from a remote sql server for local use, theother is a site database).There is one user that always has to refresh the same single table eachtime a release of the db is copied to his local machine. Once thetable is refreshed in link manager, the front end is good to go...untilthe the next release is made (about every 2 months--for changes inbusiness rules). We have gone and checked his WINS and DNS settingsand at this point, the only difference between other users and this onewho can't get the table normally, is that he is using a different brandmachine (he uses a toshiba satellite, all others use a ibm thinkpad).Since purchasing a new laptop for him is out of the question, doesanyone have a suggestion for correcting this problem?TIA for the help,EricO.
I have 2 tables that I have set to PageBreakOnStart. They have conditional visibility. What I am seeing is that if i put an item in ToggleItem, the page break functionality does not work anymore.
Is this by design? I would have expected the page break to be there if the item is visible, and not if it is hidden.
I am having trouble setting conditional page breaks to my reports.
i.e... I am having a report where I need to allow user the option to set page break between a group or not.
Based upon the option selected by the user, I need to add page break to the report. I tried with all possibilities inside Sort and Group dialog box, but could not figure out how to toggle the option at runtime.
Does anyone know how to implement page breaks on runtime? Help me plzzzz!! I really need this to be done€¦Thanx in advance for any help..
I'm using Rpt Svc in SQL 2000. I have a report that uses a table data region. Is there a way to control placement of vertical page breaks? As in when the page is just too wide to print on a single sheet of paper.
