Answer Questions

• Mathew1972 Can't see the SQL Server Express Instance on SQL Browser

  Hi All, I am using SQL Server Express to connect to the network using VPN on a local machine. I have done the following.. a.) Enabled the remote connections for the Express Instance and rebooted the machine. b.) Connected to the machine with Express Edition locally and can also connect other SQL Server instances from it to verify connectivity. c.) Yes, SQL Browser Service is running. d.) Firewall is not turned on, so I do not have to configure any exceptions. Now here is the big problem: When I browse for SQL Servers on the network the machine does not show up on the list, i.e "macinename\SQLExpress". I had uninstalled and reinstalled the Express edition and rebooted the machine several times with no luck on t ...Show All

• Riady Loop Through Flat Files Based On A Date Range

  Hello, I currently have a For Each File container that loops through all files from a specific directory. The files have a naming convention that looks like this; CDNSC.CDNSC.SC00015.01012007 The last segment of the file name is the date of the data in the file (mmddyyyy). The create date for these files is always a day later than indicated in the file name. What I would like to do is to have more control over the 'range' of files that are looped through by using the date portion of the file name to define what group of files should be looped through. Ideally, I would like to have a 'StartDate' variable and an 'EndDate' variable that I could define at run time for the package, and the package would loop through all of the files ...Show All

• Dasa table script creation error: "Property AnsiNulls is not available for UserOptions"

  I just recently upgraded my DB server from 2000 to 2005, and now I can't script any table creation scripts.  I can edit tables using SQL Management Studio just fine, can edit stored procs, etc.  But when I try to script to a new window using management studio, I get the error below.  Note that my tools were upgraded at the same time, so I'm not sure if the problem is with the Tools, with SMO, or an underlying problem in the database.  Any ideas Here's the error text: TITLE: Microsoft SQL Server Management Studio ------------------------------ Script failed for Table 'dbo.EditorialRepeatMap'.  (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00. ...Show All

• ascanio ForEach Loop container issue!!!

  Hi everyone, I am having hard time with foreach loop container. The for each loop container in my package goes over all the rows in a ADO enumerator recordset variable and shows row values one by one in message box. The problem is that it just keeps printing the first row infinitely. Could anyone tell me what could be wrong Thanks in Advance, Check this feedback: ForEach enumeration of ADO recordset can cause infinite loop when using checkpoints https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=125915 Praveen Dayanithi wrote: Hi everyone, I am having hard time with foreach loop container. The for each loop container in my packag ...Show All

• Uncle K Notification services failed to open a connection to SQL Server.Server name:ABC(Microsoft.SqlServer.NotificationServices)

  I am getting the above error when I try to create Notificatioin services new Instance. Additional Information is Failed to connect to server ABC(Microsoft.SqlServer.ConnectionInfo) An error occured while establishing connection to the server.When connecting to SQL Server 2005, this failure may be caused by the fact that under default settings SQL Server deoes not allow remote connections.(Provider : Named Pipes Provider, error 40 -could not open connection to SQL Server)(Microsoft SQL Server error: 53) Please help me I am new to SQL Server 2005.I can't able to proceed. GIRI: I have e ...Show All

• FugersonHall how to use DtsLocalizableAttribute

  I Have to set the display name and Description of DtsPipelineAttribute using DtsLocalizableAttribute. Can anybody point to some example. MSDN Help is not much of use, it does not contain any example. Dhamrbir Can you please explain us more about what you are trying to do here Hi Deniz I have a custom component, whose name should be localized. For this I have to read the resource file and set the Display Name and Description of the DtsPipelineComponent attribute. As per the MSDN Documentation http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.pipeline.localization.dtslocalizableattribute.aspx We need to set the LocalizationType property of the DtsPipelineCompon ...Show All

• alien- How to get the max length of numeric field in a DataSet?

  How to get the max length of numeric  field in a DataSet     I have a DataSet bound to an Access database . Is it possible to get the maximum length of numeric  field of a table in the DataSet Many field s in the database tables have maximum length values set in ... A VB.net or ADO.Net forum would be a better start, but just walk down the object hierarchy- myDataSet.Tables(0).Columns(0).Length ...Show All

• dek in UK SQL2005 SP2 Dec CTP Sharepoint AddIn install problem

  Hi, I've installed the Dec CTP of SP2 on a Windows Server 2003 SP1 virtual machine. Sharepoint and SQL2005 are running on the same machine. It currently has 1GbRAM allocated. I configured the Report Server to use a Sharepoint integrated report server database. (Missed this first time round). Then I installed the SharepointRS.msi. I see no sign of the Reporting Services section in Central Administration, Application Management, and in Central Administration>Site Settings>SiteFeatures, I see no sign of Reporting Services either. Below is the log file from SharepointRS.msi /l* Any help much appreciated. Thanks Martin === Logging started: 22/01/2007 14:54:20 === Action 14:54:20: INSTALL. Action start 14:54: ...Show All

• Sushisource Float data

  Hello. We have a third party app that's database holds allsorts of info as floats. I have to update records in this database from my source database that stores it's data as decimal(8,2). so when I update a row with 25.00 it goes into the 3rd party app database as 25 because it's a float. Is it possible to put the data in so it reads 25.00 without changing the datatype from a float Thanks. You should not worry about the format of numbers as they come from a query. Use your application to apply any formatting that is needed. The "float" data type does not store non-significant digits. The trailing 0 is non-significant. So the answer is no. ...Show All

• mjhoagland Problem with a Web Service Task that uses a digital certificate

  Hi every body... I will thank u the help that you could bring me... This is my problem: I am using a Web Service Task in Integration Services for access a Web Method, this method is not mine, it is a method provided for another company. This Web Method is published in a VPN (Virtual Private Network) and it is in a secured channel (https). The properties of the Connection Manager that the Web Service Task uses are ok. The Server URL is the address of the asmx and the client certificate is the correct. In fact when I press Test Connection, the message Test Connection Succeed is shown. If I change the certificate, a connection error occurs (403 Forbidden), this means that the client certificate and the address is ok. I addition, I us ...Show All

• compuder INdexed View: My wish

  I wish SQL Server will allow a way of creating indexed view which has a union clause in its definition And I wish I could fly. :) P.S. Then submit your suggestion here: http://connect.microsoft.com/site/sitehome.aspx SiteID=68 ...Show All

• srfitz2000 Hidden columns/blank PDF page(s)

  I have been trying for some time to create a columnar report where certain columns can be hidden as requested by the user. I have tried placing the complete column set in the report, and then hiding a subset of columns, but blank pages are produced when rendered to PDF since the report body does not appear to shrink as columns are hidden and justify themselves to the left. I have tried a table, list, and matrix to no avail... Does anyone know of a workaround, a trick, or even a hack that may accomplish what I am after Thanks. Hello Iago, I have found a work around for this problem. It’s a bit hacky, but does work. 1. Collapse all table columns to the smallest they can go so width = .125 2. Resize t ...Show All

• NickNotYet How to raise error in script

  I can't believe I can't find this in books online... I have a transformation script component and I have a case where I want the object to completely fail if it is encountered. How do I code that All my searching BOL could find is how to redirect rows to an error output which is not what I need in this case.... I'd think it would be something simple like Me.RaiseError("Something really bad happened") but I haven't found it ... Thanks... I knew it it had to be in books online somewhere.. I just couldn't find it "Throw an exception to simulate the Fail Component disposition. This action will cause the transformation script component to immediately fail ...Show All

• black_apple DTS Fully process dimensions code

  Using the following code to fully process dimension in a catalog on SQL Server 2000. for each objDimension in dsoDatabase.Dimensions dsoDimension = objDimension dsoDimension.Process processFull Next However this appears to do an incremental process of dimension rather than full process. (I would expect the cubes to be unprocessed after a full process. Whats wrong with the code. Cheers. Mark. for each objDimension in dsoDatabase.Dimensions dsoDimension = objDimension dsoDimension.Process (1) Next Have tested this and believe it to work. Still do not understand why above did not work. I assume you are using vbscript to process. If so you need to reference to ...Show All

• rahsoftware Merge replication between same schema databases but different data

  Hi all. I 'm trying to set up merge replication between two servers that have the same schema databases. The two database have the majority of there data the same but as well as data inserted at a later time independently on the two servers. (The two servers were connected in a merge replication scheme that failed at some later  time and replication was paused, but users continout to insert data indepentedly at the two servers.) I need to get them up and running. I cleaned replication at both servers, I recreated the publication at the puplisher distributor and all is fine. When I create a push subscription to the subscriper I get the error invalid column name ' rowguidcol ' . I so far managed to have merge replicatio ...Show All