Only Title

Answer Questions

• JoeKYTse Use opendatasource

  I want using opendatasource, to insert given in an file .xls without formatting some, an file .xls simply created and saved. Then I want that a application one that this in machines goes customers in my net, activates one procedure that I go to create with this opendatasource and carregue the archive .xls that goes this in these machines customers tb, remembering that the bank this in a server, thus I want to know as I must place date source for ...Show All

• Kevin McKinney Securing the MS SQL Server 2005 database on client side

  Hello! I developed database driven .NET application and I need to deploy it. I faced a problem, which is "how to protect my database against direct access". I use MS SQL Server 2005 Express Edition as a DBMS and appropriate database. I want to make possible to manipulate with data in my database only through my client application. 1. How do I define SA password and instance name in silent mode of MS SQL 2005 EE installation with M ...Show All

• Hinesdev Annoyed with SQL Server 2005 Imponderables - Help!?

  Hello, upon our recent upgrade to SQL Server 2005, there are three issues that have plagued me that I cannot find a workaround for, despite much forum scouring. 1. I have a DTS package that I migrated to SSIS.  The migration seemed to go smoothly, and I can successfully run the SSIS package.  However, when I try to create an SSIS job from it, the job fails to run.  I merely get a "The step failed" error message.  I've ...Show All

• Pawel from TETA Another Stored procedure problem with VB 2005

  Solving one problem leads to another. This post is related to my last one (Can't see stored proc results) so this will look familiar to some of you.  This sproc is called by a VB front end.  It retrieves a name based on an ID#: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[usp_CrimRecTest] -- Add the parameters for the stored procedure here @caseID nvarchar(12) AS BEGIN -- SET NOCOUNT ON added to prevent e ...Show All

• Al_xx How to hide HTML viewer toolbar while viewing reports in IE

  I am trying to access the report which I had deployed in the server using Internet explorer. I was trying to view only the report in full screen, by excluding the HTML viewer toolbar (which contains Properties, Subscriptions and Zooming options..etc). For this I have tried by passing URL access parameters..like http://lcs1/Reports/Pages/Report.aspx ItemPath=/flag/Appi &rs:Command=Render&rs:Format=HTML4.0&rc:To ...Show All

• philipbennett25 Remote Error Problem

  Hi all, I created a report that uses resultset generated from integration service. I managed to run the report on BIDS and also by command prompt on both server pc and remote pc. (I created the report from remote pc and deploy the report from remote pc also). When I try to run the report from report server, the following error came up (I already enable remote errors): An error has occurred during report processing. Cannot ...Show All

• Edusie Changing SQL-command with a script

  Hello I want to change the sql-command that is behind a ole db datasource with a script So that first the script is run and that the sql-command is changed Somebody who has any idea Thats indeed a dramatic change Can you do it then in Microsoft Visual Studio for Application Thx   g4rc wrote: Thats indeed a dramatic change Can you do it then in Microsoft Visual St ...Show All

• kavita1000 Reporting Service design for SOA based application

  ALL, I have a specific query around the implementation that I have in my application, details below-   I have modules in our application which are implemented as service , each   (applying SOA principle) and each have their own database.   There is some reporting functionality in each of the modules and we have architectural principle guideline not to make cross service database calls from a module, all the cross dat ...Show All

• seerg Valid Characters for SQL Express SP1 Strong Password

  Hello, I am attempting to upgrade an MSDE SP4 named instance to SQL Express SP1 and it is failing with a message that I must use Windows Authentication to continue the upgrade. The thing that I noticed is that when I specify an '@' sign in my sa password the upgrade fails, but if I specify a "#' sign instead the upgrade runs successfully. The strong password rules appear to be that 1) the password must be greater than 8 characters ...Show All

• Xavier Navarro FTP Connection Manager: Set FTP password using a variable

  Hi, I want to setup an FTP task that is portable in the sense that all it's connection parameters are stored in variables. I can create expressions for properties ServerName and ServerUserName but not the ServerUserpassword.  Is there an property that I missed, there seems to be properties for everything else except the key piece of info, the password. I could create a script component using the FtpClientConnection method as a las ...Show All

• wmerydith Extending BI studio

  Hi,   I need to add a custom menu option say under the Tools menu in the BI studio for SSIS projects. Is it possible to extend BU studio using Visual studio addins, or Visual Studio SDK (VSIP).    The Visual studio addin works fine; however I want my custom menu option to show up only when I have a SSIS project open so that I can perfom my custom step whenever the user selects the menu option Thanks, -Suri ...Show All

• Joel Brabant Hierarchical XML import?

  Hello, Can anyone point me at a tutorial or sample that shows how to use IS for importing an xml file containing hierarchically arranged records I have a file which contains multiple orders , the orders contain multiple line items.. the file also contains an element with details of the file source etc... So, I want to make an insert in the FileLog table an then make inserts into the orders table .. then make inserts into the Or ...Show All

• HalfABrick help on SELECT

  Help on creating correct select query on the following table where customer = multi-race ( that is, customers that have value ‘1’ on more than one race category) Thanks! CustomerID Black AmIndian Asian White PacIslander Hispanic NoRaceDisc 32501 1 1 32677 ...Show All

• srishu Calendar slow to load

  Is anyone else experiencing performance problems with reports that use the calendar control for date parameters   Whenever we load a report that uses a calendar it takes several seconds to fully load the form (you can see something like this in the status bar:"...ReportViewerWebControl.axd OpType=Calendar...").  This is not a serious problem, but if the user tries to use the control before it fully loads then the page throws javascript ...Show All

• kosmab Report Authoring Using Report Builder

  We have deployed multiple report builder models and the number 1 user complaint is that every report builder report created can only have 1 table or 1 matrix or 1 chart in per .rdl (or report created). Anyone found any way around this Is there a fix planned This was an intentional design constraint for this release. There are no workarounds. We are definitely looking to include this functionality in a future r ...Show All