Answer Questions
LuckyL Multiple Subtotals and Subtotal Expression
Danny Tuppeny Problem appending to a raw file
I have subscription records for five different magazine titles that i process by looping each one though a dataflow using a for-each loop. I am using the following instructions to append to the raw file: http://blogs.conchango.com/jamiethomson/archive/2005/12/01/2443.aspx This works fine when I pass four different magazine titles. when i try to run all of the titles(five), i get the following errors: [Raw File Destination [131195]] Warning: The parameter is incorrect. [DTS.Pipeline] Error: component "Raw File Destination" (131195) failed the pre-execute phase and returned error code 0x80070057. Any ideas Thanks. Frank Damn, not very helpful at all. Sorry, I'm completely st ...Show All
Ravi Santha Microsoft Access Database Synchronizer (ADS) RTW
Hi, Today we are very pleased to announce the RTW release of Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer (ADS) for which many of you been waiting eagerly. Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Compact Edition database on a device. The salient features of this solution are summarized below O Provides a synchronization solution between SQL Mobile/SSCE and MS Access. Data conversion is done while synchronizing the data. O Synchronization happens when there is an active ActiveSync connection between the device and the desktop. O There is no update to SQL Mobile/SSCE ...Show All
vkan How to check null or '' in date field in expression and ...............
I have a column say 'ActivationDate' which is a (database timestamp [DT_DBTIMESTAMP]) which I want to replace with an expression in derived columns The condition is if 'ActivationDate' field is null or '' then 'Null' else 'ActivationDate' I am struggling to write this condition. Without condition i.e. at present it saves the value in this database '1753-01-01 00:00:00.000'. In the preview the 'ActivationDate'field does not show any thing so I recon it is either null or '' skylimit LEN() is an irrelevant function for a DT_DBTIMESTAMP. Even if it worked (which it doesn't) it will always return the same number because datetime values are all stored in exactly the same way. There is no n ...Show All
David N.4117 sp_issues
hi i have the following sp. i want to be able to create a view from the sp that will store the data that can be retrieved with the select statement my sp returns me. if the table exists, it should be dropped i suppose, because columns may vary. now i also want that enough info be stored to retrieve information again from the view, that i can map the records back to their original form how do i set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo] . [sp_DetailedBill_byPono] @payment_or_bill nvarchar ( 2 ), @pono nvarchar ( 25 ) AS BEGIN SET NOCOUNT ON ; DECLARE @fieldname varchar ( 10 ) DECLARE @stmt varchar ( 4000 ) DECLARE Fields CURSOR FOR SELECT A ...Show All
Ted Strom Migrating a column from ntext to XML
After SQL Server 2005 migration, I'm trying to change my ntext column to XML type. The "alter table TableName alter column XMLCol xml" command throw this error : XML parsing: line 1, character 39, unable to switch the encoding 1. Do I have to reformat my nText column before the migration to XML type 2. Is there a way to create an XML data type with UFT-8 in SQL Server 2005 Thank you for your help Thank you for your help the ntext column must contain well-formed xml to be converted. My guess is the the data in the ntext column looks something like: < xml version="1.0" encoding="utf-8" ><root/> which specifies the wrong encoding for the the xml in an ntext column. If ...Show All
ONEWORKNGRL SQL SERVER 2005
Hi , Is there any new feature in Sql server 2005 to have database with same name in same instance. I don't want to install another instance of sql server but want to reside same database on same server . I know it is not possible in sql server 2000 but Just want to know is there any way in 2005 Regards, Jitesh NO, and this includes database snapshots. I'd be really curious to know how one would use a feature like this. How would the application know which database to use if there were more than one with the same name ...Show All
Philip Painter Can't connect to SQL Sever 2005 after upgrading from SQL Server 2000
I recently upgraded from SQL Server 2000 to SQL Server 2005. I have Oracle databases I need to share data with. I was using the Heterogeneous Services (hsodbc) from Oracle and connected to SS 2000 fine. Since I've upgraded, I can't use hsodbc to connect to my SS 2005 database. I get the following error: ORACLE GENERIC GATEWAY Log File Started at 2006-09-06T09:40:07 hoainit (3): ; hoainit Exited with retcode = 0. hoalgon (7): ; hoalgon Entered. name = edw. DB_ODBC_INTERFACE (2085): ; [Microsoft][SQL Native Client][SQL Server]Login failed for user 'edw'. (SQL State: 28000; SQL Code: 18456) DRV_InitTdp: DB_ODBC_INTERFACE (2085): ; [Microsoft][SQL Native Client][SQL Server]Login failed for user 'edw'. (SQL State: 28000; S ...Show All
Pvanroos How to fix DT_Text and DT_NText Read Only in Script Component
I have a script component that I have written and works as long as the Output columns on the script are string types. When I change the output column type to text (since the size could be essentially unlimited) it gives an error in the script component that the property is read only. Here is the code line that fails with Property Payments is read only. Output0Buffer.Payments = fieldValues(i) If I change the column payments to DT_Wstr it works without issue, but I want to use text incase the value is large. Here is the error if you try to run the actual script even though I know it has an error. TITLE: Package Validation Error ------------------------------ Package Validation Error ------------------------------ A ...Show All
Nate00 Export OLAP cube meta data
Hi, I want to export OLAP cube, which was created in sql server analysis services 2005 to another sql server analysis services 2005 at the client end. I tried using microsoft.analysisservices.deployment.exe utility. This does export the analysis services database but it exports the data too. I want just the cube meta data/cube structure to export and not the data. Please do let me know the procedure (preferably step by step instructions) of exporting cube structure in SQL Server 2005. Thanks in Advance! In BIDS, if you save the project, that's metadata. If you right click on the project in BIDS and select properties, under the tab deployment, you c ...Show All
Percival What is necessary to create SDF-Files on desktop legally?
I want to write a PC application that prepares a SQL Server Mobile Files (.SDF) and sends it to a PocketPC. I get this error message: "SQL Mobile usage is restricted on this platform. To use SQL Mobile, you must install SQL Server 2005, Visual Studio 2005, or the Tablet PC SKU" If I install "SQL Server 2005 Express" the error message disappears and everything works fine. Question: Is it allowed to create SDF-Files if "SQL Server 2005 Express" is installed or is it necessary that my customers buy "SQL Server 2005" We have quite similar question. We chose (quite mistakenly) SQLCE to store user data. User can have many (20-100) SQLCE databases. User sees these databases just like "documents". ...Show All
Hugo Cordeiro cannot connect to redirector
Hi, although I read thru several threads I still did not really find a solution for my problem. I have installed a SQL server 2005. i built a cube in SQL server BI studio but unable to deploy the project. giving a msg Error 1 The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. please help me in getting the project deployed. thanx in advance. hi! i ...Show All
Dotnetjunky Transfer table from Microsoft Sql Server to Microsoft Excel
Hi Folks I hope you doing fine. I want to transfer table from Microsoft Sql Server to Microsoft Excel but the column the table like that: Create Table xTable ( xDate DateTime , xStatus Bit ) Now I want to convert data using Import/Export Wizard because when I move xDate to Excel file it looks like ####### that and I want to convert xStatus = 1 e In xStatus = 0 e Out Using Case Statement like: Case xStatus When 0 Then 'Out' When 1 Then 'In' End How can I do this in Import/Export Wizard Thank you anomolous wrote: Also, you might fi ...Show All
Lamprey_ URGENT: Problems with user guest in SQL 2005 restoring database from sql 2000
Hi all. We have restored into sql 2005 the database backups made in sql 2000. We connect with trusted connection and application roles, and when trying to execute a transaction to another database (with the guest user), we get a permission error. Does anyone know if, apart from restoring the databases, we should do something else to get the guest user working the same way as with sql 2000 in the restored databases can you check if the guest user has CONNECT permissions on the target database (the database that you refer to as another database) To check that, connect as admin to the target database and run the following query select * from sys.database_permissions where where class=0 and ...Show All
Evgeny Popov My .Net applicable unable to access my DB after SQL Report Service
Hi, when I am using the Report Manger to open a report, I am unable to acess the Database from my .Net application and vice versa - error report from MS Visual Web developer - "Operating system error 32: "32(The process cannot access the file because it is being used by another process.)". Hi, you cannot create two user instances from one file because you cannot open a file with two processes. To do that you would have to create a server attached SQL Server Express database. This is capable for concurrent connections to a single database like any other SQL Sercer database. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All