How to find out PublicKeyBlob

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - Double Quotes in CSV File I have a lot of data coming in from CSV files. I have many CSV files (~20), with varying amounts of data- but some are quite large (largest file is ~230mb) I'm trying to import it into a SQL database via SSIS, but the data is a little bit frustrating. I have data that looks like this: "Text from vendor ""Vendor Name, Inc."" blah blah", "Next string", "", 1234 Many things to notice here - as well you can imagine some of the difficulties here. After parsing, this data should have 4 columns- Column1 Column2 Column3 Column4 Text From Vendor "Vendor Name, Inc." blah blah Next string <blank> 1234 The biggest problems stem from the double quotes mixed in with the comma because it is a comma delimited file with quotes as the text qualifier. The other problem is the double quotes with blank text ... which prevents me from doing a replace on the double quotes ... I think ... What would be your suggestions to help me parse this out (don't forget, some of these are large files with about 260,000 records- ) Thanks in advance, Rob Tag: How to find out PublicKeyBlob
  - 2
    - Can't Set variable Through Command Line Hello everyone! Bit of a problem executing a DTS command from a command line. I have the following variables defined in my package: UserVarchar1 UserVarchar2 UserVarchar3 All have a scope of Package, all of the mstrings The command I'm attempting to run in 1 line is: DTEXEC /FILE "C:\SSIS Packages\ED-Customers\Package.dtsx" /SET \Package.Variables[User::UserVarchar1].value;"10" /SET \Package.Variables[User::UserVarchar2].value;"30719" /SET \Package.Variables[User::UserVarchar3].value;"BILLTO" Description: The package path referenced an object that cannot be found: "\Package.Variables[User::UserVarchar1].value". This occurs when an attempt is made to resolve a package path to an object that cannot be found. DTExec: Could not set \Package.Variables[User::UserVarchar1].value value to 10. Any idea why Thanks for the help! Tag: How to find out PublicKeyBlob
  - 3
    - Subscription sends 2 emails We have SQL server 2005 Reporting Services SP1. In Report Manager I have a shared subscription that runs every hour between 8am and 6pm (I created the shared subscription in Report Manager, then modified it in Sql Server Management Studio to run the hours I wanted). I have a second shared schedule that runs Tuesday and Friday at 7am. For 2 separate report subscriptions - one uses the hourly schedule and the other uses the 2-day schedule, the first time they run during the day it sends 2 email - after that it sends only 1 email, as it should. I created a subscription to email a report when the report content is refreshed from a report snapshot. In Properties...Execution, I selected to render this report from a report execution snapshot, and selected my shared schedule. For the History property I have selected Allow report history to be created manually and Store all report execution snapshots in history; I am not using a schedule to add snapshots to report history in the History property. When I look at the job in Sql Server Management Studio, it has only ran once each hour. When I look at the snapshot history, there is only one record for each hour. Why is the first scheduled instance sent twice instead of once Tag: How to find out PublicKeyBlob
  - 4
    - String constants must end with a double quote. i got this error when i was trying to deploy the report... in the preview mode report is working good.... D:\report1.rdl The expression for the query ‘dataset’ contains an error: [BC30648] String constants must end with a double quote. can any one gimme the solution Tag: How to find out PublicKeyBlob
  - 5
    - Last working day from last year! Dear Friends, How can I retrieve the last working day from the currentyear-1 Thanks Tag: How to find out PublicKeyBlob
  - 6
    - PDF Rendering bug We are trying to publish a group of financial reports using SQL Server Reporting Services. We have hit a snag when we try to render the reports in PDF format. The leading spaces of each line are stripped in the output file. For example: Department 10.7240 - ICU Expenses SubDepartment -------- ------------- 1,200 100 454 150 Becomes: Department 10.7240 - ICU Expenses SubDepartment -------- ------------- 1,200 100 454 150 Does anyone know a solution for this problem By the way, we did upgrade to SP2. That did not correct the problem. Tag: How to find out PublicKeyBlob
  - 7
    - Relationships vs. no relationships Hello! I have a really small database in terms of number of objects, but very big in terms of data (possibly millions of records). I always try to design my databases to be in the 3rd normal form (at least I hope they are!), but sometimes (for databases consisting of just a few tables) maintaining M:N relationships looks like an over-bloated approach to me... Let's see an actual example. I have a table like this: Code Snippet Create table [Airfares] ( [OriginCity] Char(3) NOT NULL, [DestCity] Char(3) NOT NULL, [FareDate] Datetime Default getdate() NOT NULL, [Price] Decimal(9,2) Default 0 NOT NULL, [PriceChange] Decimal(9,2) Default 0 NOT NULL, [Wrong] Bit Default 0 NOT NULL, Primary Key ([OriginCity],[DestCity],[FareDate]) ) go Now, at first there also was an Airline nvarchar(50) field, which stored the airline name. But now the client requested to store fares for a few airlines if it's the same price and city pair. This way we can have 3 airlines offering the same price on the same itinerary for example. So I added a dictionary table called Airlines: Code Snippet Create table [Airlines] ( [AirlineCode] Char(2) NOT NULL, [Name] Nvarchar(50) NOT NULL, Primary Key ([AirlineCode]) ) go Now, there are two things I can do. We are obviously dealing with the M:N relationship type here. I can either add another nvarchar column in the first table, like Airlines nvarchar(255) and store something like 'AA,AB,AC' there - those would be airline codes. OR I could do it the proper way and create a cross-reference table which will connect both Airfares and Airlines tables (this will store as many records as there are airlines for that particular itinerary, offerring the same price): Code Snippet Create table [AirfareAirlines] ( [AirlineCode] Char(2) NOT NULL, [OriginCity] Char(3) NOT NULL, [DestCity] Char(3) NOT NULL, [FareDate] Datetime Default getdate() NOT NULL, Primary Key ([AirlineCode],[OriginCity],[DestCity],[FareDate]) ) go But this is starting to look overly complicated, isn't it The pros of this are I'm going to get real relationships, referential integrity, etc., but cons are more difficult code to query all this. What would you do Do we really need referential integrity everywhere Are there times when we're better not using relationships I have seen many programmers skip referential integrity before, which always made me think they are missing something important in a Relational Database Management System. Tag: How to find out PublicKeyBlob
  - 8
    - Merge replication reinitialization deleted all data Hello, When I reinitialized a subscription from SQL2005 db (publisher) to a SQL 2000 DB (Subscriber) and had the Upload changes before reinitialization turned on, the data from the SQL 2000 db didn't get uploaded. This resulted in a loss of 2 days worth of data. Does anyone have any idea if there's anywhere that data is kept. (unfortunately a series of errors caused our backups to not be running on the 2000 db either). Thank You Bob Tag: How to find out PublicKeyBlob
  - 9
    - How to create a SAPConnection in .Net Code with .NET Data Provider In the SQL Server Technical Article Micro s oft .NET Data Provider for mySAP Business Suite is a Code example of how to invoke a BAPI in .Net Code. First line shows how to create a Connection to SAP, but there is no information in which lib the SAPConnection type is stored: SAPConnection con = new SAPConnection ( "ASHOST=<SAPserver >; CLIENT=<client>;SYSNR=<sysnr>;USER=<user>;PASSWD= <password>;LANG=<logon language>" ); con.Open(); Does somebody can help me Tag: How to find out PublicKeyBlob
  - 10
    - What advanced features can be built with code in SQL Server 2005 Reporting Services? Hi, all experts here, Thank you very much for your kind attention. As we know the limited features on SQL Server 2005 Reporting Services, but we can build advanced features for it with coding on it. Would please any experts shed me any light on it in a summary like what advanced features could be added with coding on SQL Server 2005 Reporting Services Thanks a lot in advance for your kind help and advices. And I am looking forward to hearing from you. With best regards, Yours sincerely, Tag: How to find out PublicKeyBlob
  - 11
    - Accessing a real table from inside a TV UDF I am having problems opening a table from within my CLR UDF. Can anyone provide the proper configuration so that I can query existing tables I had originally posted to another area of the forums, but have not been getting any responses. The original thread is here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2363760&SiteID=1 Tag: How to find out PublicKeyBlob
  - 12
    - Adding a article causes ALL articles to be refreshed I have setup Transactional replication in SQL 2005 between two servers and have about 200 tables being replicated. The problem is that every time, I add or drop a table to replication, and start the Snapshot agent, it re-initializes every article and re-loads every article. This process takes 1 hour to complete and CPU usage goes to 100% during that time. This behaviour seems very different from SQL 2000 where I would start Snapshot agent and only the relevant tables were added/dropped. Has that functionality changed from 2000 to 2005 Am I not doing something right Thanks, Amir Tag: How to find out PublicKeyBlob
  - 13
    - Making a report smaller...? Alright. I'm stuck. I admit it! I have a bunch of names, and each name can have one or more 'roles'(operator, reader, key operator, etc. Just random words really.) attached to it. Using reporting services, I've managed to get the information I need with relative ease... the only problem is, with 900 some records to display, it's current length of 41 pages with just one column going down the left side of each page is not exactly preferred by my superior (can't say I blame him really. Looks kind of odd!) It looks like this right now: Name1 Function Function Function Name2 Function Function Name3 Function Function etc all the way down to page 41 I need it to look something like this: Name 1 Name 4 Name 7 Function Function Function Name 2 Name 5 Function Function Function Name 8 Function Function Function Name 3 Name 6 Function Function Function Function etc. Or some variation of... I've fiddled around, and merely adding one extra column to the initial table-layout with the same =(!UserName etc) just merely replicates the data in the second column... not giving me the new stuff. I'm quite new to reporting services, but none of the tutorials I've seen/done seem to accomodate for this... Heeelp! Tag: How to find out PublicKeyBlob
  - 14
    - Connect to SQL Server from a PDA Hi, I'm developing Pocket Pc application, my application establishes connection with a SQL Server Express 2005 Database. When I try to connect to the database I get an error "SQLexception", when i deploy and run my application both on my physical PDA (HP iPAQ) and the Pocket PC 2003 emulator in Visual Studio 2005. I am working in .Net Compact Framework 2.0 and my PDA runs Windows Mobile 5.0 . Can any one help me to solve this issue I use this code: string connstring = @"Data Source=myserver;Initial Catalog=mydatabase;Integrated Security=SSPI;User ID=uid;Password=pwd" ; myconnection = new SqlConnection (connstring); myconnection .Open(); and this is part of the errormessage: System.Data.SqlClient.SqlException qlException at System.Data.SqlClient.SqlConnection.OnError() at Tag: How to find out PublicKeyBlob
  - 15
    - Installing Express toolkit Hello I have SQL Express with Advance report tools installed. I have download the express toolkit to use the Business Intelligence, however after I have installed the add on, when ever I select the Musiness Intelligence Management Studio I have a browser looking for the file Devenv.exe file and a reinstall is not working. Can anyone help with this Tag: How to find out PublicKeyBlob
  - 16
    - SQL using 2003 AD Groups We have began to use Windows AUthentication for our SQL 2000 Server. When we llok atthe groups in AD we do not see any Domain Local groups Is there a reason for that Can I just add the group without browsing I assume DLG will work with SQL for security. Thanks Brent Tag: How to find out PublicKeyBlob
- Next
  - 1
    - SQL Server Windows Auth for ETL called by CreateProcessAsUser Hi, We are having problems in our project. We have ETL packages we call from our web app that we want to run and the user is the logged in one in the web. We use Windows Authentication in our web app and we used the CreateProcessAsUser to impersonate the user. <identity impersonate="true"/> is also in our web.config. We were able to call the dtexec successfully (with the user for the process as the logged in the web -- thus impersonation was successful.) But, a problem arises when we use Windows Authentication for the connection of the ETL to the db (SQL Server). When we run the ETL on our local machine using dtexec/dtexecui, it works fine. But when we ran it in our server, it fails. According to the event logs, it can't connect to the db server even though impersonation is successful. Btw, the client, web server, db server are three different machines. Any help is appreciated. Thanks! Tag: How to find out PublicKeyBlob
  - 2
    - deAttach database hi is there way by code to stop the sql server service and deattach a database and then restard the service thanks Tag: How to find out PublicKeyBlob
  - 3
    - Cannot add a new folder under a Reporting Server Project Hello, I was just wondering why is there no option to add a new folder under a reporting server project. I have a reports project and under it i would like to add subfolders like Daily and Weekly just to make it more organized. I understand that during deployment, we can specify to which folder we want the report(s) to be deployed, but what is the reason behind not having an option to add a new folder Thanks, maui Tag: How to find out PublicKeyBlob
  - 4
    - Generic calculated measure Hi I have to create a calculated measure which is applicable for 16 measures. How can i specify it in a generic manner for eg: create member currentcube.ytd as sum(ytd(),[measures].[sales units]; here my scenario requires the calculation of YTD for many other measures also other than sales units so can i have something instead of [measures].[units], so that it will be generic. Thanks in advance. Tag: How to find out PublicKeyBlob
  - 5
    - SSIS Randomly Empties Out Column Data While Using Flat File Source I'm having a problem using the Flat File Source while using the underlying .Net classes to execute SSIS Packages. The issue is that for some reason when I load a flat file it Empty's out columns randomly. Its happening in the Flat File Source Task. By random I mean that most of the times all the data gets loaded but sometimes it doesnt and it empty's out column data. Interestingly enough this is random and even the emptying out of columns isnt a complete empty, its more like a 90% emtpying. Now you'll ask that is the file different everytime and the answer is NO. Its the same file everytime. If I run the same file everytime for 10 times it would empty out various columns maybe 1 of those times. This doesnt seem to be a problem while working with dtexec or the Package Executor utility. Need Help!! Tag: How to find out PublicKeyBlob
  - 6
    - Validating the parameter text box Hi, I have one date parameter in my report. The user will be able to manually enter or use the calendar control. In the case of entering manually, is there any way to validate the input string How can we prevent users from entering alphabets Also, is there any way to reduce the length of the parameter textbox. Can you please help Thanks, Sonu. Tag: How to find out PublicKeyBlob
  - 7
    - aggregation question Aggregation SUM adds the numbers together. Is there a similar aggregation function that returns the product of all the numbers Thanks Tag: How to find out PublicKeyBlob
  - 8
    - date output format Hi, I have the following problem. I have made a parametered report where i ask a begin date (@datefrom) and an end date (@dateto). when i enter my dates via the little calendar is see the format dd/mm/yyyy When i do a preview of report i have a textbox with the following expression : = "Total work time from " & Parameters!DateFrom.Value & " to " & Parameters!DateTo.Value but the output of the date format is mm/dd/yyyy. What can i do to have the output format dd/mm/yyyy Vincent Tag: How to find out PublicKeyBlob
  - 9
    - how to change the actual data filename i'm hoping someone can help me out with this problem. i have a database called Tracking.mdf and its associated logfile Tracking_log.ldf i need to build another database based on the above with more tables and keep the data separate hence the requirement to make a copy of the tracking data file i've tried changing its name but it will not attach. i can change its database name to whatever i want but somehow can't find out how i can say change its actual filename to Tracker.mdf and Tracker_log.ldf would someone be able to help me out. thanks. Tag: How to find out PublicKeyBlob
  - 10
    - MSResultSetGenerator does not work any more I try to generate a typed result set. I first added a new data source to my project and then changed the custom tool property of the .xsd file from MSDataSetGenerator to MSResultSetGenerator. This was working a few days ago, but recently, it stopped working. I now get the following error when I right click on my .xsd and then "run custom tool": Error 102 Custom tool error: Failed to generate code. Illegal characters in path. C:\Users\Mathias\Documents\Visual Studio 2005\Projects\WindowsApplication9\WindowsApplication9\NorthwindDataSet1.xsd 1 1 WindowsApplication9 I tried this in several projects, for example I created a new WinForms project and then just added the norhwind.sdf sample database. I use Visual Studio 2005 + SP1 + SP1 Vista patch (beta) + SQL Compact Edition + ADO .NET Sync Services CTP on Vista Ultimate. Things I tried to repair this so far: - VS2005 repair setup - Reinstalled SQL Compact Edition - Reinstalled ADO .NET Sync Services - Reinstalled VS2005 SP1 Tag: How to find out PublicKeyBlob
  - 11
    - Best Practice for Counts/Distinct Count Measures for Filtered Data Let's say the Count/Distinct Count measure is based on filtered data. When the situation allows, is it better to do a CASE statement with 1s and 0s from the table in the DSV and then do a SUM on this field Or is it better to create a new Named Query in the DSV filtering out the data through the WHERE clause based off of the original table and then do a DISTINCT COUNT measure on the newly created Named Query If there's no clear cut answer as to what is the "better" approach, please offer up the advantages and disadvantages for both. My preference is best performance. An Example : Measure: Active SKU Count Products dimension has product_key, SKU and Status In the DSV for the Products dimension, should I add a CASE statement: CASE WHEN [Status] = 'Active' THEN 1 ELSE 0 END AS [Active Status] Then create a new SUM measure based on the Active Status column. OR Create a new Named Query in the DSV: SELECT * from Products WHERE Status = 'Active' Then create a new DISTINCT COUNT measure based on the SKU column from the new Named Query Tag: How to find out PublicKeyBlob
  - 12
    - another dynamic assembly loading problem (XmlSerializer) I am having an issue with loading dynamic generated assemblies in my CLR SQL stored procedure. I have tried turning on the "Generate serialization assembly: ON" and have read numerous articles regarding work around but have been very unsuccessful in getting this to work. The problem lies in when the code calls XmlSerializer xmlSerializer = new XmlSerializer(typeof(MyClass)); where MyClass is a generated schema class using XSD. Since it wouldn't auto generate the serializer assembly, what I did instead was created a new class library project with only that line of code and provided the class definition within that same class without any of the attributes from the XSD. I am still getting an error on that same line. So what I did next was do the manual sgen and made sure it generated with the same signed assembly snk file. Manually loaded into sql server and still got the same error. Any ideas why this is Code Snippet public partial class TestClass { [Microsoft.SqlServer.Server.SqlProcedure] public static void testThis() { MyOwnClass myClass = new MyOwnClass(); //Serialize message to xml XmlSerializer xmlSerializer = new XmlSerializer(typeof(MyOwnClass)); } } public class MyOwnClass { private string hi; public MyOwnClass() { hi = "1"; } public string Hi { get { return hi; } } } Tag: How to find out PublicKeyBlob
  - 13
    - How do you add multiple data sources to a report? I have a query that pulls information from 2 different servers. I have created two shared data source now I need to connect them to my dataset. Tag: How to find out PublicKeyBlob
  - 14
    - How to capture error upon connect error? I would like to continue processing when a connect error occurs. Set oServer = CreateObject("SQLDmo.SqlServer") oServer.LoginSecure = True oServer.Connect oName Would like to continue if the connect fails rather than have the script fail. How do I do that Thanks! Tag: How to find out PublicKeyBlob
  - 15
    - Server Upgrade We currently have a stand alone production server SQL 2005 STD + SP2 and plan to upgrade to clustered SQL 2005 Ent + SP2. What's the proper way to upgrade I want the existing server instance use Ent engine. Tag: How to find out PublicKeyBlob
  - 16
    - How to reflect base table changes in cursor I have a small question - I have a cursor which is running on the table and i am deleting some rows from the same table during the cursor loop but it didnt reflecting it. Is there is any other option i need to sepcify during declare. declare localshowcursor cursor for SELECT video_release, programname, network, date_encoded, time_encoded, COUNT(*) AS Number FROM SigmaStageTemp s Where program_type = ‘1’ Group by video_release, programname, network, date_encoded, time_encoded Having count(*) >= 10 Order by video_release, programname, network, date_encoded, time_encoded Please help Tag: How to find out PublicKeyBlob

Andreas Brosten

I have created a custom authentication for Reporting Services, and it works great if I edit the RsSvrPolicy.congif like the following:

But the guideline says a strong named assemly is better, so I created a strong named assembly and registered it in the GAC, but how do I find out the PublicKeyBlob to enter in the config file

Regards Andreas

Top

Re: How to find out PublicKeyBlob

Tartan

Use 'sn -Tp assemblyfilename' from a VisualStudio command prompt.

Top

Re: How to find out PublicKeyBlob

Tartan

After you run the command, I think if you RightClick -> SelectAll, then hit the Enter key, it should copy the entire command prompt contents to the clipboard for pasting.

Top

Re: How to find out PublicKeyBlob

Andreas Brosten

Ahh, thank you!

// Andreas

Top