Answer Questions

• Alewis Expand/Collapse all buttons in reports

  Hello! We just wonder if there is an easy way to incorporate  "expand all-collapse all" options in the reports we chose to drill down. Starting with a collapsed report is lovely but as the data get more it may be easier for some to see it all expanded. Thanking you in advance, Dimitris, Athens, Greece For the hopeful benefit of anyone else trying to get the InitialToggleState property to behave properly ...Show All

• Seb69 SSIS Performance Throttling?

  I have a multi-threaded C# application that loads a bunch of tables into ado.net datasets in memory for surrogate key lookups. Depending on what else is going on, it can process 100,000 to 170,000 rows per minute and usually utilizes 20-30% of each cpu. I tried duplicating the process in SSIS using the Lookup Transformation and caching enabled (cache size calculated at 2 * rowcount * bytes/row) with clustered indexes on the lookup columns. With ...Show All

• Dayn Barlow Execute a SSIS master package through an ASP.NET web app

  I am trying to execute a SSIS package via a web application built in c#.  I found a sample to read the output of a data flow task, but I'm stuck.  If I build the command line syntax for the package, create a DtsConnection object and set the connection string to the syntax, what else do I need to do   Thanks. Clay A call to the Variables collection with an index or name will return a Variable obje ...Show All

• Mundru Column Mapping in a Custom Component

  Does anyone know how to get destination coulmns to show up in the advanced editor for a custom component I have a custom flat file destination component that builds the output based on a specific layout. It works as long as the upstream column names match my output names. What I want is to allow non-matching columns to be mapped by the user as they can in a stock flat file destination. The closest that I have been able to come is to get the &qu ...Show All

• Dennis Cheng _ MSFT SSIS in Express edition

  We've been trying to convert an application from MSDE to SQLServer 2005 Express Edition. That application transfers some data form a SQLServer database to an Access database and the other way around. We have been using DTS, created/configured at run time by the application, to create the destination tables and to copy data from a db to another. In order to use DTS we distributed all components we needed, which are free. Now, SQLServer 2 ...Show All

• Majid8351 SQL Server 2005 Express Question

  Ok guys Im still learning this database stuff so im hoping somebody can clear up some fog. What I wanted to know was: 1. What is the "image" data type when setting up tables Does it handle .jpg .gif .bmp files If so would this be the option i would use to put pictures in and removes pictures from the database 2. Can I use the "bit" datatype to increase a number, such as How many registered Users, or how many times vi ...Show All

• Desolator144 Splitting a field

  hi all i have a field which displays the full name of our customers i.e. John Smith Is there a way of creating an additional fields first name , last name and automatical splitting the field display name first name last name john smith john smith Thanks rich Once you create the two new columns for first and last names you are going to get rid of the full name column, rig ...Show All

• Norman37050 Frror: 4000 max string literal in Expression for datareader component

  Hi, I have a datareader component of which i am dynamically setting its sqlcommand statement with expression (click the background of dataflow > properties > expressions). Now my sql select statement has about 600 fields so that makes my expression statment "select field1, field2, .....from table1 where field2 >=" + @[User::dateforfield2] but when i evalute the expresssion (which is right), i get the error: A string literal in the expre ...Show All

• Bjorne ERROR : Sql Server 2005CTP Setup

  Hi, i am trying to install Sql Server 2005CTP on windows server 2003, But there is a error as sql server setup was unable to add user NT AUTHORITY\NETWORK SERVICES to local group SQLSERVER2005SQLBrowserUser. Is the w2K3 server a DC   There are some notes around regarding a problem with SQL Server installed on a DC because there isn't a NETWORK SERVICES user. HTH, g ...Show All

• rlshearer Watermark Generation is Invalid Error

  We are currently doing a proof of concept using SQL 2005 merge replication.  However we are currently encountering the following errors: "The common generation watermark is invalid at this replica since it does not exist or metadata for changes not yet propagated may have been cleaned up." " The merge process failed because it detected a mismatch between the replication metadata of the two replicas, such that some changes could be los ...Show All

• neolace How To: Automatically run a script post-install as part of setup

  I need to provide a media kit to other DBAs in my organization so that when they run the setup.exe it will automatically apply some "hardening" scripts that my team has written. We want it to be a seemless part of the installation process so that the scripts can be applied consistently across the organization. Is there anyway to do this As the setup package is extracted and deployed to a directory during the install you could ...Show All

• HakanA There was an unexpected failure during the setup wizard.

  Hello! I'm trying to install Microsoft SQL Server (en_SQL2005_DEV_Servers_Sept2005). But when I do so I get: TITLE: Microsoft SQL Server 2005 CTP Setup ------------------------------ There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information. For help, click: http://go.microsoft.com/fwlink LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1314.06&Evt ...Show All

• howdy.dk How to extend existing FTP task ?

  Is it possible to extend existing tasks (specifically FTP task) Or I will have to develop one from scratch I want to extend the functionality of FTP task for ftp via a proxy server. Is it possible Any ideas Suggestions thanks, Nitesh You will have to implement your own, the FTP task is a sealed class. ...Show All

• Daniel Álvarez Loop through tables names to use with update

  Hi, I have a group of tables that need to be updated with all the same colums name. I want to make a SP then pass the name of the table to it. Is this possiable if so how do I do this Thanks Please do not use the undocumented stored procedures. They are meant for internal use and any dependency that you take on undocumented SPs/functions is risky for your code. It can be broken anytime due to a change wh ...Show All

• keyler Performance Question about: ExecStoredProcedure with ATL OLEDB Consumer Templates.

  Hi Guys, I need help in one fine tuning problem. I have developed one Datalayer that it have more implementations depedending on Database Server. Our older implementation it is based on the db Library from Sql Server. And this implememtation we have replace it with an OLE DB ATL Consumer Templates implementation. After comparing the performance of course and after we saw that the OLE DB ATL implementation faster is, we said it is a good ...Show All