Data tarsfer from one table to another with different schema on sqlserver 2000

Hi all
I am working on SqlServer 2000,
When row will be inserted/updated in one table that data neds to be
inserted/updated into the another DataBase on the same machine. Both
table has different schema, what is the Better solution? I know we can
do it with Trigger, But Is there any better way to do it?
Thanks
ABCL
> do it with Trigger, But Is there any better way to do it?
How do you insert/update the data ? By using SP? If so insert/update into
another table within the same SP.
I hope you don't have permmisions problems when you update/insert the
data into differnt schem/user owner object
"ABCL" <ohmp05@.hotmail.com> wrote in message
news:64f2096c-1e83-4e6a-8cec-2f0f818284bd@.n77g2000hse.googlegroups.com...
> Hi all
> I am working on SqlServer 2000,
> When row will be inserted/updated in one table that data neds to be
> inserted/updated into the another DataBase on the same machine. Both
> table has different schema, what is the Better solution? I know we can
> do it with Trigger, But Is there any better way to do it?
> Thanks
|||On Mar 16, 8:01Xam, ABCL <ohm...@.hotmail.com> wrote:
> Hi all
> X I am working on SqlServer 2000,
> XWhen row will be inserted/updated Xin one table that data neds to be
> inserted/updated into the another DataBase on the same machine. Both
> table has different schema, what is the Better solution? I know we can
> do it with Trigger, But Is there any better way to do it?
> Thanks
Actually we want to SynchroniZe the Data from one DataBase to another
and vise versa on Insert/update and delete.
How Can we Perform Data Synchronization on both the DataBase with
different schema.
If I write trigger, I think There will be endless loop If both Tables
hava trigger on inster/update and Delete.
Do u have any solution for that? I am new to perform this kind of task
Is it possible with DTS( scheduled job)?
Is there any Performance Issue?
sql

Data tarsfer from one table to another with different schema on sql

Hi all
I am working on SqlServer 2000,
When row will be inserted/updated in one table that data neds to be
inserted/updated into the another DataBase on the same machine. Both
table has different schema, what is the Better solution? I know we can
do it with Trigger, But Is there any better way to do it?
ThanksABCL
> do it with Trigger, But Is there any better way to do it?
How do you insert/update the data ? By using SP? If so insert/update into
another table within the same SP.
I hope you don't have permmisions problems when you update/insert the
data into differnt schem/user owner object
"ABCL" <ohmp05@.hotmail.com> wrote in message
news:64f2096c-1e83-4e6a-8cec-2f0f818284bd@.n77g2000hse.googlegroups.com...
> Hi all
> I am working on SqlServer 2000,
> When row will be inserted/updated in one table that data neds to be
> inserted/updated into the another DataBase on the same machine. Both
> table has different schema, what is the Better solution? I know we can
> do it with Trigger, But Is there any better way to do it?
> Thanks|||On Mar 16, 8:01=A0am, ABCL <ohm...@.hotmail.com> wrote:
> Hi all
> =A0 I am working on SqlServer 2000,
> =A0When row will be inserted/updated =A0in one table that data neds to be
> inserted/updated into the another DataBase on the same machine. Both
> table has different schema, what is the Better solution? I know we can
> do it with Trigger, But Is there any better way to do it?
> Thanks
Actually we want to SynchroniZe the Data from one DataBase to another
and vise versa on Insert/update and delete.
How Can we Perform Data Synchronization on both the DataBase with
different schema.
If I write trigger, I think There will be endless loop If both Tables
hava trigger on inster/update and Delete.
Do u have any solution for that? I am new to perform this kind of task
Is it possible with DTS( scheduled job)?
Is there any Performance Issue?

data synchronisation

Hi,

I'm working with two databases on to physicaly separated servers: #1
is on a local machine en I can only connect to #2 via an ADSL
connection.
I need to syncrhonise the data. This works fine via the wizard from
the Enterprise Manager. But I want to get this done via a script form
the Query Analyzer that I can run whenever I want to. Something like:

insert into srv1.database.dbo.table1
select * from srv2.database.dbo.table1

When I do this I get an error about "linked servers". That surprises
me, because I have no linked servers configured and yet the wizard
works fine?

Can anyone tell me how to accomplish this?

tav
Jan Willemsjhmwillems@.hotmail.com (Jan) wrote in message news:<240176c1.0404060206.4bfaaca3@.posting.google.com>...
> Hi,
> I'm working with two databases on to physicaly separated servers: #1
> is on a local machine en I can only connect to #2 via an ADSL
> connection.
> I need to syncrhonise the data. This works fine via the wizard from
> the Enterprise Manager. But I want to get this done via a script form
> the Query Analyzer that I can run whenever I want to. Something like:
> insert into srv1.database.dbo.table1
> select * from srv2.database.dbo.table1
> When I do this I get an error about "linked servers". That surprises
> me, because I have no linked servers configured and yet the wizard
> works fine?
> Can anyone tell me how to accomplish this?
> tav
> Jan Willems

The Import/Export Data wizard uses a separate connection to each
server, so linked servers are not involved. The INSERT statement above
does require the linked servers to exist, however.

So you could just create the linked servers you need, or if that's not
possible for some reason, then you can save a DTS package from the
wizard, and execute it in whatever way is most convenient:

http://www.sqldts.com/default.aspx?104

Simon

Data SOurce View and Missing Diagrams

Guys, I am a newbie working through the SSAS tutorial. I am at lesson 5 and something has gone wrong with my Data Source View. Although I have diagrams in the Diagram Source pane I can not get them to show in the actual diagram pane. That pane just shows a grey background rather than the cream canvas. New diagrams in that data source view show the same problem.

If I create a new Data Sorce View, I can create diagrams and see them.

I do not want to create a new Data Sorce View and abandon the old one, because it will break the tutorial. I do not have a record of everything that was in the old one. Neither do I know how to repoint my cube at the new Data Sorce View.

Can someone please tell me how to restore the view of the diagrams.

Thanks

Cliff

How about re-installing the tutorial files? It is hard to tell what was wrong, but you might want to send the broken solution to andrewgaATnetzeroDOTcom and i will take a look.

In order to change the data source view for the cube you can invoke View | Code menu item when the cube designer is open, locate the XML code like below and replace the ID of the DSV.

<Source dwd:design-time-name="80d8b583-e073-4437-83cc-f17c461bfa13">
<DataSourceViewID>Simple Sales</DataSourceViewID>
</Source>

Note, that you will probably have to change bindings for existing measures.sql

Data Source From ORACLE

Currently, I am working SSIS project that its data source from ORACLE 9i. I installed full SSIS in server and also ORACLE. So, I have three connections available in server. They are the following below.

Oracle Client

Microsoft OLE DB Provider for Oracle

Oracle Provider for OLE DB

The problem is the three component can not recognize parameterization and ORACLE store procedures.

Finally, I executed the store procedures by ORACLE package from command prompt (bat files). So, the command execute from SSIS package.

Ashari Imamddin

You can put your SQL statements into SSIS variables and then via expressions pass them the parameters you need. Then in you OLE DB source choose SQL Command from variable.

Data Source expression not working

Hello, I am trying to use a data source expression but I'm getting an error. Here is my data source expression:

="data source=" & Parameters!ServerName.Value & ";initial catalog=AdventureWorks"

I have created a report parameter called ServerName. However, when I deploy the report and report viewer opens, I get the following error:

An error has occurred during report processing. (rsProcessingAborted) Error during processing of the ConnectString expression of datasource ‘AdventureWorks’. (rsDataSourceConnectStringProcessingError)

Is there some really obvious step I am missing here? The relevant parts of my rdl are below.

Thanks in advance

<DataSources>

<DataSource Name="AdventureWorks">

<ConnectionProperties>

<ConnectString>="data source=" &amp; Parameters!ServerName.Value &amp; ";initial catalog=AdventureWorks"</ConnectString>

<DataProvider>SQL</DataProvider>

</ConnectionProperties>

<rdataSourceID>(some stuff here)</rdataSourceID>

</DataSource>

</DataSources>

...

<ReportParameters>

...

<ReportParameter Name="ServerName">

<DataType>String</DataType>

<Prompt>ServerName</Prompt>

</ReportParameter>

</ReportParameters>

Found the solution in another thread...

(quoting)

Very simple solution, it turns out... just make sure the ServerName and DBName parameters appear above all other parameters in the report definition.

Would be great if this msdn article were edited to mention that!

Data Provider List Missing...very odd SQL 2000

Hey All!

I have an interseting situation with one of my dev machines. (W2k3EE, SQL2k SP4)

All my linked servers stopped working posting this error:

Server: Msg 7302, Level 16, State 1, Line 1
Could not create an instance of OLE DB provider [enter provider name here, e.g. 'SQLOLEDB'.

So...when attempting to drop and recreate the linked server, the Provider pull down in the GUI is completely empty.

YIKES!

I'm thinking of reinstalling MDAC, but I've never seen this in 10 years of DBA'ing.

Have any of you? Any thoughts out there? Registry issues?

Cheers,
OddNever seen anything like it either. I'm running the same combination in my environment, so if you have any solutions, please post.

Some thoughts and/or suggestions:

1. Was the server recently patched?

2. Was any new software (eg. driver package) recently installed?

3. Any entries in the Application or System error log(s)?

4. Do you back up the registry on this machine? Can it be restored?

Regards,

hmscott|||Thanks for the reply...will definitely post what I find...

1 - yeah, SP4
2 - prolly so...the network guys love to drop agents on my dev servers without mentioning it...Alteris monitor, i think this time
3 - nada
4 - heck no, that would be too easy

:)

Data not being partitioned properly?

Howdy all. Im trying to take advantage of this new feature, but it's not
working as I had expected. Below is the DDL and DML, with explanations of
what Im trying to accomplish and where my confusion is.
USE [AdventureWorks]
GO
/****** Object: PartitionFunction [myRangePF2] Script Date: 11/17/2006
15:01:28 ******/
CREATE PARTITION FUNCTION [myRangePF2](int) AS RANGE LEFT FOR VALUES (1,
100, 1000)
/****** Object: PartitionScheme [myRangePS2] Script Date: 11/17/2006
15:10:35 ******/
CREATE PARTITION SCHEME [myRangePS2] AS PARTITION [myRangePF2] TO
([PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY])
CREATE TABLE [dbo].[PartitionTest](
[PTPK] [int] IDENTITY(1,1) NOT NULL,
[salary] [int] NOT NULL,
CONSTRAINT [PK_PartitionTest] PRIMARY KEY CLUSTERED
(
[PTPK] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [myRangePS2]([PTPK])
) ON [myRangePS2]([PTPK])
insert into PartitionTest (salary) values (1)
insert into PartitionTest (salary) values (99)
insert into PartitionTest (salary) values (999)
insert into PartitionTest (salary) values (9999)
/*
From BOL:
Partition 1 2 3 4
Values
col1 <= 1
col1 > 1 AND col1 <= 100
col1 > 100 AND col1 <= 1000
col1 > 1000
Now if I understand correctly, there should be 1 row of data in each
partition?*/
CREATE TABLE [dbo].[PartitionTestArchive](
[PTPK] [int] IDENTITY(1,1) NOT NULL,
[salary] [int] NOT NULL,
CONSTRAINT [PK_PartitionTestArchive] PRIMARY KEY CLUSTERED
(
[PTPK] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [myRangePS2]([PTPK])
) ON [myRangePS2]([PTPK])
/*Now I want to move all the data (value 9999) in partition 4 into my new
ParitionTestArchive table:*/
alter table PartitionTest
switch partition 4 to [PartitionTestArchive] partition 4
/*But this did nothing. So I try:*/
alter table PartitionTest
switch partition 3 to [PartitionTestArchive] partition 3
/*And that did nothing either. So I try:*/
alter table PartitionTest
switch partition 2 to [PartitionTestArchive] partition 2
/*And that moved every row of data with a value > 1 (99,999,9999) in the
table to PartitionTestArchive.*/
Again, my goal was just to move the row of data with value 9999 (partition
4) into PartitionTestArchive. So what am I not understanding? It seems that
I either don't understand the concept, or data isn't going into the
partition I think it should?
TIA, ChrisR"ChrisR" <noFudgingWay@.NoEmail.com> wrote in message
news:#4uzWhpCHHA.1224@.TK2MSFTNGP04.phx.gbl...
> Howdy all. Im trying to take advantage of this new feature, but it's not
> working as I had expected. Below is the DDL and DML, with explanations of
> what Im trying to accomplish and where my confusion is.
> USE [AdventureWorks]
> GO
> /****** Object: PartitionFunction [myRangePF2] Script Date: 11/17/2006
> 15:01:28 ******/
> CREATE PARTITION FUNCTION [myRangePF2](int) AS RANGE LEFT FOR VALUES (1,
> 100, 1000)
>
> /****** Object: PartitionScheme [myRangePS2] Script Date: 11/17/2006
> 15:10:35 ******/
> CREATE PARTITION SCHEME [myRangePS2] AS PARTITION [myRangePF2] TO
> ([PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY])
>
> CREATE TABLE [dbo].[PartitionTest](
> [PTPK] [int] IDENTITY(1,1) NOT NULL,
> [salary] [int] NOT NULL,
> CONSTRAINT [PK_PartitionTest] PRIMARY KEY CLUSTERED
> (
> [PTPK] ASC
> )WITH (IGNORE_DUP_KEY = OFF) ON [myRangePS2]([PTPK])
> ) ON [myRangePS2]([PTPK])
>
> insert into PartitionTest (salary) values (1)
> insert into PartitionTest (salary) values (99)
> insert into PartitionTest (salary) values (999)
> insert into PartitionTest (salary) values (9999)
>
> /*
> From BOL:
> Partition 1 2 3 4
> Values
> col1 <= 1
> col1 > 1 AND col1 <= 100
> col1 > 100 AND col1 <= 1000
> col1 > 1000
>
> Now if I understand correctly, there should be 1 row of data in each
> partition?*/
>
You partitioned the table on PTPK, not Salary.
select $PARTITION.myRangePF2([PTPK]) Partition, *
from PartitionTest
Partition PTPK salary
-- -- --
1 1 1
2 2 99
2 3 999
2 4 9999
(4 row(s) affected)
David|||Woops!
Thanks.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:%23PgDEopCHHA.4680@.TK2MSFTNGP04.phx.gbl...
>
> "ChrisR" <noFudgingWay@.NoEmail.com> wrote in message
> news:#4uzWhpCHHA.1224@.TK2MSFTNGP04.phx.gbl...
> > Howdy all. Im trying to take advantage of this new feature, but it's not
> > working as I had expected. Below is the DDL and DML, with explanations
of
> > what Im trying to accomplish and where my confusion is.
> >
> > USE [AdventureWorks]
> >
> > GO
> >
> > /****** Object: PartitionFunction [myRangePF2] Script Date:
11/17/2006
> > 15:01:28 ******/
> >
> > CREATE PARTITION FUNCTION [myRangePF2](int) AS RANGE LEFT FOR VALUES (1,
> > 100, 1000)
> >
> >
> >
> > /****** Object: PartitionScheme [myRangePS2] Script Date: 11/17/2006
> > 15:10:35 ******/
> >
> > CREATE PARTITION SCHEME [myRangePS2] AS PARTITION [myRangePF2] TO
> > ([PRIMARY], [PRIMARY], [PRIMARY], [PRIMARY])
> >
> >
> >
> > CREATE TABLE [dbo].[PartitionTest](
> >
> > [PTPK] [int] IDENTITY(1,1) NOT NULL,
> >
> > [salary] [int] NOT NULL,
> >
> > CONSTRAINT [PK_PartitionTest] PRIMARY KEY CLUSTERED
> >
> > (
> >
> > [PTPK] ASC
> >
> > )WITH (IGNORE_DUP_KEY = OFF) ON [myRangePS2]([PTPK])
> >
> > ) ON [myRangePS2]([PTPK])
> >
> >
> >
> > insert into PartitionTest (salary) values (1)
> >
> > insert into PartitionTest (salary) values (99)
> >
> > insert into PartitionTest (salary) values (999)
> >
> > insert into PartitionTest (salary) values (9999)
> >
> >
> >
> > /*
> >
> > From BOL:
> >
> > Partition 1 2 3 4
> >
> > Values
> >
> > col1 <= 1
> >
> > col1 > 1 AND col1 <= 100
> >
> > col1 > 100 AND col1 <= 1000
> >
> > col1 > 1000
> >
> >
> >
> > Now if I understand correctly, there should be 1 row of data in each
> > partition?*/
> >
> >
> You partitioned the table on PTPK, not Salary.
> select $PARTITION.myRangePF2([PTPK]) Partition, *
> from PartitionTest
> Partition PTPK salary
> -- -- --
> 1 1 1
> 2 2 99
> 2 3 999
> 2 4 9999
> (4 row(s) affected)
> David
>
>

Data missing

Hey I'm really really new to crystal reports and I'm working on setting up a new paramater field and I'm running into some issues. The table for some reason is not showing all the data it should meaning its missing some records. When I go into SQL manager the data all seems to be there and in order but when I pull the same data into crystal part is missing. I looked at the way I had the tables linked to see if that would have something to do with the data is coming up but from the best I can tell everything looks fine. Has anyone noticed similar issues with a report if so what steps did you take to hunt down the problem?Did you use any Selection Formulas?
If so remove them
Also Do Verify Database

Data Mapping Database Report

I am working on a data mapping project (i.e. mapping tables from a SQL server database to VSAM files on a mainframe). I know that's bass-ackwards .. but that's what "the man" wants. And what "the man" wants he gets :)

What i am trying to do is to produce one report for each table (in the SQL server database). Each report would contain one column per field-name. Along with the field-name, i would like to also include the 10 most popular values of that field, a count for each, and one key per value (to refer-back).

If anyone is following along, do you have any suggestions ?? I'm assuming Crystal MUST have this functionality, but i'm banging my head against a wall trying to figure out even where to begin.

Thanks in advance !!The first part is easy - I presume you can use the report expert to get the raw data from the SQL table and show that as columns in the report. Am I right?

If you can do that, then you want to produce an individual count for each field - do you mean a count of unique elements for each field, and then the topN for each field.

Here's some sample data, by way of clarification:
ID Name City Salary
1 John A 20000
2 Fred A 20000
3 Mary A 50000
4 Kim B 35000
5 **** C 33000

A = 3 90000
B = 1 35000
C = 1 33000

If that is a very simple example, then you need to create a group for each field that you want to summarise, in this case City, and then create Count field in groop footer for City, and Sum field for Salary.

There's a start. TopN side of things should be able to be achieved using the TopN/Group Sort expert.

If you havew lots of fields, you'll have lots of groups.......my example groups on only City, so is simple, but your could end up looking rather ugly, I think!

Dave|||Hey Dave,

You're on the right track, but what i wanna do is "flip" the report around a little. Let's say i have a Customer table ... with SSN, Name, Addr.

I want my report to contain ONE ROW for each field-value ... not one column. My columns would be the Field-Name, Most Popular Occurence, Refer-Back key, and Count.

I would want my report to look like ...

Field Most popular value 1 Key (to refer back) Count (for that value)

SSN 111111111 111111111 1
222222222 222222222 1
333333333 333333333 1
...
123459699 123459699 1

Name John Smith 243050630 24
Dave Smith 294848372 22
Bob Jones 249858382 21
...
Tom Brown 385838375 11

Addr 123 Main St 948473859 6
123 Main Dr 938584894 6
222 Main St 983583959 4
...
123 Broadway 958347583 2

Thanks for your input !

I know that's ugly. My fields are lined up in my message text, but all of the spacing is ignored when the message is saved.

I want one row per field-name, and then 10 Values, refer-backs, and counts for each field name.

Data Loss with Merge Replication?

We had merge replication setup between 2 tables, Table A and Table B using SQL 2000. This was working 100%. The users asked to disable updated/deletes to both these tables if data existed on 2 other tables. Table AA and Table BB. We implemented it as follows:

1) Created Insert/Update/Delete triggers for Table A & B. It basically check for Table A is there a record in Table AA, if it exists, raise an error and don’t commit.

2) Removed all foreign constraints from Table AA and BB

3) Added Table AA and BB to the current replication.

Then all hell broke loose, we got conflicts all other the place saying that Table AA cannot be updated because records does not exist in Table X. To our surprise we found triggers generated by Erwin in 1998 – that check for “foreign contsraints” and removed them immediately.

We continued to get conflicts but could see from the error messages it was generated by the triggers in point 1. We added the NOT FOR REPLICATION clause and everything has been running smoothly or so we thought…..

After 2 months we got a call that data is missing. It’s random data and the only explanation I have is that replication caused that. My biggest reason for saying this is tracking the application audit trail I’ve found that all the data missing was added during the period we had all the conflicts.

I need a solid explanation for this and can anyone confirm that this is possible?

Yes it's possible for merge replication to lose changes, but these types of scenarios are rare, and even if this was the case it most likely cannot be investigated two months after the fact, especially if metadata has been cleaned up. However simply blaming replication is not fair, you really need to investigate what changes were made, what conflicts were occuring, what conflicts were and weren't resolved.

You should also make it a point to run validation every so often to catch nonconvergence issues earlier, this way when you find you're missing data, it can be investigated with all the necessary information available.

|||Thanks for your quick response Greg. I was unfortunatly not involved when the conflicts were resolved and have no idea how it was done. My knowledge of replication is also verly limited. Does SQL keep a history of replication and can you give me some guidelines to resolve this issue. The client is very unhappy as you can imagine and I need to give an explanation. We have already put measures in place to do validation but it's a case of a little to late.......|||In these kinds of scenarios where you experience data loss and believe it's replication, you need to call CSS (Microsoft customer support) and open a case with them, they have engineers who are experts in investigating problems like this.

Data Loss in SQL Server 2000

I set up a server for a client with Small Business Server
2000. Everything is working well except for SQl server.
The database was designed by a third party. Said third
party imported the database and everthing looked ok. The
database uses Access XP as its front end. I have the
latest patches on all parts of the server including SQL
2000 and the lastest ODBC drivers on all desktops (around
5-7, all running XP prof or 2000). Now onto the problem.
Users have been experiencing data ie records they update
sometimes do not show the changes when check them later
(anywhere from a couple of hours to next day). I have
been called out to look for network problem or server
overload etc. Everything I check out is fine. Third party
has not really looked into problems with logs etc and
keeps bringing up things for me to do. How can I check
for problems with the database and what tools should I
use? I do not have much experience with SQL server as
this is my only client that uses it. I am very
experienced with server and exchange. Any help would be
greatly appreciated."Tim" <tim@.buckeyemicro.com> wrote in message
news:133e01c37316$c70b57f0$a301280a@.phx.gbl...
> I set up a server for a client with Small Business Server
> 2000. Everything is working well except for SQl server.
> The database was designed by a third party. Said third
> party imported the database and everthing looked ok. The
> database uses Access XP as its front end. I have the
> latest patches on all parts of the server including SQL
> 2000 and the lastest ODBC drivers on all desktops (around
> 5-7, all running XP prof or 2000). Now onto the problem.
> Users have been experiencing data ie records they update
> sometimes do not show the changes when check them later
> (anywhere from a couple of hours to next day). I have
> been called out to look for network problem or server
> overload etc. Everything I check out is fine. Third party
> has not really looked into problems with logs etc and
> keeps bringing up things for me to do. How can I check
> for problems with the database and what tools should I
> use? I do not have much experience with SQL server as
> this is my only client that uses it. I am very
> experienced with server and exchange. Any help would be
> greatly appreciated.
>
First, SqlServer doesn't loose updates. Period. It just doesn't happen.
So 99% this is an application problem, either an outright bug, or a
concurrency problem like users overwriting each others changes.
You could use a tool like Lumigent's log explorer
(http://www.lumigent.com/products/le_sql/le_sql.htm) to see what happened to
the changes. Or you could start a SQLProfiler trace and just let it run to
a file on the server, and dig through it later for evidence of the missing
updates. Your best hope is to get the users to reproduce the error:
concentrate on having multiple users making changes that might interfere
with each other. If you can describe exactly how to reproduce the problem
the software vendor should be able to fix it.
So in short, this isn't your problem, but you may have to play dective to
get the ball rolling. But you've got to fight when the third party puts the
ball back in your court. This is a common tactic that software people use
to deflect blame or stall for time (at least so I've heard ;)). Be helpful,
but don't be a pushover. SQLServer doesn't just loose updates. Only
applications can do that. If there were any kind of network problem or
serious server problem the users would be getting errors, not lost updates.
David

Data load: want to redirect extant rows in table to a file

We are working on a DataWarehouse app. The DW has been loaded wiith transactional data from the start of September. and we want refresh the DW with a full load from the original source. This full load wil consist largely of the same records that we loaded initially in the DW but some records will be new and others will have changed.

During the load I want to direct input records NOT already in the DW to a "mods" table and ignore those input records that alreayd exist in the DW. Can SSIS help out with this task?

TIA,

Barkingdog

Use a lookup task to compare the input with the existing table. Redirect errors to the "mods" table and ignore all records where the lookup succeeds.

Data in Table not showing

I am just starting with Report Services, so this may be an easy or dumb
problem but here goes:
I am working in Visual Studio with a simple report based on a sproc with
several parameters that returns a result set. In the report I have set up a
table and the dataset for it, as well as the parameters. Everything works
great until I test the report, the report renders but the table shows as
having no data. I can go to the data tab and run the sproc and enter the
same parameters and I get data back.
I have checked all the places I could think of that might hide the data, but
nothing.
I'm hoping someone else has been through this or has some ideas on where I
could look.
TIA,
NancyHave you added a filter somewhere? Edit the dataset on the Data tab, click
the Filters tab and see. Also go to Properties of your table and check the
Filters tab. If your sproc returns data, the data should appear in the
report. I have a sproc in one of my reports and ti works just fine.
Charles Kangai, MCT, MCDBA
"Nancy Lytle" wrote:
> I am just starting with Report Services, so this may be an easy or dumb
> problem but here goes:
> I am working in Visual Studio with a simple report based on a sproc with
> several parameters that returns a result set. In the report I have set up a
> table and the dataset for it, as well as the parameters. Everything works
> great until I test the report, the report renders but the table shows as
> having no data. I can go to the data tab and run the sproc and enter the
> same parameters and I get data back.
> I have checked all the places I could think of that might hide the data, but
> nothing.
> I'm hoping someone else has been through this or has some ideas on where I
> could look.
> TIA,
> Nancy
>
>|||Thanks, I went ahead and I checked for filters and I can find none. I know
it must be something simple I am missing.
Any other ideas? Anyone?
TIA,
Nancy
"Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
news:53541C34-C4A7-4769-AB92-43C023605AFD@.microsoft.com...
> Have you added a filter somewhere? Edit the dataset on the Data tab, click
> the Filters tab and see. Also go to Properties of your table and check the
> Filters tab. If your sproc returns data, the data should appear in the
> report. I have a sproc in one of my reports and ti works just fine.
> Charles Kangai, MCT, MCDBA
> "Nancy Lytle" wrote:
> > I am just starting with Report Services, so this may be an easy or dumb
> > problem but here goes:
> >
> > I am working in Visual Studio with a simple report based on a sproc with
> > several parameters that returns a result set. In the report I have set
up a
> > table and the dataset for it, as well as the parameters. Everything
works
> > great until I test the report, the report renders but the table shows as
> > having no data. I can go to the data tab and run the sproc and enter
the
> > same parameters and I get data back.
> > I have checked all the places I could think of that might hide the data,
but
> > nothing.
> >
> > I'm hoping someone else has been through this or has some ideas on where
I
> > could look.
> > TIA,
> > Nancy
> >
> >
> >

Data in Report Headers

I'm having the devil of a time working around RS limitations here.
I have a report that displays a purchase order. ON all pages but the first I'm supposed to display a header like this:
From: OUR NAME To: Vendor Name
PO 123456 Page 2 of 4 Date: 01 January 2007
The three non-date fields in the header appear in the datasets used in the report. After much trial and error I ended up
creating three hidden textboxes in the report body that contain the data I want to use in the header. I then use separate
textboxes in the header which refer to those textboxes in the body.
Aside from the fact that this is a huge PITA, I find that this header only works properly on the first page of the report!
ON pages 2 and later the fields are empty!
Any suggestions? I'm pulling my hair out here on something that should be quite simple...
BarryMy favorite solution is to use internal parameters with query-based default
value.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Barry Seymour" <bseymour@.spamcop.net> wrote in message
news:Oa2GTf4LHHA.5016@.TK2MSFTNGP04.phx.gbl...
> I'm having the devil of a time working around RS limitations here.
> I have a report that displays a purchase order. ON all pages but the first
> I'm supposed to display a header like this:
> From: OUR NAME To: Vendor Name
> PO 123456 Page 2 of 4 Date: 01 January 2007
> The three non-date fields in the header appear in the datasets used in the
> report. After much trial and error I ended up
> creating three hidden textboxes in the report body that contain the data I
> want to use in the header. I then use separate
> textboxes in the header which refer to those textboxes in the body.
> Aside from the fact that this is a huge PITA, I find that this header only
> works properly on the first page of the report!
> ON pages 2 and later the fields are empty!
> Any suggestions? I'm pulling my hair out here on something that should be
> quite simple...
> Barry
>|||Otay... lemme research what the heck you mean and I'll come back if I don't get it. <g>
Barry
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message news:umi8F86LHHA.3588@.TK2MSFTNGP06.phx.gbl...
My favorite solution is to use internal parameters with query-based default
value.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Barry Seymour" <bseymour@.spamcop.net> wrote in message
news:Oa2GTf4LHHA.5016@.TK2MSFTNGP04.phx.gbl...
> I'm having the devil of a time working around RS limitations here.
> I have a report that displays a purchase order. ON all pages but the first
> I'm supposed to display a header like this:
> From: OUR NAME To: Vendor Name
> PO 123456 Page 2 of 4 Date: 01 January 2007
> The three non-date fields in the header appear in the datasets used in the
> report. After much trial and error I ended up
> creating three hidden textboxes in the report body that contain the data I
> want to use in the header. I then use separate
> textboxes in the header which refer to those textboxes in the body.
> Aside from the fact that this is a huge PITA, I find that this header only
> works properly on the first page of the report!
> ON pages 2 and later the fields are empty!
> Any suggestions? I'm pulling my hair out here on something that should be
> quite simple...
> Barry
>|||"Barry Seymour" wrote:
> Otay... lemme research what the heck you mean and I'll come back if I don't get it. <g>
> Barry
> "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message news:umi8F86LHHA.3588@.TK2MSFTNGP06.phx.gbl...
> My favorite solution is to use internal parameters with query-based default
> value.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Barry Seymour" <bseymour@.spamcop.net> wrote in message
> news:Oa2GTf4LHHA.5016@.TK2MSFTNGP04.phx.gbl...
> > I'm having the devil of a time working around RS limitations here.
> >
> > I have a report that displays a purchase order. ON all pages but the first
> > I'm supposed to display a header like this:
> >
> > From: OUR NAME To: Vendor Name
> > PO 123456 Page 2 of 4 Date: 01 January 2007
> >
> > The three non-date fields in the header appear in the datasets used in the
> > report. After much trial and error I ended up
> > creating three hidden textboxes in the report body that contain the data I
> > want to use in the header. I then use separate
> > textboxes in the header which refer to those textboxes in the body.
> >
> > Aside from the fact that this is a huge PITA, I find that this header only
> > works properly on the first page of the report!
> > ON pages 2 and later the fields are empty!
> >
> > Any suggestions? I'm pulling my hair out here on something that should be
> > quite simple...
> >
> > Barry
> >
> >
>
>|||Did you find out how to fix this? I'm having the same problem.
Ken
"Barry Seymour" wrote:
> Otay... lemme research what the heck you mean and I'll come back if I don't get it. <g>
> Barry
> "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message news:umi8F86LHHA.3588@.TK2MSFTNGP06.phx.gbl...
> My favorite solution is to use internal parameters with query-based default
> value.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Barry Seymour" <bseymour@.spamcop.net> wrote in message
> news:Oa2GTf4LHHA.5016@.TK2MSFTNGP04.phx.gbl...
> > I'm having the devil of a time working around RS limitations here.
> >
> > I have a report that displays a purchase order. ON all pages but the first
> > I'm supposed to display a header like this:
> >
> > From: OUR NAME To: Vendor Name
> > PO 123456 Page 2 of 4 Date: 01 January 2007
> >
> > The three non-date fields in the header appear in the datasets used in the
> > report. After much trial and error I ended up
> > creating three hidden textboxes in the report body that contain the data I
> > want to use in the header. I then use separate
> > textboxes in the header which refer to those textboxes in the body.
> >
> > Aside from the fact that this is a huge PITA, I find that this header only
> > works properly on the first page of the report!
> > ON pages 2 and later the fields are empty!
> >
> > Any suggestions? I'm pulling my hair out here on something that should be
> > quite simple...
> >
> > Barry
> >
> >
>
>|||We had a similar problem.
My workaround was to dump the Report Header and setup a 'dummy' group, it
must be the first group. 'Include Group Header' don't 'Repeat Group Header'
and don't 'Include Group Footer'.
Whatever you put it this group, it will accept parameters and dataset data
will only appear once at the beginning of the report.
Hope this helps

Data format conversion.

Hello,

I am jivesh, working on live project with asp.net & sql server2003. I am facing one problem, client is in belgium uses Dutch language, and we are english. when we enter decimal value in sql database it gets save but the client has server in dutch language and in Dutch "." is ",", so here sql gets conflict , it takes "," as character & gives error, eg .

Add an item and fill out the fields with numbers (e.g. 45.05 ). When you want to edit this item later on, the number has been changed to e.g. 45,05 and this gives an error .

While we input the values 45.05 it gets save as it is, but when we retrive the value in textbox to edit, it comes in the way 45,05. the dot gets converted in comma. please help me soon.

Thanx

As long as you use a numeric type, the comma or dot isn′t stored at all, this is just a case of client presentation issue. So that should be an issue. It depends on your client code how you handle those inserts to the database. Normally you pass a common decimal type to the server, so this one gets "converted" (or just inserted) into the database.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de