.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Transferring data (on update) from SQL to SLQL (2008

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hi there,   we are having 2 MS SQL 2008 servers, where the first one is our main machine where our ERP (Navision) is running on. Now, due to a customer request, I need to send data from our main sql server into our second sql server. But not everything, only some specific datasets (only if the specific customer is affected)... not only on inserts, but also on updates and on multiple tables.   I am not quite sure which technology to use for that, I tried to read something about Integration Services and Trigger, but as I am not really into both of them and not sure what technique would be the most suitable, I'd like to ask the experts here for some advice.   The affected rows might be around 2-10% of our total inserts / updates a day.   Any help would be appreciated!

View Complete Post

More Related Resource Links

Using Conditional Split data Transfer in SSIS 2008

This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

Under The Table: Spatial Data Support In SQL Server 2008


New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.

Bob Beauchemin

MSDN Magazine February 2009

Hierarchy ID: Model Your Data Hierarchies With SQL Server 2008


Here we explain how the new hierarchyID data type in SQL Server 2008 helps solve some of the problems in modeling and querying hierarchical information.

Kent Tegels

MSDN Magazine September 2008

SQL Server CE: New Version Lets You Store and Update Data on Handheld Devices


Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS. The architecture of SQL Server CE, along with data manipulation, synchronization, and connectivity issues, are discussed in this article. Topics such as making your data public, choosing the right type of replication, and handling errors are also covered.

Paul Yao and David Durant

MSDN Magazine June 2001

SQL 2008 R2 (final): SSMS freezes: "Failed to retrieve data for this request.

The original thread is locked for some reason--but the cause of the bug had something to do with the "ssms tools pack" add-in, which, according to the comments in the connect item, will be fixed in an update of ssms tools: http://social.msdn.microsoft.com/Forums/en-US/sqlkjdatabaseengine/thread/f65737b7-fe4d-487b-aa41-ef437d100bc7 https://connect.microsoft.com/SQLServer/feedback/details/556169/ssms-completely-locked-up-after-right-clicking-a-table  

Update XML data in SQL

Is there an easy quick way to update an xml value based on the contents of that value....? From my research so far this seems to be much more involved then I expected it to be. Here is my table CREATE TABLE [dbo].[ReportJobs]( [ReportJobId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [Enabled] [bit] NOT NULL, [Description] [nvarchar](500) NOT NULL, [ReportDefId] [int] NOT NULL, [Email] [nvarchar](500) NULL, [LastRunResult] [nvarchar](50) NULL, [ScheduleId] [int] NOT NULL, [LastRun] [datetime] NULL, [NextRun] [datetime] NULL, [PersonId] [int] NULL, [Parameters] [xml] NOT NULL, Here is an example of the xml contained in Parameters for one record. <ReportParams> <Param Name="EntityID">103</Param> <Param Name="RelDateFromNum">-3</Param> <Param Name="RelDateFromWhich">Day(s)</Param> <Param Name="RelDateToNum">0</Param> <Param Name="RelDateToWhich">Day(s)</Param> <Param Name="GeoID">288</Param> <Param Name="InboundFlag">False</Param> <Param Name="ShowTimeliness">True</Param> </ReportParams>  Here is what I'm trying to do.... What is the correct way to make the following statement? Update ReportJobs set <ReportParams/GeoID> = 12 w

update data on table

i have  100000 record  found in the  tha table and  i want  to update the column SocialState when found male he replace  the text male to 1 and when foun Female  he replace the text to 2   update [Drugs].[db_accessadmin].[Data] set SocialState='1' where SocialState='Male' update [Drugs].[db_accessadmin].[Data] set SocialState='2' where SocialState='FeMale' he give me this message "(0 row(s) affected)"

Sys.Data.DataContext.saveChanges method doesn't send update to server after DataServiceException ex

Hello,I have a page with a simple form that updates a single record in a table in my database.The database is accessed via WCF Data Services. To load and save data from/to the server, I usethe Sys.Data.DataContext object provided by the ASP.NET AJAX library. When the "save" button on theform is clicked, I use the saveChanges method of the Sys.Data.DataContext object to send all changes to the server.Also, at the server side, I use an interceptor that checks the "Price" fields of the record, and throws a DataServiceException exception when the contents of the field is a negative number.Both the JavaScript and the interceptor (in C#) are copied below.Here is the interesting thing:When I enter a negative price in the form, the interceptor throws the exception and my form shows an error message. Good.However, if I then make one of the other fields in the form a bit shorter (for example from "abcd" to "abc"),the saveChanges method doesn't send the data to the server. But it does call the success callback that I passed in to saveChanges, creating the impressionthat the data has been saved. This happens while the Price field is still negative. I used Fiddler to make sure thatno message is sent to the server. Also, the interceptor doesn't get executed.The weird thing is that if I make one of the fields a bit longer instead (for example &q

MSAS 2005 vs 2008 - different results of an UPDATE CUBE instruction

Hi ALL!   When moving from SSAS2005 to SSAS2008 I have a problem with write enabled cubes. On SSAS2005 UPDATE CUBE instruction occures almost instantaneously but on SSAS 2008 this takes few seconds. I created a cube with one dimension and one measure for testing. No aggregations, fact table initially empty, measure has 3 elements. Profiler shows that SSAS2008 UPDATE CUBE instruction initiates cube processing, but SSAS2005 doesn’t do this. What's wrong? Please, help! SSAS2005 Profiler: http://savepic.ru/1593644.jpg SSAS2008 Profiler: http://savepic.ru/1584428.jpg   Thnx!

SSRS 2008 Export to PDF fails for large data with System.Exception: Parameter is not valid

Hi, We are working on Range Bar Chart using SSRS 2008. The report has huge data. It is properly displaying the data, but when we tried to export to pdf it is failing with the following exception. Exporting to excel works fine. Also if the report has small/medium data it is property exporting to PDF. It is failing only in case of huge data (we have custom page size of 28" X 14"). Of course the report has lot of expressions we used to customize the colors/text as per our requirements.   Server Error in '/Reports_SQLDEV2008' Application. Parameter is not valid. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Exception: Parameter is not valid. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:   [Exception: Parameter is not valid.]   [Exception: An error occurred during rendering of the report.]   [Exception: An error occurred during rendering of the report.]    Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream ou

Cumulative Update CU4 For SSRS 2008

trying to download CU4 For SSRS 2008 SP1, I'm confused as to what the different suffixes mean at the end of the CU name, I seeRRB2ClickOnSNACRSSharepoinCan someone explain to me what these are or what the differences are?  SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_CU_Updated_Ref_KB_976761 2008 10.00.2740.00 237625057 11/4/2009 7:06:28 PM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumlative_Update_4_RRB2ClickOn 2008 10.00.2734.00 122189228 9/22/2009 4:18:56 PM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumlative_Update_4 2008 10.00.2734.00 237547729 9/22/2009 7:13:01 AM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumulative_Update_4_SNAC 2008 10.00.2734.00 7012764 9/22/2009 7:23:53 AM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumlative_Update_4_RSSharepoin

Data Collection in SQL 2008 not working

I am trying to use “Data Collection” feature in SQL 2008. I created it but I am not able to see any report. I am getting blank report. I saw all the jobs related to Data collection are failing and throwing following error:-     The step did not generate any output.  Process Exit Code 4.  The step failed. Any idea what needs to be done? This is SQL Server 2008 64 bits.   Thanks Saumen 

SQL server 2008 r2 Data sync question???

Sql 2008 r2 data sync, does it involve a db hosted by microsoft or does that involve us hosting the sync functionality locally?  I know we have db's local that need to be sync'd across a wan but does that happen in a db hosted in the ms cloud or does that have to do with a sync functionality that runs locally to keep my db's sync'd?   Thanks, SL

Invalid data has been used to update the list Item.(List definition)

<nativehr>0x80070057</nativehr><nativestack></nativestack>Invalid data has been used to update the list item. The field you are trying to update may be read only. I have created a list definition and into that i have created lookup column when i am trying to add any item into the list then it gives me an error as above. Can anyone help me.? I made the readonly attributes to false for lookup columns.  

ssis sql 2000 image to 2008 varbinary Failed to retrieve long data for column

Hi, I have a task that to migrate the image type column from sql 2000 to varbinary type in sql 2008. The source column having 3812353 max datalength size for the column. The package always failed with following error message. [OLE DB Source [13177]] Error: Failed to retrieve long data for column "attch_file_content_t". [OLE DB Source [13177]] Error: There was an error with output column "attch_file_content_t" (13209) on output "OLE DB Source Output" (13187). The column status returned was: "DBSTATUS_UNAVAILABLE". [OLE DB Source [13177]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output column "attch_file_content_t" (13209)" failed because error code 0xC0209071 occurred, and the error row disposition on "output column "attch_file_content_t" (13209)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. Meng Chew

Parallel Groupings are not showing the data in Reporting Service 2008.

Hi All, My main goal is to show rows under two adjecent groups (say A another one is B) which have one parent group lat call it as AB (all are row sections) and i have one column group for "months".The details inside the group A under the "months" group is not showing any values or expressions it returing me blank. Adjacent groups in SSRS 2008 still shows blank lines for invisible rows (why?). Any ideas.Please let me know. Veeren.


hi I Have deleted my sql table data (delete from employee) but this was a fault.i was suppose to delete data from other table what should i do to get my data back i have used (ROLLBACK select * from employee) to get my data back but it didnt help me.my DataBase recovery mode is also set to FUll ,still i am not able to get back my data Plaese Help me what query should i run?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend