Answer Questions

• jdt1234 Error converting data type DBTYPE_DBTIMESTAMP to datetime

  Hi I am trying to transfer data from Access 2000 database to SQL server 2005 via SSIS . My access database table has a field with data type Date/Time and SQL server table has a field with data type datetime . When I am running the SSIS package, it is throwing the following error and stops execution. [SQL Server Destination [12466]] Error: An OLE DB error has occurred. Error code: 0x80040E07. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E07 Description: "Error converting data type DBTYPE_DBTIMESTAMP to datetime.". Please help. Thanks in advance, Ramzee SELECT TOP 10 * FROM [ORACLE_LOOKUP]..[SchemaName].[TableName] Alais ...Show All

• Pipz Unable to execute package programmatically with expression based tasks

  Hi, I am trying to programmatically execute a package that contains an Execute SQL Task component bound to a variable for its "SqlStatementSource" property (via an expression). The variable is of type String and contains a simple value of "SELECT 1". The Execute SQL Task contains an expression that sets the SqlStatementSource property to the value of this variable. The package runs fine when I execute it via dtexec or BIDS, but when I attempt to run it via the object model, I receive the following error message: The result of the expression ""@[User::Sql]"" on property "SqlStatementSource" cannot be written to the property. The expression was evaluated, but cannot be set on the pro ...Show All

• Master Hugo SQL Server Express and AMD 64 bit dual cores

  Hello All, I've installed SQL Server Express and its Management Studio Express on two different machines with the same hardware. http://msdn.microsoft.com/vstudio/express/sql/download/ Both machines are suffering the same problem. At least once a day, when the user starts a process, it will peg the cpu at 50% (so presumably one core is at 100%) and explorer.exe will hang. If you start another process, it will hang in the same way. Killing explorer and restarting it does not seem to solve the problem. Rebooting seems like the only course of action. I think this is related to SQL Server Express because this did not happen on either machine until it was installed on the machines, and it started happening immediately after installi ...Show All

• zzpinkie programaticaly create subscriptions

  i have one report which is common to many clients say [a..n] and many more could be added. the report for each client needs to be saved to a unc path. how do i programatically create a subscription for each client to run the same report and save to its unique unc path i.e one path for each client. http://msdn.microsoft.com/library/default.asp url=/library/en-us/rswork/htm/rms_subscribing_v1_11sy.asp Have you looked into Data Driven Subscriptions ...Show All

• VikasAgr Express & RDA?

  We have a .NET Internet (VB and javascript) inventory application that uses SQL Server 2005. Users have requested a version of the application that would allow them to update their data offline. Ideally we would download a version of the application to the user's desktop (with .NET and IIS configured) and have the application logic connect to a local version of the database. I was excited to find that RDA would be adequate to handle the data extract and update that would be required to use a local database. However, the Compact Edition does not support Stored Procedures and connections from ASP.NET applications. The application logic is complex and a lot of it is implemented in the data access layer via stored procedures. There are about 1 ...Show All

• Gaëtan POUPENEY cluster install 2nd node unavailable

  Hi all, Try to install sql 2005 x64 on a Win2003r2 x64 two node cluster. All looks fine as far I get to the "cluster node configuration" dialog. My second node is always displayed as "unavailable node" reason "unknown". - I checked the logfiles but could not find any error. - Installation user & cluster user are both local admins. - Tried with sql 2005 x32 version -> same result. What do I miss out here Any help is highly appreciated. TIA acki as mentioned above installing the sql 2005 x32 Version results in same state -> node unavailable reason unknown If try to install sql 2000 x32 my two nodes show up as configured nodes installation would con ...Show All

• Lawrence 007 Add space between matrix row group

  I have a 2 row groups in a matrix and I need to add some space between the top one so that all the columns don't run together. Is there a way to do this That's what it currently looks like. How do you want it to look No, padding won't help. Here's my layout. I need more space between the subject areas. ELA Math Science Social Studies Below Basic Basic Proficient Advanced Below Basic Basic Proficient Advanced Below Basic Basic Proficient Advanced Below Basic Basic Proficient Advanced 17% 46% 37% 1% 14% 36% 30% 20% 20% 32% ...Show All

• Brett H. Asp.net 2.0 Vista Sql Express Error

  I am developing a web site in asp.net 2.0 using visual studio 2005 and SQL express. I tried to add a new Sql database using right click on the App_Data folder and adding the DB. I get an error that the VS could not find a sql Express installed. I want to clarify that I have installed the SQL express SP2 for vista version and that I can connect to SQL express db using management studio. I think it is a vista issue probably that UA. What can I do pls do not recommend the next step I already tried itL If I create the DB on XP and transfer the project to my vista machine the db is there but I cannot connect to it. Hi Itzik, FYI - VS 2005 is not certified on Vista yet, so this may well ...Show All

• Wil Burton How to pass multi values to a report parameter?

  Hi, all experts here, Thank you very much for your kind attention. Could please any one here give me any guidance for how to pass multi values to a report parameter (I have check the box next to "allow muiti value" in the report parameter dialog box tho) I got the problem: each time only one value can be selected from the value list for the parameter. When I selected multi values for the parameter, I got the error: " An error occured during local report processing. Query execution failed for data set, incorrect syntax near ','." Please give me any guidance. Thanks a lot in advance and looking forward to hearing from you shortly. With best regards, Yours sincerely, Hi If you have mulity sele ...Show All

• Thilakavathy Problem in Subreport - Display not properly

  Hello every body, In the SSRS report the sub report details lays below to main report details instead of being in the required position. Try to help me to figure it out, why this occurs. Have a good day! ...Show All

• Ragas EXEC in SQL Functions

  Hi, I need to pass a table name and id to a function and return a row count I need to use EXEC or SP_EXECUTESQL to run dynamic SQL It wont work in functions. Following is my function alter FUNCTION [dbo].[GetRowCount] (@TblName NVARCHAR(25) , @Itemid INT) RETURNS INT AS BEGIN DECLARE @RowCnt INT set @RowCnt = 0 DECLARE @Sqlstring nvarchar(2000) set @Sqlstring = 'SELECT @RowCnt = COUNT(*) FROM ['+ @TblName +'] WHERE Itemid = '+ convert(varchar(10),@Itemid) EXEC @Sqlstring RETURN @RowCnt END while executing this I get the following error .... "Only functions and extended stored procedures can be executed from within a function." and "Incorrect syntax near the keyword 'EXEC' " does anyone have any ideas of this Thanks ...Show All

• sl333 RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76 native error: 28035

  RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76 native error: 28035 PDA info: .NET CF 1.0 env-string... MS SQL client MS SQLCE 2.0 dev MS SQLCE 2.0 DESKTOP info: Microsoft SQL Server Management Studio Express 9.00.2047.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 6.0 Microsoft Internet Explorer 6.0.2900.2180 Microsoft .NET Framework 2.0.50727.42 Operating System 5.1.2600 copied an app from http://www.codeproject.com/netcf/PocketPCwithSQLCE/PocketPCwithSQLCE_Src.zip ...Show All

• lbugnion How to Setup JDBC for SQL2005 in Webshpere 6.0

  Does anyone know the steps on how to get SQL2005 to talk to a Websphere application via the MS JDBC We are trying to setup the Niku Clarity system with a new SQL2005 Database. Thanks This works great when creating XA data sources in WebSphere 6. Thanks. (By the way, if the one warning you received was for the "url" custom property, I got that to go away by naming the property "URL". Apparently case matters.) However, has anyone tried creating non-XA SQL Server 2005 data sources in WebSphere 6 I've tried and I keep getting: DSRA8101E: DataSource class cannot be used as one-phase: ClassCastException: com.microsoft.sqlserver.jdbc.SQLServerDriver, error code: NOT_A_1_PHASE_DS. Is it possible that We ...Show All

• Dale17677 error of Initializing SQL Server Reconciler has failed using SQL Server CE 2.0

  hi, i'm using SQL Server CE 2.0 in my application. When i try to synchronize my database by calling replicator.Synchronize(); errors :   Initializing SQL Server Reconciler has failed. process could not connect to Distributor SQL Server does not exists and access denied. what i did right now is i try to register regsvr32 "C:\Program Files\Microsoft SQL Server CE 2.0\Server\sscerp20.dll" regsvr32 "C:\Labs\NorthwindTempFiles\sscesa20.dll" both of the DLL files were succeed register. However, when i try to re-do the synchronization. The same error still happened!!! I do not know what's going wrong..=( Who can help me !!! HELP~~~~~~~~~ thanks..    And I assumed this was ...Show All

• msdobrescu2 Group by on a concatenate field

  Select TOP 100 CONVERT(VarChar(10),Service_Prefix)+ '' + CONVERT(VarChar(10),Service_Code) as CODE, Date_Issued, sum(Amount) from dbo.Enterprise_Credits_Import_90_days where CONVERT(VarChar(10),Service_Prefix)+ '' + CONVERT(VarChar(10),Service_Code) <> ' 0' and Service_Prefix like 'F' Group by How can I group by the field that I selected as CODE right - I should have looked more closely at your original query - I didn't see the inline view before... Not disagreeing with you...Just adding my 2 cents worth to clarify/back you up :) you have to repeat the expression: Select TOP 100 CONVERT(VarChar(10),Service_Prefix)+ '' + CONVERT(VarChar(10),Servic ...Show All