SQL Server

Page 2361




  • Topics
    Replies
    Last post
  • MIgrating Existing WorkFlow Data using SSIS
    by hangar18
    0 Replies
    Last post by hangar18
      • Hi, I have posted the same query in the WF group too. Thought I'll post the same here. We have an existing application which has some WorkFlow Data. We need to migrate this data using SSIS. Now the problem here is that we have our Workflow facade class which inturn calls the WorkFlow Runtime. We have created the methods which will create the new WorkFlows. TO add this DLL in
  • OLAP Error - Excel Pivot
    by SQLChamp
    14 Replies
    Last post by JOER_DK
      • Hello, I'm wondering if anyone could shed some light on the following error when selecting multiple items in a pivot table. ¡°The database driver does not include necessary capabilities and cannot be used with Excel. Contact your database administrator or driver vendor.¡± Your help is appreciated!
  • Cannot connect to SQL Express from WEB Application on internet
    by X-quisite-likeyou
    4 Replies
    Last post by Ronald Ricardo Ramirez Moran
      • Hi, I have installed SQl express 2005 SP1 and then configured it to accept remote connections which works within my internal network. I can connect other client stations within our internal network. However, when i try to connect to the database using a VB.net web application, the application cannot connect to the database. I have a hardware firewall which configured to foward port TCP 14
  • plain text mails
    by molnarcs
    4 Replies
    Last post by molnarcs
      • How can I set the default body_format in database mail. I would like to send a warning with plain text format (from the alerts), that i'll get on my mobile phone, but the message's format is html... always...and I don't get the sms-s.
  • The Device is not ready error when Executing package on the server
    by Gulden
    12 Replies
    Last post by Phil Brammer
      • Hi, I have a package which reads an XML file from a certain folder and parses it. I deployed my package onto the server. Copied XML files on the D:\ drive the following folder on the server. Dim reader As New Xml.XmlTextReader( "D:\Apps\Request\Clients\ClientsStatus.xml" ) is fine. But Do While (reader.Read()) generates "The Device is not ready" I think
  • Unable to install SQL Server 2008 on Windows Vista
    by Robert_W
    8 Replies
    Last post by spidermake
      • I am unable to install the latest CTP of SQL 2008 on my Windows Vista machine. It gets through all the things that happen before the install starts, but when it tries to install I get the following error message: "The installer package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Instal
  • Query Plan in SQL Server 2005 SP2
    by Smitha R
    9 Replies
    Last post by Tom Phillips
      • Hello, The query included at the end of this post seems to use the 'wrong' index when executing and takes 2+ minutes to run. When I provide an index hint, it runs in under 1 second. This happens in both the Production and Development environments; both servers run SQL Server 2005 SP2. When I run both the queries together in Query Analyzer (or SSMS), the Query Cost (relative to the ba
  • How to Locate the SSIS Installation?
    by John Saunders
    4 Replies
    Last post by John Saunders
      • Part of our product will be using several SSIS packages. One of our installers wants to be able to create a .cmd file that will run DTEXEC against one of the packages, with the correct config file specified. It had been assuming that SQL Server was installed in the Program Files special directory, but that's not always the case. What is the correct way to locate the installation of SSIS In
  • Un-Pivot transform crashes BIDS (Serious Issue)
    by Dharmbir
    4 Replies
    Last post by Dharmbir
      • I am facing a serious issue is BIDS. I have configured a Un-Pivot transform, source to unpivot is sort, when I change the source to derived column (one column name is same for both) and try to open Unpivot it gives me unreferenced lineage id (this is correct). Now When I select Delete Unreferenced Lineage Column and select Apply , it works till here. As soon as I select OK, BIDS crashes and clo
  • Transform collate fields
    by rabbiwan
    6 Replies
    Last post by Jasmin Azemovic
      • Hello, I would like change in my data base the collate format of my fields in my tables. Currently there is a SQL_Latin1_General_CP1_CI_AS collate and I would like change to SQL_Latin1_General_CP1_CS_AS. There is a procedure to transform my fields without delete my data base Regards.
  • Msg 137, Level 15, State 2, Line 8 / Must declare the scalar variable "@Interest".
    by jpchenot
    3 Replies
    Last post by jpchenot
      • Hi guys! I have written the following store procedure in SQL server express 2005. But I get the above result when I parse it. Anyone for a tip Thanks Jean-Philippe CREATE PROCEDURE procInsertClient -- Add the parameters for the stored procedure here @ClientID smallint OUTPUT , @FirstName nchar ( 20 ), @LastName nchar ( 20 ), @Phone nchar ( 1
  • logistic regression model formual
    by barak1
    4 Replies
    Last post by likot
      • hello , i am using neural network model to build logistic regression how can i see the formula of the model the paramters that came out and their coefficiant i have look at the model content but couldn't find it tx
  • How to figure out if the dataset returned any data or not while rendering the report through the SSRS Web Service
    by Puneet_18
    1 Replies
    Last post by Jens K. Suessmeyer
      • In one of my projects, i have been using the SSRS web service to render a report as pdf and then manually emailing it out. I need to know whether the data set for the report returned any data or not (so that i can avoid emailing the report with a blank report body). Ofcource this can be done by executing the same query (same as the query for the report) from C# code and checking the count of
  • How to format cell / data apprearecnce under a table
    by Rashi
    1 Replies
    Last post by Arnie Rowland
      • Hello All, I uploaded custtable under the database, the data looks fine except that the name that apprears has a lot of distance e.g it should be : firstname lastname however the format appears very strange: firstname lastname firstname lastname fistname lastname Same is the case with the address, I need to adjust or format the apperance th
  • SSIS Script Task
    by A.W.M.
    5 Replies
    Last post by jwelch
      • I want to use script task in order to dynamically filled Table A, B, C from the data Table 1. What script should i used and how can i implement this in SSIS. Ex: Table 1 Col1 Col2 Col3 A F1 123 A F2 213 A F5 456 B G1 345 C H2 897 C H5 768 Now i wanna write a script which can dynamically do this:
  • Data Conversion Question
    by Whalensdad
    1 Replies
    Last post by desibull
      • I am using the instructions at the following link to create an update/insert load: http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx My input data has values that are 8 bit signed integers DT_I8. My output table uses BIGINT for the same fields. Now I know that the conversion in SSIS is BIGINT = DT_S
  • How to flush data stored in SSIS buffer
    by Rafal Chojnacki
    4 Replies
    Last post by rafal.chojnacki
      • Hi, I am working on my own data flow source component. Here is a fragment of this component code: public override void PrimeOutput(int outputs, int[] outputIDs, PipelineBuffer[] buffers) { PipelineBuffer selectedBuffer = buffers[0]; string message; while ((message = GetMessage()) != null) { selectedBuffer.AddRow(); selectedBuffer.SetString(0, message);
  • How to hide URL when display reports in reporting services
    by rsblue
    1 Replies
    Last post by GregSQL
      • Hi , How can I hide the URL information when I open a report, some with parameters and some do not have parameters. Is there anyway or properties in RS that I can set to have it hide all the important information, like datasource, credentials, parameters, and display the report like a aspx page instead Or does this need to have special programming to make this happen and if so
  • Question on calculated members
    by Helen999888
    12 Replies
    Last post by Helen999888
      • Hi, all experts, As we know the calculated members are only calculated at query time which means the analysis services engine wont preaggregate any thing for calculated members across different levels of dimensions I am a bit confused then what is the point to have a calculated member in a cube especially if the cube is a large cube with over millions records of data In this case, the query
  • Cannot start SQL Server Browser
    by Dots
    14 Replies
    Last post by Matt Neerincx
      • Hello, I use SQL Server 2005 for multi-user access. In the Surface Area Configuration, I changed the protocol from TCP/IP to Named Pipes and restarted the service. Then I went to SQL Server Browser, stopped it and clicked on Start to restart. I am getting a message "An error occurred while performing this operation". I am not able to get the Browser started. Any help would be grea
  • Multiple Database Files: Good or neutral?
    by rusag2
    1 Replies
    Last post by Sue Hoegemeier
      • I have inherited some responsibilities for which I'm not really qualified, so I'll push on through and maybe not totally fall down. Assume 10 50GB databases, each in a single MDF file. All these MDF files reside on the C drive (the only drive on the system), running SQL 2005 in a 32-bit Windows 2003 or later, 8GB RAM. The C drive is 6 physical disks in RAID 5, say about 1.0 TB or so
  • ntext columns truncated to 32K when processed by Integration Services
    by CE31572
    10 Replies
    Last post by CE
      • I have an Integration services application that retrieves big strings (over 32k) from an ODBC data source and stores them in a SQL server 2005 database as ntext. Somehow the strings are truncated to 32K. The app only copies the data from the ODBC datasource to the (OLEDB) target. Also, some of the special characters in the input text are not properly translated. Any ideas
  • BCP to a table partition
    by anu06
    5 Replies
    Last post by ggciubuc
      • Can any one tell me how to BCP to perticular partition of the table in SQL Server.
  • junk character within FLAT FILE
    by Antony Kumar
    5 Replies
    Last post by Jamie Thomson
      • sample Data: "061107"  Every flat file ends with the junk character  How to remove this using "Derived Component" or "Script Component" Pls provide the sample code for this task. Thank you.
  • SQL Server Licensing
    by Dave Alessi
    4 Replies
    Last post by Arnie Rowland
      • I have a three server network. One SQL Server, One Web Server, and a backup. The web server is ASP.NET, and uses the database. I do not track the number of users hitting the web server. What type of sql server license is needed Processor Device CAL User CAL I have read all the white papers and licensing info and can't find an aswer to this question. Please help