Answer Questions

• Giampiero Is it possible to create a bar code in SQL reporting?

  I need to be able to create a bar code in SQL reports. Do I need to get a three party tool or do you have anything that can help.   Thanks I found a better choice instead of using fonts.   Barcode Professional .NET for Reporting Services http://www.neodynamic.com/Products/BCRS/BarcodeRS.aspx tabid=78&prodid=7 Cheers Hi, I am trying to use a TTF f ...Show All

• Skyruner2 SSIS Import and Export Wizard Data Sources

  I'm just beginning to use SSIS (bracing for a steep learning curve due to lack of helpful documentation) and am starting out trying use the Import and Export Wizard.  On the "Choose a Data Source" page there is a dropdown for the Data Source.  I see a list of possible data providers, but not one of "Microsoft OLE DB Provider for ODBC drivers," which is the one I wanted to use because I'm trying to connect to an obscure databa ...Show All

• DinoBob Can you use Report Builder with SQL Server 2000 and Visual Studio 2003?

  This is a really silly question and I think I know the answer to it. I installed Reporting Services on our SQL Server 2000. It worked really well. I then read the article by Mike Gunderloy about Report Builder and that’s just what I wanted for our <smart> end users to design their own reports. I watched the presentation from http://www.microsoft.com/sql/2005/bi/BIn_Ad-HocReporting500k.wvx and was impressed. I typed http://localh ...Show All

• Antara data not flowing out of flat file source

  my package has a flat file source that should be extracting data from a text file passing the data to the next component in the data flow. the package validates fine, but the data isn't flowing. however, i see the data in the source component. i added a data viewer between the source and the next component to see if any data flowed and saw no data. can someone suggest how i should go about trying to debug this thanks. Bob Bojanic wro ...Show All

• Jay D Full text searching in advanced services edition

  I have installed the advanced services edition but cannot find out how to build and populate full text catalogs. Nothing shows on the MSSMSE tool and when I try to use a sql command to create a new catalog it says that the full text service is not installed. Am I missing something The Full-text Search menus in Management Studio have a dependency on SQL Agent, so they were excluded from Management Studio Expres ...Show All

• ursus zeta How to design Data Warehouse for Traditional OLTP System

  I am successfuly runing my relational database system designed in SQL 2000, and it has data for last 5 years, runing smoothly. Now, i want to create a data warehouse for my database... How do i create From where to get start Any Sample Project that demonstrate How to design DW for OLTP system. Any Example that converts Northwind DB to DW There are several ways for you to start. You can read a little bit about Start and S ...Show All

• adlammons SQL Query Question for performing a Find and Replace on a column

    Hi Everyone: I am new to SQL, and I would like to request if someone could provide me with a query that could do a find and replace in a column in MSDE. I have an image path column in a table, the current image path is set to /images/xxxx.gif I would like to add another folder so the image  path looks like this --> /images/imagesA/xxxx.gif The problem is i have 4500 records to update, so I cannot do this manually, so ...Show All

• U412 One Table in the Database

  What happens if I try to put all my tables (entityTypes) into one table I have more than 300 attributeTypes.And there are lots of null values in the records of that single table. Other than wasting space if I put a clustered index on my entityType coloumn in that table.What kind of performance penalties to I get Definition of the table ENTITY --------------- EntityID > uniqueidentifier EntityType > Tells the entityTypeName . ...Show All

• Sachin K. Singh Global variable scope - across package

  Hi,    I have a Main.dtsx file which is having executing some 10 .dtsx packages.  Can I declare a variable in Main.dtsx and use it in all the other packages which it is executing   Note:  I am using Yukon April CTP Thanks Harini Thanks.  This is what exactly I want. Yes you can. This post explains how: http://blogs.conchango.com/jamiethomson/ ...Show All

• manticor Does SQL Server support all languages using Unicode

  I have an international Internet business and I use SQL Server with the Unicode field types of nchar, nvarchar and ntext. I seem to have no problem with customers entering Slovakian, Slovenian, Romanian, English or German, but Hebrew and Japanese do not seem to work. The resulting data coming back from the database after adding a record is garbage. I had the software email me the data immediately before adding the data to SQL Server. It was appe ...Show All

• Magneto Error with Subscription

  Hai, this is Srinivas Reddy. i have a problem in reporting services. i have a parameter in one of my report, that parameter contains morethan 1300 rows. it is working fine with execution. but when i try to create a subscription, even the subscription page is not getting opened, instead i am getting an error "Error in XML document(1,10272)". I came to know that when this parameter contains less than 1213 rows (values), i am not gett ...Show All

• tusk How to sort table in sql2000 with ipaddress(format x.x.x.x) as column with nvarchar datatype in ascending order

  How to sort table in sql2000 with ipaddress(format x.x.x.x) as column with nvarchar datatype in ascending order without using stored procedure Ex: Table: netComputers(3 rows) Column Name: ipAddress (string data type) ipAddress 0.0.18.1 0.1.1.2 0.0.0.1 Sql query : if I use the query Select ipAddress from netComputers order by cast( replace(ipaddress,'.','') as ...Show All

• -Codeman- DateDiff + Where am I going wrong?

  Hi, I'm creating a sample report in Visual Studio 2005 to be used in SSRS 2005. I'm attempting to do some conditional formatting like so: =IIF(DateDiff("Day", Fields!Jobseeker.Last Interview.Value, NOW()) > 14, "Red", "Transparent" When ever I try and preview the report, VS throws a wobblie and closes down. The format of the Last Interview column is dd/mm/yyyy. Any suggestions Thanks, Steve ...Show All

• CJatFenway Stuck between "Failed to generate user instance" and "An attempt to attach...failed"

  I wrote an application using Visual Studio 2005 beta 2 which uses a SQL Express .mdf file, included in the project, for the database.  After installing Visual Studio 2005 RC and the SQL Express that comes with it (I followed all of the uninstall instructions first) I can no longer add a SQL Express database to any of my projects, nor can I open the SQL Express database in my original project.  When I try either of these tasks, I get th ...Show All

• AParker Bulk insert in to a partitioned View?

  Greetings once again my SQL friends, I am getting the following error when I attempt to complete my data flow task. The destination is a partitioned view but I get the following error message when I run the package : Partitioned view 'PRICE_DIM' is not updatable as the target of a bulk operation How to solve this problem Hi, Bulk insert operations are not supported for partitioned views. See for more d ...Show All