MartinIsti MS BI blog - All Comments

re: NUMBER without Precision

MartinIsti — Thu, 25 Jun 2009 09:38:28 GMT

Thanks for the comment (I rarely have any :)) and for the link as well!

re: NUMBER without Precision

ShortLived — Thu, 25 Jun 2009 06:08:39 GMT

Apparently I wasn't patient enough - I found the anwer on this link:

pragmaticworks.com/.../making-the-ssis-data-reader-source-query-dynamic.aspx

re: NUMBER without Precision

ShortLived — Thu, 25 Jun 2009 05:31:30 GMT

While it did work the SQLCommand property for the DataReader source doesn't suuport expressions. I need to be able to dynamically change the WHERE clause and with the OLE DB soource I can use SQL Command from a varaible as the AccessMode property.

Is there an easy way using the script task to set the SQLCommand property of the DataReader source?

Thank you.

re: for starter ...

simonsabin — Wed, 08 Apr 2009 23:49:25 GMT

test

re: Star or Snowflake i.e., 1 or 2 Dim tables?

MartinIsti — Tue, 10 Feb 2009 11:37:51 GMT

Thanks for the comments Miky and Simon, as a beginner blogger it's good to know that there are people out there who read my posts!

In the meanwhile we've chosen to implement my version! :)

re: Star or Snowflake i.e., 1 or 2 Dim tables?

simonsabin — Mon, 09 Feb 2009 20:44:01 GMT

Given an answer of 100 has no meaning with out the context of the question I would agree with you.

re: Star or Snowflake i.e., 1 or 2 Dim tables?

Miky Schreiber — Mon, 09 Feb 2009 14:23:03 GMT

I think that your design is better because there always should be only one FK from the fact to the dimension. I assume that each answer has only one question (parent) and in this situation your design is better.

re: Multicast error

MartinIsti — Sun, 07 Dec 2008 19:45:29 GMT

Yes, you're right. The tricky part was that I received no error messages and the package just stopped without any shown reason.

It was the first SSIS solution I had to manage and another guy created it so it was hard to find the correct clue.

At least I had a chance to learn from my mistake :)

re: Multicast error

Miky Schreiber — Sun, 07 Dec 2008 18:02:34 GMT

It seems that you had some kind of a deadlock over there.

As a best practice, an ETL process should not have more than one target for each table. This takes for every ETL tool, not only for SSIS. Also, if you have some targets to tables with relationships between them you need to be extra careful (try not to get to that situation at all).

re: for starter ...

Miky Schreiber — Sun, 07 Dec 2008 17:47:04 GMT

Hi Martin,

I'm happy to read that I'm a source of inspiration. Good luck in the blogging!

Miky

re: Multicast error

MartinIsti — Thu, 04 Dec 2008 13:52:24 GMT

I've corrected the picture layout.

And since this is my first real post would you share me your opinion?

re: Multicast error

jamiet — Thu, 04 Dec 2008 12:24:38 GMT

The pictures aren't displaying. Could you correct that please?