Showing posts with label step. Show all posts
Showing posts with label step. Show all posts

Thursday, March 8, 2012

BI and shipping line companies

Hi all,

As u know the first step in a BI solution is determining the BI goals. I need some samples of shipping line companies which have a BI solution. I have read so many customer stories from many BI corporations but nearly all of them focus on generating integrated systems and reports. I need more info if you can help me!

Previous thanx

yes i have some sample if u want then send me mail.

mail id is that

wise_boy620@.hotmail.com

Wednesday, March 7, 2012

BI - Test server

Hi,

I am new to BI. Can someone please tell me step by step how to setup BI test enviroment at work?

Thank you so much.

Ideally, duplicate your planned production environment on a different server and use that to test.

Setting up a test environment is dependent on a lot of variables, and this is a very vague question. If you have specific questions about SSIS in a test environment, please post them and we will try to help. If you need help on this type of general BI question, though, I'd recommend getting some training or contacting a BI company for a "jumpstart" type of engagement.

|||

Hi jwelch,

Sorry I was wrong/silly. Thanks for reply/your advise.

I will come back to you with the few questions.

Cheers

VungLiem

|||

Not wrong/silly, just looking for a little more focus in the questions so we can give you meaningful answers Smile

beware: SQL2005 management studio not 2000 compatible

using 2005 management studio i made changes to an 8 step job on SQL 2000
server. I inserted a new step into position 8 and then tried to save it.
SQL2005 management told me that some feature was not supported on SQL 2000
so i pressed cancel. at this point both SQL 2005 management studio and SQL
200) enterprise management both report a 4 step job.
It is going to take me hours to restore the 8 step job from a backup so that
it can be re-inserted into the live DB.
what a fiasco.
Leon
Leon McCalla (leonmccalla@.hotmail.com.junkfilter) writes:
> using 2005 management studio i made changes to an 8 step job on SQL 2000
> server. I inserted a new step into position 8 and then tried to save it.
> SQL2005 management told me that some feature was not supported on SQL 2000
> so i pressed cancel. at this point both SQL 2005 management studio and SQL
> 200) enterprise management both report a 4 step job.
> It is going to take me hours to restore the 8 step job from a backup so
> that it can be re-inserted into the live DB.
That's bad. That would indicate that there is no transaction handling. I
think this is quite a serious bug. Please go to http://connect.microsoft.com
and file a bug for this. Try to be as specific as possible. Best if you
can give a complete scenario which reproduces the problem. (A two-step job
should be sufficient, I guess.) I know that this will take even more time,
but if Microsoft does not get to know about the problem, they can't mend
their ways.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx