Answer Questions

• Argenta Can notification services record bounced emails automatically?

  Hi, I've not used SSNS yet but am considering it for an up coming project. One of the criteria is that "SMTP delivery failures are to be recorded against the recipients". Is this something that happens "out of the box" with SSNS If not would it be difficult to write something to do it Cheers for any advice. Martin Try this posting.... http://groups.google.com/group/microsoft.public.sqlserver.notificationsvcs/browse_thread/thread/d86305394d873284/cecc579ef585b9da lnk=gst&q=kate+bounce+email&rnum=1#cecc579ef585b9da HTH... Joe ...Show All

• ChesChesney OpenRowSet fails in SQL 2005 even when Ad Hoc allowed

  I have a Windows 2003 64-bit server running SQL 2005. I am trying to run an OpenRowSet query, but I am getting " "cannot create instance of linked server" (null)" The OpenRowSet I am trying to run was running perfectly fine on the same machine before we moved to SQL 2005 and runs fine on many other machines - so I do not think it is an issue with the openrowset itself. When I've had his issue on other machines, I have run the following: sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure ‘Ad Hoc Distributed Queries’, 1; GO RECONFIGURE; GO And I could then run the Ad Hoc queries fine. But, when I try ...Show All

• Jeff Stouse Login failed for user 'XXXX\ASPNET'

  Hi all, I review my server report from my asp.net app through reportviewer, and I got this error: Cannot open database "myDB" requested by the login. The login failed. Login failed for user 'XXXX\ASPNET'. I use username and password to login my app, and 'XXXX\ASPNET' is my ASP.net service account. Any idea Thanks, Jone XXXX\ASPNET is a default user for your ASP.NET applications. I think that in your Report DataSource, you setup "Use Windows Authentication (Integrated security)" credentioals. As a result, you try connet to DataSource with XXXX\ASPNET credentials. Change credentials of your DataSource to something else. PS. Before deploying from VS, chec ...Show All

• Euclidez Reporting Services Data Source Types

  Could someone explain to me the difference between the types of data sources available to reporting services, and the advantages and disadvantages of each please. Shared Private Dynamic Can you store a data source connection string in a configuration file to be used by a report Thank you Hi, shared -- can be used with other reports private -- is only used by this report dynamic -- never heard of that, I guess that means that the data source can be defined by an expression which will evaluate at runtime how the connection string has to look like. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Thanks, but can you store a connectionstring in ...Show All

• ACCOUNTINGONLINE.US Mining cubes vs relational

  I've not found much guidance so far about the pros and cons of mining OLAP cubes vs their underlying fact and dimension tables. Can anyone offer advice in this area, or point me to more info about this Thanks, Kevin Generally I recommend mining OLAP cubes when you are mining results that OLAP is good at producing, otherwise you should mine relational tables. OLAP is not particularly good at returning large amounts of detail data. However, if you were mining stores, for example, and your inputs were total sales of products for particular months/categories, or even sales acceleration of such by store, those measures are very difficult and slow to obtain through relational means, and I would recommend OLAP ...Show All

• Sukhbir Dalal Error Starting Script Editor in SSIS

  I am having a problem in the Business Intelligence Development Studio. When I add and try to edit a Script Task or a Script Component, I click on the Design Script button and get one of two errors. For the Script task I get an error that states: Cannot show the editor for this task. (Microsoft Visual Studio) For the Script component I get: Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio) For some reason or another it just will not start Visual Studio for Applications. I have uninstalled an re-installed several times. I have also researched and discovered that there is a bug when C# tasks are include in the project. However, this is not the case. Please help! (I think the underlying cause is s ...Show All

• joeycalisay unable to load package

  I have created an SSIS package in BI dev studio which i can debug and run fine. I have saved the dtsx file to a production server which calls it using dtexec as part of a batch script (we are migrating from foxpro). I am getting the following error that i dont understand. I dont know if this is relevant but i cant execute packages by double clicking them as DTexecui is not installed (not sure why as i have installed the client tools and integration server). Hardware is Dell poweredge 2850 dual xeon 2gb ram with win 2k sp4 and sql 2005 sp1. Microsoft (R) SQL Server Execute Package Utility Version 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:29:19 Error: 2006-07-06 12:29:20.75 Cod ...Show All

• mkamoski Changing column length of a replicated table

  Can I increase the length of a varchar column of table involved in transactional replication without dropping and recreating publication/subscription Any help/short-cuts/undocumented features greatly appreciated. Regards Opal Are you using SQL Server 2005 If so, you can turn on @replicate_ddl option (set it to 1) for a publication then use regular "ALTER TABLE ... ALTER COLUMN ..." DDL syntax to increase the length of the column, the DDL change will be automatically replicated to subscriber by replication. (@replication_ddl options is automatically turned on if you use management studio to create the publication) Hope that helps, Zhiqiang Feng Thank you Zhiqiang for yo ...Show All

• TA123 Dual Core cpu performance improvment SQL Server 2005

  Hi, I'm trying to find an approximate percentage of what would be the performance gain of using a dual core CPU instead of a single core for a SQL Server 2005 dedicated server. I've been trying to find this information for may hours but could not get anything. Could someone give me a rough estimate please Thank you! Maxim I read somewhere that a 2 dual core processor machine roughly performs equal to a 3 single core processor machine. But, I didn't do any testing to validate it. More CPUs is always better. However, the dual cores are technically slower than the max single cores. For example, one 3.4mhz processor, might be faster for some things and one dual ...Show All

• Rui Dias VD How to protect data of one table?

  I have a DB on my SQL Server Express 2005. In this db I have one table and I DON'T want any user can modify data on this table but I want only show this data (only select statements allowed). If I install this db on one of my customers' machine, I can see that he can modify data into this table If he log in into the database with windows authentication and not with the "USERLOGIN" that I have created with sql server authentication. What can I to to remove dbo access in Windows authentication in my db and "transfer" the dbo in another user access (like MYUSER with Sql Server authentication) Thank You Mirko It seems like you are looking for a DRM (Digital Rights management) solution, ...Show All

• ctssoms XML iteration

  I know this problem probably comes up alot, but Im looking for a way to iterate through certain nodes of a given XML variable. Im trying to write a stored procedure that will insert a large number of stock items, these stock items are represented by XML, there is alot of data that associated to a stock item so I need to check many many dependancies before inserting the stock item. So I need to loop through each Stock element, then loop through that particular elements child nodes etc... doing SQL validation, etc... almost like cursors for XML. Can this be done or can someone suggest a better solution Cheers, Mark I think ill need you help again, I have got what you have done working with my data, thanks ...Show All

• David Cowell DB mirroring + load balancing

  Is it compatible to set up SQL DB mirroring on 2 different physical servers (High availbility + FULL transaction safety + Automatic failover with a third server as witness) and simultaneously set up network load balancing between these 2 servers (option with Windows Server 2003 Enterprise) If yes, which type of licenses do I need and how many (for SQL server 2005 and Windows Server 2003) with such a configuration - 4 physical servers in total : A, B, C and D - load balancing between A and B (same application) - load balancing between C and D (same application) - A hosts principal DB X, B hosts mirror of DB X - C hosts principal DB Y, D hosts mirror of DB Y - D is witness for A and B - B is ...Show All

• creaturita Script task

  Hi, I am new in SSIS development. In the script task of the Control Flow, how to use my custom classes (that use SMO and DTS for building a package and are written in C## ). If not the Script Task then which tool I have to use Natali Rozin wrote: thank you very much Jamie. Did you put your DDLs into the root of the Microsoft.Net folder Through "Add Reference", I cannot find my DDLs I just put into C:\WINDOWS\Microsoft.NET\Framework Natali, You should put it into the appropriate .Net Framework version folder (I always just pick the highest). e.g.: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 My apologies, the post I linked to above does not explain this does it -Jamie ...Show All

• Th3 7ru7h excel vba to generate flat file definition

  What object do I reference to use SSIS from Excel. I want to generate a flat file definition based on Excel. I have a lot of fields to import and I don't feel like creating them as flat file columns. I have a few tables and I get the source file format from the vendor in an Excel format. What I would like to do is generate a flat file connection in an empty package using VBA. I don't think this is possible. VBA is a COM based environment whereas the SSIS API is dotnet. I stand to be corrected. If there is a way of calling dotnet APIs from VBA then I don't know about it. -Jamie As Jamie notes, our documentation is aimed at using the SSIS API through managed code. Using the native API i ...Show All

• Cesar Francisco Custom Property Question

  I have a custom transform, with a custom property of value 1. My question is, can I change that value during runtime with the value from a variable Thanks Please check your email. Hi, I have exactly the same problem, and I would like to share your solution if possible Thanks a lot in advance LVT Yes, you would use a property expression. When you define the property in the transform itself, you need to enable it for expressions through. Set the IDTSCustomProperty90 ExpressionType property to DTSCustomPropertyExpressionType.CPET_NOTIFY. That should work. Minor point but I thinkl calling ...Show All