ETL from SQL server to SQL CE

How cai tranform data from an existing SQL server 2005 DB to a (.sdf) SQL server Compact Edition DB ?

I don't know the data provider name for connecting to a SQL CE DB..

ANy suggestions ?

You can use the SQL Server Compact Edition Destination component (with a File Connection Manager) in a Data Flow Task to "export" data to SQL Server Mobile. You can place some transformations between your data source and the destination component.

Estimate storage saving of varDecimal

For an existing database is there an automated method of calculating
the storage saving of using varDecimal storage type?
There is a whitepaper that was just released answering this very question:
http://msdn2.microsoft.com/en-us/library/bb508963.aspx
"Robin9876" <robin9876@.hotmail.com> wrote in message
news:1180623179.357966.223520@.h2g2000hsg.googlegro ups.com...
> For an existing database is there an automated method of calculating
> the storage saving of using varDecimal storage type?
>
|||I had already seen this but after reading it again I noticed that the
stored procedures mentioned could use the existing tables and not just
the best and worst cases as in the whitepaper.
On 31 May, 15:58, "Mike Walsh" <[mwalsh9815][at][gmail][dot][com]>
wrote:[vbcol=seagreen]
> There is a whitepaper that was just released answering this very question:
> http://msdn2.microsoft.com/en-us/library/bb508963.aspx
> "Robin9876" <robin9...@.hotmail.com> wrote in message
> news:1180623179.357966.223520@.h2g2000hsg.googlegro ups.com...

Estimate storage saving of varDecimal

For an existing database is there an automated method of calculating
the storage saving of using varDecimal storage type?There is a whitepaper that was just released answering this very question:
http://msdn2.microsoft.com/en-us/library/bb508963.aspx
"Robin9876" <robin9876@.hotmail.com> wrote in message
news:1180623179.357966.223520@.h2g2000hsg.googlegroups.com...
> For an existing database is there an automated method of calculating
> the storage saving of using varDecimal storage type?
>|||I had already seen this but after reading it again I noticed that the
stored procedures mentioned could use the existing tables and not just
the best and worst cases as in the whitepaper.
On 31 May, 15:58, "Mike Walsh" <[mwalsh9815][at][gmail][dot]
[com]>
wrote:[vbcol=seagreen]
> There is a whitepaper that was just released answering this very question:
> http://msdn2.microsoft.com/en-us/library/bb508963.aspx
> "Robin9876" <robin9...@.hotmail.com> wrote in message
> news:1180623179.357966.223520@.h2g2000hsg.googlegroups.com...
>

Estimate storage saving of varDecimal

For an existing database is there an automated method of calculating
the storage saving of using varDecimal storage type?There is a whitepaper that was just released answering this very question:
http://msdn2.microsoft.com/en-us/library/bb508963.aspx
"Robin9876" <robin9876@.hotmail.com> wrote in message
news:1180623179.357966.223520@.h2g2000hsg.googlegroups.com...
> For an existing database is there an automated method of calculating
> the storage saving of using varDecimal storage type?
>|||I had already seen this but after reading it again I noticed that the
stored procedures mentioned could use the existing tables and not just
the best and worst cases as in the whitepaper.
On 31 May, 15:58, "Mike Walsh" <[mwalsh9815][at][gmail][dot][com]>
wrote:
> There is a whitepaper that was just released answering this very question:
> http://msdn2.microsoft.com/en-us/library/bb508963.aspx
> "Robin9876" <robin9...@.hotmail.com> wrote in message
> news:1180623179.357966.223520@.h2g2000hsg.googlegroups.com...
> > For an existing database is there an automated method of calculating
> > the storage saving of using varDecimal storage type?sql

erwin and data modeling

I have just started using erwin on a new database project that would be part
of our existing data warehouse.
Currently, I use sql scripts to create table, stored procs etc. and then I
update the erwin data model. This is not a good idea because I would rather
drive my data model from central location such as erwin tool. I tried to
drive data structure from the tool but its not working
What are some of the best practices to use erwin with regards to data
modeling? Are there any sites, white papers that talk about how to best use
erwin? Online help for erwin is not much useful.
I could not find any articles on google on erwin best practices etc.
Please let me know.
TIA...Didn;t you evaluate these kinds of things / support options prior to
selecting Erwin as the tool of choice? That would be a solid best practise
for a start.
RR
"sqlster" <nospam@.nospam.com> wrote in message
news:8F357659-2CFE-40C5-9779-3D5B769EBE74@.microsoft.com...
> I have just started using erwin on a new database project that would be
part
> of our existing data warehouse.
> Currently, I use sql scripts to create table, stored procs etc. and then I
> update the erwin data model. This is not a good idea because I would
rather
> drive my data model from central location such as erwin tool. I tried to
> drive data structure from the tool but its not working
> What are some of the best practices to use erwin with regards to data
> modeling? Are there any sites, white papers that talk about how to best
use
> erwin? Online help for erwin is not much useful.
> I could not find any articles on google on erwin best practices etc.
> Please let me know.
> TIA...|||head on over to http://www.infoadvisors.com/
they have active newsgroups for many things erwin, and competeing products t
oo
good luck
"sqlster" <nospam@.nospam.com> wrote in message news:8F357659-2CFE-40C5-9779-3D5B769EBE74@.mi
crosoft.com...
>I have just started using erwin on a new database project that would be par
t
> of our existing data warehouse.
> Currently, I use sql scripts to create table, stored procs etc. and then I
> update the erwin data model. This is not a good idea because I would rathe
r
> drive my data model from central location such as erwin tool. I tried to
> drive data structure from the tool but its not working
> What are some of the best practices to use erwin with regards to data
> modeling? Are there any sites, white papers that talk about how to best us
e
> erwin? Online help for erwin is not much useful.
> I could not find any articles on google on erwin best practices etc.
> Please let me know.
> TIA...sql

Errors in the high-level relational engine

I'm getting the following error back when trying to process in a new measure group into an existing cube in 2005...

"Errors in the high-level relational engine. The data source view does not contain a definition for the 'dbo_view_FACT_CPR_Hours' table or view. The Source property may not have been set."

I'm in the process of migrating my 2000 objects to 2005. I've basically copied over the 2000 relational db over to a 2005 SQL server and am going through and recreating the cubes from scratch. I was having this problem with another fact table and was able to remedy by creating a named query rather then hitting the view directly (even though the named query pulled the view straight). This hasn't worked for all of the tables giving me problems though. I know it's not a permission issue because I can hit some, but not all the tables. The bizarre thing is, I can browse the data in the dsv so I know it is recognizing the datasource, it just isn't recognizing it in the cube.

When I try to go to the partition tab in the cube builder it throws an "object block not set" error and crashes, or just crashes so I'm pretty sure it has something to do with this.

Is anyone else experiencing this problem? Help!

It looks like Analysis Services cannot find a DSV table 'dbo_view_FACT_CPR_Hours' . One of Analysis Services objects is based on this table.

It is very possible you can query tables in DSV and see the data, but if one of the dimension attributes references old table or a view, you will get error like one you are seeing above.

There is nothing much you can do, but carefully go through the cube desing and clean problem after problem. What can help you is: Try and create XMLA script for your database and then search for a 'dbo_view_FACT_CPR_Hours' table. This way you should be able to find an error faster.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

That's the problem though, there is a 'dbo_view_FACT_CPR_Hours' table in the dsv. I can't understand why AS can't find it when processing the cube. I built the measure group in the cube referencing it that source in the dsv. The cube will process fine without that measure group but as soon as I add it in again and try to process it bombs.

I'll continue to investigate the code on my end. I'll let you know if I come up with something.

Thanks for your help.

Errors adding a column in 64-bit version

I have run into an interesting problem. I have some code that adds a column to an existing table. The column is set as primary key, identity and clustered. On the 32-bit version of SQL 2005 it works fine. It fails on the 64-bit version of 2005 intermittently with a "could not create unique index because duplicate values were found". Kind of odd, considering as an identity field it's creating the values. I was able to recreate the problem with the following schema:

Create table test1

(col1 varchar(20),

col2 varchar(20),

col3 uniqueidentifier default newid())

-- insert data

Declare @.counter int

set @.counter=1

While @.counter < 1000000

BEGIN

insert into test1

values ('Joe','Smith',default)

Set @.counter=@.counter+1

END

-- add column

Alter table test1 add col4 int constraint PK_test1 primary key clustered identity

After Running this, I get this error:

CREATE UNIQUE INDEX terminated because a duplicate key was found for object name 'dbo.Test1' and index name 'PK_test1'. The duplicate key value is (28).

Anybody else run into this? Why would this be happening, and is there any way to fix it? I'm running the 64-bit version of Windows 2003 and the the 64-bit version of SQL Server 2005.

Thanks in advance,

Mark

Could you please file a bug with these details / repro steps at the MSDN Product Feedback Center? I do not have a 64-bit m/c to try this out. Also, please mention the editions of Windows and SQL Server (x64, IA, EMT). Thanks.