Answer Questions

• chawlarachit For Loop Container does not check condition first time

  Hi, It seems like For Loop Container works like do-while loop in C++. I have set its EvalExpresstion to @[User::SyncStats]==0 , I have an Execute SQL Task before this container that sets the variable to 1 but Container still executes atleast one time. Anybody else been through this Well, Silly me, There were actually 2 variables of same name but one with Loop Container scope one with global scope. And I wanted Loop Container to check the Global one. I changed the namespace and it works Thanks anyways. Phil Brammer wrote: Curious, what happens when you set the For Loop's DelayValidation = True Same behavior Do you have anything in InitExpression What happens if you set the User::SyncStatus variable to 0 i ...Show All

• osamaT SQL2005 Setup Fails: How to: Work Around COM+ Check Failure?

  SQL Server 2005 Setup Fails. I've followed all the instructions but keep getting this warning:  * If SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the files and then rerun Setup. For more information, see How to: Work Around COM+ Check Failure in SQL Server Setup. I've read the COM+ workaround document and I've used web search and have posted several times to newsgroups. I'm out of options and can't find the .manifest files that I'm supposed to rename. Can you help <%= Clinton Gallagher Dear julian, I did %WINDDIR%\System32\msdtc.exe-install in the command prompt but it is giving it is not recognized com ...Show All

• sunny123 Extremely long lines

  Hi, When i open a project in ssis show the message: "Document contains one or more extremely long lines of text. These lines will cause the editor to respond slowly when you open the file. Do you still want to open the file." I click Yes and my project open normally. Someone know why this happen My project is small, have one package with any imports excel files to Sql Server 2005. Thanks Andre Rentes Hi Have a look at this link from the forum. Hope it helps: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=313598&SiteID=1 Cheers, Grant ...Show All

• Chris Seymour working with dynamic file names

  I am working with an ftp task which is using a file connection to send a file to a remote server. This file is going to have a dynamic name (e.g. "Orders for 2006-07-29.txt"). How can I dynamically specify the file path/name for the file connection You can't specify a varaible through the ui. I would imagine that you can do this through a script task but I'm not sure how to reference the connection object. any help would be greatly appreciated. thanks, Scott We can set values for any property through variables. In the FTP Task editor - Select "Expressions". Click on the "..." button. A small popup - "Property Expression Editor" will be displayed. Click on ...Show All

• Alessandro Camargo SQL 2005 merge replication extended logging

  Hello, I'm trying to enable extended logging to resolve some conflicts. After doing a google search, I found KB312292 which says to follow what's in books online on modifying the merge agent. I tried to add the following parameters in the agent profile: -Output x:\merge.txt -OutputVerboseLevel 2 When I save the profile I get an error saying that SQL was expecting an integer for -Output. I've also tried using the -OutputMessageFile parameter but this didn't create the file, nor did it change the logging detail in the msmerge_conflicts_info table. Any help would be great. Thanks, Hello, If you are using SQL Agent job to run the actual sync, please add these "-Output x:\merge.txt -OutputVerboseLevel ...Show All

• FarmsN17 Dumb question about compatibility level

  Hi everyone, This is my first psot so I am hoping for success.. I had been asked to web enable a sql 2000 database. We upgraded to sql 2005 and I imported the data. All went well until a tried to run a CTE ( common table ) routine and it kept on coming back with an error. On searching the web it turns out that the compatibility level must be set to 2005. When I tried to set the compatibility level the only two options are sql 7 and sql 2000. I thought it might be due to the fact I had restored from a 2000 database so I tried to create a new database in SSMS but again only sql 7 and 2000 options were available from the drop down box.. What am I doing wrong Am I not running in sql 2005 at all Any help would be appreciated Peter ...Show All

• aashta Can't update a table

  I can't update a table in my app, i did this once, but i didn't save the changes, and now i cant do it, i don't even remember if i needed something more in my code, i'm updating using the TableAdapter. I'm using .NET 2.0 and the changes in the table are made directly trough the Datagrid, the update statement is like this: ClientTableAdapter.Update(Club_DataDataSet.Client); Thank you, I'd appreciate your help Ok....what's wrong i added the data file to my project, but my app can't load the DB if i stop the SQL service in my computer, and neither if i install my app in another PC (i just tried that today) that doesn't have SQL installed (that's my main goal) ...i mean, the DB it's suppose ...Show All

• StairCounter creating composite primary keys via sql management studio??

  Hi, How do i create a composite primary key through sql management studio I have two tables: Section : SectionID , Name Rooms : RoomID , SectionID,Cost , MaxPersons I know its unusual but i have sections in this hotel that have rooms , a section is alsmost like a seperate hotel in itself. Only the management for various sections is common. I need to store rooms that belong to a particular section , yes there can be Duplicated RoomIds. How do i make a compiste key in SQL mStudio , or is there a better solution i am not sure what do  u mean by EDIT database.... In database terms it is Alter.. yes u can Alter Database...   Madhu Open table in Design mode, highlight/select multiple columns , press right butt ...Show All

• ssouki problem Passing Multi value parameter to a .NET assembly

  Hi, I've created a dll using VS.NET C# with a functions name "public static DataSet GetMOObservationPoint(string moNo, string codes , DateTime startTime, DateTime endTime)". In my report, i allow the user to multi select the codes (Example: cutting, sewing, packing). And when the multi selected parameter is passed to the dll, it will then split the codes by the delimiter(which is the ",") and then add the parameters to a ArrayList. I've also tried public static DataSet GetMOObservationPoint(string moNo, Object[] codes , DateTime startTime, DateTime endTime) but it won't work. I hope all the guru out there can lend me a helping hand. Thanks in advance Use string ...Show All

• TheAgent log report email

  I have job pkg which executes multiple packages to load each target tables and log the details of load in etllog table.. I would like to send an email of log posssibly in html format at the end of the job.  Can someone provide me tips for achieving the same. Is it possible to use report rdl   thankx   I think the best method would be to use Reporting Services as you indicate. You can write a simple report based on that table, then use a RS subscription to handle the email delivery as you require. Do you require more information I want to exectute the report on pkg completion where as RS subscription will work on specified schedules. Or is there a way to trigger RS report based on event ...Show All

• DrOats DATETIME conversion problem in stored procedure

  Hi, I'm having a problem with inserting a datetime value into a database using VB.net and a Stored Procedure. Below is my stored procedure code and VB.net code. Could somebody please tell me what I am doing wrong ... I am almost frustrated to tears . Stored procedure: ALTER PROCEDURE dbo.SPTest @testvalue DATETIME AS INSERT INTO tbl_Rates VALUES (1.2, 1.3, @testvalue, 'EUR/USD' ) RETURN 1 VB.NET code: Dim RatesTA As New RatesDataSetTableAdapters.RatesTableAdapter Dim ReturnVal As Object ReturnVal = RatesTA.SPTest(Now) Console.WriteLine( CType (ReturnVal, Integer )) When I run this the ReturnVal is 0. I should also mention that my system uses the dd/mm/yyyy date format (Australian) and I a ...Show All

• Sparklight ActiveX Script Task/Function Not Found

  We have a SQL Server 2005 Cluster that we are trying to send email from to notify when certain jobs have completed, failed, etc. We are having a bit of a problem getting the email to work and I believe that the failure is at the SMTP server, not at the SQL level. That being said, I'm trying to create a simple SSIS package that I can use to test connectivity to the SMTP server with and send email. I've added an ActiveX Script Task that calls a COM object that actually sends the email. I keep getting a "Function not found." error when I try to execute the package, and I have no idea why I'm getting that. It says that the errors were found during validation. Can anyone help Function not foun ...Show All

• dizzyjay Cannot use anonymous methods inside SQLCLR...

  Hi all, The problem is: when you're trying to call in method MyMethod anonymous method that doesn't use local variables , deployment of the assembly will fail referring that MyMethod tries to store smth. in the static variable. Indeed, looking at the compiled CLR code, you can see that anonymous delegate is cached in the private static delegate and the call looks like: If(ClassName.privateStaticDelegate == null ) ClassName.privateStaticDelegate = new MyDelegate(HiddenMethodName); CallAnonymousMethod(ClassName.privateStaticDelegate); Is there any workaround to fix this problem. P.S. I googled about this problem and found only one article on it: http://www.ayende.com/Blog/default,date,2005-12-26.aspx ...Show All

• Stephan Zahariev Maintenance Plan Question

  Hi There I am not sure which forum would eb the right place for a Maintenance plan question, so i am just posting it here. I have noticed that the maintenance plans i have created are not dynamic, by that i mean that for each step, integrity check, backup etc, i have always selected the option all user databases. However it seems that when new user databases are created these are not part of the maintenance plan. Is this correct, do i have to create a new maintenance plan or go back and reconfigure the exisiting one evertime a new user database is created Or am i mising something here P.S i gatehr this from looking at the TSQL from the Maintenance plan afetr creating new databases i see the TSQL still only references the databa ...Show All

• TechNoFear lsass.exe high cpu, Error 18456

  We just migrated to a new sql server with SQL Server 2005 installed (we moved from 2000). We are experiencing two issues that we cannot resolve: 1. The site and database clients that use this SQL Server run very slow now. We have noticed that the lsass.exe process consistantly uses 25% CPU, +/- 10%. When we stop SQL server the lsass.exe process goes down to 0. What can be causing this The website uses a SQL user account, not a windows user account. 2. We have an error in the event log that might be related to the issue above. It appears every few minutes: Event Type: Failure Audit Event Source: MSSQLSERVER Event Category: (4) Event ID: 18456 Date: 10/25/2006 Time: 11:54:42 AM User: NT AUTHORITY\SYSTEM Computer: MSDB Description ...Show All