Answer Questions

• Taddub String truncate error

  Yesterday my program was inserting and loading data in the database just fine, now when i try to do a myriad of things(make a paramatizsed search ad a favorites option) when ever i add data to the database i get a string trucate exception, basically its telling me the data im uploading is too large, problem is the feilds in the databse can take it.Its telling me the column im updating to has a string limit of 255 , but in reality the column its ...Show All

• Honestas Printing Reports From Report Manager

  AAAHHHH!!!! Whenever I select to print or preview a report from report manager, the margins are not set from what they are in the report. They default to 1inch every time. My report is configured to use different margins than what the print option specifies as a default. How do I fix it so the print option will use the reports default margins Please help, every report being printed is using many pages with partial columns on it and blan ...Show All

• Atul Bahl Getting error in SQL Server Destination

  Hi    I have two different database say, DB1 and DB2 one in server A and another one in Server B. Simply select all rows from DB1.Table1 in OLEDB Source and map it to another table in DB2.Table2 using OLEDB Destination.  Works fine. But if I select destination as SQL Server Destination, I am getting the following error: [Insert contact information for facility into ARBilling database [202]] Error: An OLE DB er ...Show All

• Aaron Brethorst MSFT sql server 2000

  This is my last attemp at trying to install sql server installed, which its been quite reluctant too, as I've spent the last 2 hours with no progress. I've downloaded MSDE2000A.exe from http://www.microsoft.com/downloads/details.aspx FamilyId=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en Installed it in the default directory. "C:\MSDERelA" And ran setup which returned this error "A strong SA password is required for securit ...Show All

• StefanH07 SSIS Reporting Source not showing up in VS.NET

  I have edited the rsreportserver.config and uncommented the SSIS data extension.  I can go into report manager and add a new data source and SSIS shows up as a type.  If I create a business intelligence reporting project and add a new "Shared Data Source" SSIS does not show up as a possible item. I am using the Sept CTP and RC of VS.NET. Thx The list of available data sources is determined by the fo ...Show All

• oz123 Error messages upsizing from MSAccess database to SQLServer

  I am trying to use SQLServer for the first time and I am trying to use the upsizing wizard on Access to get moved over to SQLServer. I am getting the following error messages: Connection failed: SQLState: '01000' SQL Server Error: 2 [Microsoft][ODBC SQL Server][Shared Memory]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' SQLServer Error: 17 [Microsoft][ODBC SQL Server][Shared Memory]SQL Server does not e ...Show All

• TheKell ForEach Config validation errors

  I have a Config file for a Data Flow that is utilizing a Configuration file. I have specified in the Configuration file to capture the Directory and FileSpec for the ForEach Enumeration. When I open the package, I get the following error: Warning 1 Warning loading ISOTypeLoss.dtsx: The package path referenced an object that cannot be found: "\Package\Foreach TC03 File.ForEachEnumerator.Properties[Directory]". This occurs when an attem ...Show All

• SweatCoder Error in datetime validation

  xml including a datetime attribute is failing to validate against a simple schema held in an XML schema collection The same xml validates correctly against the same schema in .Net Is this a bug (same behaviour is seen with dates) Repro follows: CREATE XML SCHEMA COLLECTION MyCollection AS ' <xs:schema xmlns=" http://www.w3.org/2001/XMLSchema " targetNamespace=" http://ns " xmlns:ns=" http://ns " xmln ...Show All

• Boman SSIS error listing

  Is there a list of all the SSIS Error codes and what they mean Ex. -1071607778 is an error code output when a lookup task fails to find a match. I haven't been able to find any information on the different error codes. Is there a description file or enumeration file that exists somewhere I think it's still hex, the L at the end is usually included in literals to denote the size of the integer - i.e. L = long, ...Show All

• VishalR SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• allenmpcx Dynamic Page Break

  Hi Guys, Is there any way to set page break based on user selection Actually I have 6 groups in my reports. Now at run time User will select for which Group he wants page break. ...Show All

• jxc222 Getting User name in a Derived Column

  Hi there, is there a way that I can set the value of a column to the currrent user in a derived shape For instance if I want to set the value of a column to the current data I can merely use GETDATE(). What is the current user equivilent Thanks I would check SQL Books On Line (BOL) lookup either CURRENT_USER, SYSTEM_USER or SESSION_USER to see which user you want to store, however, I don't ...Show All

• TimMulholland2487 Problem with multi-valued parameters since SP1

  Hi, after the installation of SP1 I have a problem with multi-valued report parameters. The option to select all values are gone. Is there a bug within SP1 Before the installtion of SP1 multi-valued report parameters works fine, the option to select all values was added automatically within the preview in Visual Studio 2005 and in published reports on the server. The server was migrated from SQL2000 SP4 to SQL2005. So long Lemmi ...Show All

• MarTim Configuring Reporting Services behind a firewall

  Hi, I put my SQL server behind the firewall, and I have put SQL_PORT and “Reporting Services Configuration” in the exception list. However, on a remote machine, if I use SQL Reporting Services Configuration Manager to change the Database Connection setting, I will get an error in the “Create a Grants Rights Script” stage. Looking at the exception, it points to an RPC problem. System.Runtime.InteropSer ...Show All

• VISSUP Execution of Package failed

  I am trying to design package which would copy all tables and stored procedures from one server to another. It used to be simple task in SQL 2000, there was wizard. However the new wizard does not work... I wrote SSIS package, but when I execute I get the following error: "Can not apply value null to property Login..." Any idea It seems to me that this new SQl2005 is not that simple to use like 2000. 2000 was a great product. I am consider ...Show All