Answer Questions

• JAson_scoobyjw Data flow task multiple destinations

  Hi, The further i get with doing my current SSIS package the more i am starting to wonder about best practices and performance. My current package loops through CSV files in a specified location and extracts events from these files. Each file contains multiple events which are a mixture of different types. Depending on the event there are a different number of comma seperated values. In the package i firstly set each event to one column seperated by a comma delimeter. I then create an array for the event which is split by the delimeter. In a script i weed out all elements of the array that are common to all events and set the remaining events to another array. After some processing i come to my conditional split transformation which splits ...Show All

• e-maurizio Failed in installatio, ERROR:29503

  Hi, Folks My story is a bit of similar to some of the fellows. During the default installation, it failed at the last section which is "SQL server database service" because it cannot start the SQL service. The difference of my story is this is not the first time I install it on my computer or any upgrade from whatever other version. I'd installed it for a couple of weeks working perfectly before my computer seemingly infected by an adware. Since then SQL Server stopped working, then I decided to re-install it after I had the adware removed. So it shouldn't be the limitation of either CPU or memory, I think. I hope I could get an answer to it before I have to re-install the whole OS, PAINFULLY. T ...Show All

• Knut Espen Bergby SSIS clustered, accessed by multiple instances

  Hi, I have a clustered environment which has many instances in it. I have modified the xml file to allow several instances to use ssis. Everything works great when the instances are on the same node as the clustered ssis. However if they are on different nodes there seems to be an aunthentication problem and it loses my credentials. For some reason it tries to use Anonymous Logon instead. Here is the full error: The SQL server specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer. For more information, see the topic "Configuring the Integration Services Service" in Server 2005 Books Online. Login failed for user 'NT ...Show All

• Robert-UTS Migration from SQL 2000 Enterprise Server to the SQL 2005 Enterprise Server (64 bit-Itanium Server)

  We are migration few database from SQL 2000 Enterprise Server to the SQL 2005 Enterprise Server (64 bit-Itanium Server) Problem : - The performance difference observer was not much (Just 15-18%) - The CPU Utilization goes to 100% immediately, when the software login screen appears and it sustains in between 90% to 100% - Multi-User Access (3 or more concurrent users), the sql performance is tremendously slow. Steps followed for Migration: - We have used the backup and restore method to migrate the data from SQL 2000 Enterprise Server to the SQL 2005 Enterprise Server (64 bit-Itanium Server). - We ran the DBCC DBREINDEX for each affected tables - We executed the sp_updatestats procedure for all th ...Show All

• Ken_Bussell escape characters

  Hi, I need to insert this command into a table, but I can't because. insert XXX set column1 = isnull ( Title , '' ) + case when ( case when title is null then 1 else 0 end ) = 1 then '' else ' ' end + isnull ( Last_name , '' ) + case when ( case when First_name is null then 1 else 0 end ) = 1 then '' else ' ' end + isnull ( First_name , '' ) + case when ( case when Middle_initial is null then 1 else 0 end )= 1 then '' else ' ' + isnull ( Middle_initial , '' ) END I don't know how to use escape sequence, I need insert just once thanks What excatly do you want to achieve HTH, Jens K. Su ...Show All

• mako_123 JDBC with SQL Express

  The java code : Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); String connectionUrl = "jdbc:sqlserver://localhost:1433;" + "instance=SQLEXPRESS;databaseName=UPM;integratedSecurity=true;"; Connection con = DriverManager.getConnection(connectionUrl); returns "connection refused" no matter what I do. I've used the surface config tool to enable TCP, I've added sqlsrvr.exe to the firewall exceptions, I've tried a dozen or so variations on the connection string. I can connect to the database using the Management Studio. Any ideas what I'm missing Thanks. As you are using a trusted connection can your verify that you are using the correct user ...Show All

• ksona Table FillSchema Method

  Hi, Sorry if these is not the right forum for this: I’m using the data adapter method FillSchema works fine in MS Access but SQL Server Express Edition it doesn’t get the primary key of the table. For example if I try to use the Find method of the dataset I get this error “Table doesn't have a primary key” but in MS Access these do not happen. This is the code that I’m using : Dim sql As String = "SELECT admin.rents.id, admin.rents.transaction_id, admin.rents.item_id, admin.rents.description, admin.rents.due_date, admin.rents.return_date, " sql &= "admin.rents.amount_to_pay, admin.rents.paid_amount, admin.rents.tax, admin.rents.type, admin.rents.deposit_id " sql & ...Show All

• khawaja Organizing calculations

  I have many calculations in my cube that have the MEASURES parent hierarchy. Is there a way to organize these into folders similar to the measure group folders Must they always remain directly under MEASURES when browsing the cube This is exactly what I needed. Thank you. hello, you can go to the Calculations Tab of the Cube designer, and then use the Calculation Properties tool bar button (it is next to form view, script view buttons). It brings up the Calculation properties dialog, where you can set an Associated Measure Group for your calculations, as well as further categorize them by setting a Display Folder. These should affect the way calculations appear in ...Show All

• agney Unable to connect to HTTP Endpoint using Digest Authentication on a Server 2003 PDC

  I am just about ready to tear my hair out on this one, at this point you guys are my last resort! Wouldn't it be nice if I could go to bed and have an answer for me in the morning.... I've had a working HTTP endpoint using Basic Authentication over SSL for months in our development environment, but now I'm moving our application to a production server and I'd like to be able to use Digest Authentication in the clear instead so the processor doesn't waste cycles on the SSL decryption. I've spent hours fiddling with my endpoint to no avail. This is the closest message relating to what I'm doing that I've been able to find: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1131251&SiteID=1 In my case, the ...Show All

• nabeelfarid reseeding temporary tables or table data types with identity column

  Hi, I have a indexing problem. I have a sequence that needs to has a index number. I want to use a table data type and have a working sample BUT I cannot reseed the table when needed. How do I do this. This works only for the first ExitCoilID then I need to RESEED. Here is my code: DECLARE @EntryCoilCnt AS INT , @ExitCoilID AS INT , @SubtractedFromEntyCoilCnt AS INT DECLARE @ExitCoilID_NotProcessed TABLE ( ExitCoilID int ) INSERT INTO @ExitCoilID_NotProcessed SELECT DISTINCT ExitCoilID FROM dbo . TrendEXIT where ExitCoilID is not null and ExitCnt is null order by ExitCoilID DECLARE @ExitCoilID_Cnt_Index TABLE ( E ...Show All

• dermothogan Dynamic filedlength of varchar fields in source

  I'm using SSIS to import data from a table (SQL) containing varchar fields. The problem is, that those varchar fields are changing over time (sometimes shrinking and sometimes expanding). I.e. from varchar(16) to varchar(20). When I create my SSIS package, the package seem to store information about the length of each source-field. At runtime, if the field-length is larger then what the package expects an error is thown. Is there anyway around this problem Oh, yeah... My destination fields are a lot wider then the source fields, so the problem is not that the varchar values doesn't fit in my destination table, but that the package expects the source to be smaller... Regards Andreas A. Bros ...Show All

• yogiberr Looking a value from an attribute in a xml

  Hello there. I have a XML like this: <Root> <Gato id="0123" sitio="por aqui"/> <Gato id="2536" sitio="por alla"/> <Gato id="4587" sitio="por acuya"/> </Root>' I need to look for the element that contains "2536" in the "id" attribute. May be later i will need to update this value, How i can to explore the file to find this element I'm using SQL 2005 And here is the expression that updates the sitio attribute of the selected Gato to a new value: declare @x xml ; set @x = '<Root> <Gato id="0123" sitio="por aqui"/> <Gato id="2536" sitio="por ...Show All

• alzikan Help! Enterprise Manager Turns SQL Server Service Manager Off

  IF someone can assist me. Everytime I load up enterprise manager the service manager turns off. And the enterprise manager can't connect to the local database. But everytime i turn it back on and try to connect again it shuts it off and around and around we go. Help would be appreciated. Thanks. What is the service manager What do you mean it "turns off" What do you mean you "turn it back on" Why are you asking about this problem on this forum I'm confused. -Jamie Basically my local SQL disconnects automatically whenever I try to even access my local tables. I don't know what's causing that. When i'm not trying to access it, it stays on. Otherwise it just turns off. ...Show All

• Rohitgulati error

  "To connect to this server you must use sql servermanagement studio or sql server management objects(SMO)" what could be the cause of this error happens when connecting to sql server 2005!!!! Where are you gettin this error HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Hi, as you didn’t answer, I guess you are using a version prior Managment Studio to connect to a SQL Server 2005. SQL Server 2005 needs an SMO-enabled application for administration. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Mystagogue AVG function on an integer column- truncation

  When I use the AVG Function on an integer column, the result is truncated Example: Select AVG(field1) from table1 Field1 is an int field and has 4 rows with the values 114,115,115 and 115. This will return 114. I can get the correct result by using the following SELECT: SELECT CAST(AVG(CAST (field1 as decimal(18,1)))+ .5 as int) from table1 Am I missing something here Is there an simpler way to do this Any help will be appreciated. Steve D. The problem is that I need the resultant value to be an integer, not a decimal value. The query from above will return 1.75000. I need the result back as an integer, which was why I had to cast it back to an integer after ad ...Show All