Answer Questions

• Aurélien Pivoting currency text file

  Hi! I have a currency exchange rate flat file with this format: date;USD;EUR;SEK; 01-01-2004;8.232;8.00;1.43; 02-01-2004;8.232;8.00;1.43; ..and so on. I need to pivot this to: 01-01-2004;USD;8.232; 01-01-2004;EUR;8.00; .. and so on.. Anyone got any tips on how to achieve this Try the UNPIVOT transformation. It does exactly what you need to do. There is a useful walkthrough demo ...Show All

• jamvir Creating a View with detailed informations

  Hello, I have a code for creating view in T-SQL. I want to ask you guys, i want to make this result set should grouped by DepoAdi column and StokKodu (this is an alias sure you can get it from code). Did i make it on group by line My second problem is i want to add 2 columns to this query. This 2 column will calculate some values with SUM function and - operator. At CRM.Depolar.DepoBilgileri table i have a column named Miktar (this one store ...Show All

• Dadeo Could not obtain a DataReader object from the specified data flow component.

  I am getting the following exception when attempting to read from a DataReaderDestination: System.Exception was unhandled Message="Could not obtain a DataReader object from the specified data flow component." Source="Microsoft.SqlServer.Dts.DtsClient" StackTrace: at Microsoft.SqlServer.Dts.DtsClient.DtsCommand.internalPrepare(Boolean fReaderRequired) at Microsoft.SqlServer.Dts.DtsClient.DtsCommand.ExecuteReaderInT ...Show All

• rthurber Cube Actions, how can I create a Command line action

  In Analysis 2000 there was a command line action type , how can I do the same action in Analysis Services 2005 Analysis 2000 command line action: Defines an MDX statement that can be executed as a command line and displays the contents of the current directory: "cmd /k dir"     Steve, When I modify the script It still not works <Action xsi:type="StandardAction" ...Show All

• Mark Woodlief missing notifications

  Hello, We are building a simple distributed application around the service broker where each queue is serviced from a windows service. We have a windows service running constantly as a "listener" on an event queue for each of what we call "request" queues. When a message is received by the request, the listener service instantiates a reader to process the request. As we are in development, things get out of sync at tim ...Show All

• VanDamMan Values from Dimension Attributes are not displayed properly in Charts

  Hi, Using MSRS and MSAS 2005, I need to produce a simple graph with only 2 columns:  Target Budget vs Actual Spend. The source is from Analysis Services.  Target Budget is retrieved from a Dimension Attribute, while Actual Spend is retrieved from LastNonEmpty of a todate-summary type of Fact table. The values are retrieved fine.  However, when they are used as Data Values in a Chart, only the Actual Spend can be displayed properly ...Show All

• Mark Kerr Cannot import file from Mainframe

  Hello Everybody! Im trying to migrate my SQL 2000 packages that’s currently working in the company production enviroment to SSIS packages. So, in the 2000 version i got the flat file from Mainframe and i had to do a trick to transform all the columns to match the same size as the example above: 1432 1138734217 1144256628<CRLF> 1432 1138734217<CRLF> 1433 1136657788 1122441177<CRLF> 1433 1125554545 1122441177<CRLF> 1 ...Show All

• Milis Replication of Assemblies

  I have a question: how is it planned to replicate changes made to the assemblies and to the CLR functions or UDT Will Visual Studio deploy change of the Assembly as ALTER not DROP/CREATE Replication will replicate the create assembly but not the alter. Philip ...Show All

• dPradeep Destination runs out of space => job never finishes

  Hi, I have developed a SSIS package that performs data cleansing before data is loaded into a DW. I'm using a Multicast transformation to load the cleansed data to both a production and a test environment. A couple of time now, I have exprienced that the test environment runs out of disk space and can not grow the database file (I know - this should never happen, but tell that to the DBA :o). For some reason this causes the package to hang - no ...Show All

• brusi trigger issues

  I am running a trigger on a table (cusomfields) that is to fire when the table is updated or inserted. The trigger takes the new data and moves it to another table called search_products. Search products is made up of 5 columns (product_id, search_terms, name, vendor and keywords). The search_terms column is a combo of the name, vendor and keywords columns. When the trigger fires, the column in the customfields table that updates the keywords ...Show All

• Omar Al Zabir Walkthrough Failu "Creating a Mobile Application w/SQL Server"

  I am attempting to go through the "Creating a Mobile Application with SQL Server" walkthrough found in the SQL Mobile Books Online help file. Towards the end of this document (under SQL Server Mobile Tasks), they show how to create a new subscription. Unfortunately, after step 10--when you are asked to click finish--I get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Failure to connect to ...Show All

• Ana Elisa Does Windows 2000 Professional supporte native HTTP access???

  I'm trying to create a new webservice by sql 2005. My operational system is a windows 2000 professional, but when I try to create a endpoint, I've got the follow message error: Msg 7812, Level 16, State 1, Line 1 The endpoint 'RetornarUsuarios' has been established in metadata, but HTTP listening has not been enabled because HTTP support did not start successfully. Verify that the operating system supports native HTTP access. Check the S ...Show All

• cenimalu A lock could not be acquired after 16 attempts and timed out

  Hi! I'm trying to handle errors in SSIS package. I created Scrip task where I do following: ----------- If CInt (Dts.Variables( "BADROWSFILE" ).Value) <> 0 Then   Dts.Variables( "ERROR_MSG" ).Value = "Errors in input file. Error count: " + CStr (Dts.Variables( "BADROWSFILE" ).Value) + ". See log table and file for more info."   Dts.TaskResult = Dts.Results.Failure Else   Dts.TaskResult = Dts. ...Show All

• Paul Turner What is the best way to dynamically change Server or Database name inside a sp?

  To be clear: You have a store procedure and inside you make Updates or Inserts against another Server. But that name can change and I dont want to change it manually in everyplace. Per example: SELECT * FROM Himalaya . DBName .dbo.tblUserGroup WHERE fldUserID = 7300 I have several Selects, Updates and Inserts pointing to that server. What I can do if I want to change from Himalaya server to another server The same with the Dat ...Show All

• whoisfritz Recover SDF-File

  Hi, we're using SQL Server CE 2.0 on our CE 4.2 device (mobile scanning device). In some cases, the application freezes and the user must perfom a cold boot. After the cold boot, the database is some kind of corrupt - the application can't build up a new connection and a "Fatal Applicatio Error ...." is thrown. If you try to connect to that SDF-File via the Query Analyser Tool, it also throws an exception .... "DBInitiliaze".... Do have anyone a ...Show All