Answer Questions

• Fr0Gs Creating Error Output for Custom Components

  Hi, I have a 2 custom components - source and destination. I want to create an error output for each, to allow the users of my component to handle errors the way they choose. I only found a property in IDTSOuptut90 named isErrorOut - a boolean property indicating whether this output is an error output or not. Does anyone have additional documentation / articles / code samples regarding how to really populate the rows in the error out ...Show All

• Swami Pete how do you fix the ssis XML Password error

  I have a simple package that I created. it gets information from an excel file using the excel connection and then imports it into a sql2005 table using the ole db connection. the job runs fine in the BI environment. and it will run fine once I've imported it to the server. However when I go to run it as a job step using the line dtexec /Ser Name /U User /P xxxxx /SQ "\SalesSuccess" it errors out with the following error. Fai ...Show All

• LesioS RDP & Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The c

  As a starter i tried to modify and translate the Personal Website Starters kit from the VS2005Team SDK. When i'm working on the machine were it's installed , under debugging, all works great. But when i try to develop from my laptop, via RDP on the develop machine, i've got this message and can not debug (connect to the SQLxpres Server) Does anybody now a solution Failed to generate a user instance of SQL Server due to a failure in ...Show All

• kline SQL Server 2000 failed to attach database

  hi, everybody, i copy the *.mdf and *.ldf files from another computer to my computer, and run my computer's SQL Server to attach database, but it gives me a error like this: file *.mdf's file header is not a valid file header, FILE SIZE attribute is incorrect. i don't know why, plz help me. thank you very much It appears that the physcial file is damaged, I suggest going back to the original machine and running checkdsk and other ...Show All

• nevelshute still cannot run my job

  this is the scenario. first i created a dts in my computer(local administrator account) this dts writes in an xls file in a local path for instance c:\tests... this dts uses a vb script to run this task, then.. i save it local and run it from my bids and finishes ok, after that i change the protection level to server storage and copy it to my target server.. in this server i log on with an administrator local account using windows authenticat ...Show All

• ykessler Unexpected error during Sept. CTP setup?

  Hi, During the Sept. CTP setup I get the following when it tries to install the Workstation tools.  Anyone else get this and work around it "There was an unexpected failure during the setup wizard.  You may review the setup logs and/or click the help button for more information." I didn't find anything in the logs and when setup asked me to find more info online regarding this message it said there is no further info on this error. Th ...Show All

• Bharat Gohil Changing ports sql 2005 listens on.

  Menu chain on sql 2005 standard server side: "Sql Server Configuration Manager"> "Sql Server 2005 Network Configuration"> "Protocols for MSSQLSERVER"> "IP Addresses" tab> Changed the IP1, TCP Port (didn't change IPAll, whatever that is used for) Stopped/restarted sql server Client side: "Sql Server Configuration Manager"> "Sql Native Client Configu ...Show All

• xfx ReportViewer CopyLocalProperty

  What are the benefits/advantages/disadvantages of setting the CopyLocal property to either True or False for the ReportViewer control reference I would like to know this before I roll the application out to a secure internet site to be used by our Clients. Thanks Hi Brian, I've added a reference to the Reportviewer dll to my project. It appears under References folder in the Solution Explorer window. ...Show All

• AreaBlue error: 17194

  I cannot use sql connection. This is my connection string 'Conn.Open "Provider=SQLNCLI;Database=dbname;Server=.\\MSSQLSERVER;UID=username;PWD=test123;" The error message appears on browser is Microsoft SQL Native Client error '80004005' Client unable to establish connection due to prelogin failure /Connect.asp, line 8 in SQL server ERRORLOG, it shows Error: 17194, Severity: 16, State: 1. The server was unable to load the SSL provider library n ...Show All

• blairio Command USE with variable

  Why I can’t use the command USE with variable declare @banco varchar(20) select @banco='xpto' USE @banco I have try in other way without success DECLARE @banco varchar(50) declare @SQL varchar(50) select @banco='xpto' print @banco select @SQL='USE '+@banco print @SQL exec(@SQL) Help me, please. Rodrigo Here is one way with using sp_MSforeachdb and DBCC DBREINDEXALL Both of these things are un ...Show All

• Richard Hathaway Moving a SQL2K publisher to a SQL 2005 instance.

  Hi, I have to move a SQL2K instance (publisher) to a SQL 2005 instance and i prefer not to re-snapshot all the databases being replicated due to the large size of the databases. As i understand all i need to do is    1. Ensure all published databases are in readonly mode. 2. Stop the replication (by either dropping subscriptions, publication or stopping replication agents). 3. Move the databases to the SQL ...Show All

• mvt Is there a possibility to auto-generate a SQL Script for cataloging assembly?

  Visual Studio Team Suite does that with its deployment task.   For other (cheaper) editions, you might want to check out Niels Berglund's custom deployment task:   http://www.sqljunkies.com/WebLog/nielsb/archive/2005/05/03/13379.aspx   -- Adam Machanic SQL Server MVP http://www.datamanipulation.net --     <Alexander Greiner@discussions.microsoft.com > wr ...Show All

• Brad Peterson MSFT Data Type Mismatch in Oracle lookup on 64 bit

  I have SS on 64bit trying to do a lookup to an Oracle 10G db - I'm reading from a SS table and using a column to be part of the 'where' clause on my lookup against a table in oracle - I get Data Type mismatch even though both columns are strings (the input SS column is mapped to a string Derived column which is then mapped to the lookup). If I run on a 32bit machine it works fine. I have a task that can successfully update the Oracle DB table (o ...Show All

• narend Unable to load client print control

  When you display a SQL Reporting Services report to the screen in the header there is a Printer Icon displayed. When we click this icon we get an error message "Unable to load client print control ". Does anyone know what we need to load or what we need to do to resolve this so that we can print the report directly to teh printer, rather than having ot prinnt the web page, which also prints all the Web headre information ...Show All

• MarkPaxton RSClientPrint Download

  I have an asp.net application which is launched from our B2B site. The primary purpose of the application is to allow our external clients access to reports, along with the ability to export and print. The RS2005 report viewer component was used within the application to render the reports. The problem is when the our client users click on the print button on the report viewer's tool bar, many of them are receiving a window asking them if they w ...Show All