Creating a Script component using SSIS Object model

I had a SSIS Package which was developed on Beta Version Of SSIS, Now We have Standard Edition Of SSIS(Sql2k5) Installed.
In the Package we have One Flat file Source, One Script Component and A Sql Server as Target, We are programaticaly creating the package, Now When we open this Package in the Designer and Try to Run We get this error
"The script component is configured to pre-compile the script, but binary code is not found. Please visit the IDE in Script Component Editor by clicking Design Script button to cause binary code to be generated. "
Now when we just open the Script Designer and close it, The package runs.
I found the Error description at this link
http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.hresults.dts_e_binarycodenotfound.aspx
but could not find any help on this.

Same thing use to work on Beta version now it is now working.
From my understanding the problem is that in beta version, the script use to run at runtime, Now what they have done is that they generate a compiled code out of script and run.
My problem is that since i am using C# code to generate the package, How Will I Create a Binary Code out of Script.

Creating the binary code is very easy. Go into the script component, click on "Script..." button to bring up VSA (i.e. the script editor) and then close VSA down again. This will create the binary code for you.

-Jamie

|||

What changed is that the default value of the Precompile property changed from False to True.

If you are not precompiling your scripts, all you need to do is change the value of that property on the Script component. Note that this will give you a significantly smaller package file, but you'll pay a small performance penalty at runtime.

-Doug

Creating a Report Model on a UDB datasource

Hi all,

I'm just getting started with Reporting Services and have a question.

I'm trying to set up a report model based on a UDB data source. However when I use the report model wizard, I get presented with:

[DB2/SUN] SQL0104N An unexpected token "SET TRANSACTION" was found following "BEGIN-OF-STATEMENT" ... SQLSTATE 42601.

I think that this is trying to set transaction isolation levels however this is not valid SQL for a UDB database.

Is there something that I'm missing with my configuration to make RS know that this is a non-SQLServer database?

Many thanks,

JK

Hello,

Did you ever receive an answer to this issue?

Thanks.

Creating a Report Model on a UDB datasource

Hi all,

I'm just getting started with Reporting Services and have a question.

I'm trying to set up a report model based on a UDB data source. However when I use the report model wizard, I get presented with:

[DB2/SUN] SQL0104N An unexpected token "SET TRANSACTION" was found following "BEGIN-OF-STATEMENT" ... SQLSTATE 42601.

I think that this is trying to set transaction isolation levels however this is not valid SQL for a UDB database.

Is there something that I'm missing with my configuration to make RS know that this is a non-SQLServer database?

Many thanks,

JK

Hello,

Did you ever receive an answer to this issue?

Thanks.

Creating a Report Model from Analysis Services Cube then Editing

I have been told that you can create a Report Model from an Analysis Services
Cube in the Model Designer even though the documentation says you can not.
I can import the Analysis Project that contains the cube into BI Development
Studio but I can not create a model from that project.
Does anyone know how to create then edit a model in the Model Designer(BI
Development Studio not Management Studio or Report Manager) that is based on
an AS Cube?
--
New user - jhpuddyhave you noticed ? both while creating report model and cube you can see
something called "Data Source View" nothing but building relationships
between tables. so same refer your dw database and create view and you can
use report model to create reports using cube and view.
Amarnath
"jhpuddy" wrote:
> I have been told that you can create a Report Model from an Analysis Services
> Cube in the Model Designer even though the documentation says you can not.
> I can import the Analysis Project that contains the cube into BI Development
> Studio but I can not create a model from that project.
> Does anyone know how to create then edit a model in the Model Designer(BI
> Development Studio not Management Studio or Report Manager) that is based on
> an AS Cube?
> --
> New user - jhpuddy|||Amarnath,
Thank you for responding.
But the problem is that I can't create a model from a cube in BI Development
Studio. I can create one in Management Studio but I can not edit the Model
after it is created. We were planning on doing all of the formatting,
grouping and filtering in the model but we can not do that if we can not edit
it. The only thing that comes up for the model is the source code, can not
edit the code.
--
New user - jhpuddy
"Amarnath" wrote:
> have you noticed ? both while creating report model and cube you can see
> something called "Data Source View" nothing but building relationships
> between tables. so same refer your dw database and create view and you can
> use report model to create reports using cube and view.
> Amarnath
>
> "jhpuddy" wrote:
> > I have been told that you can create a Report Model from an Analysis Services
> > Cube in the Model Designer even though the documentation says you can not.
> > I can import the Analysis Project that contains the cube into BI Development
> > Studio but I can not create a model from that project.
> > Does anyone know how to create then edit a model in the Model Designer(BI
> > Development Studio not Management Studio or Report Manager) that is based on
> > an AS Cube?
> >
> > --
> > New user - jhpuddy|||You can do one thing If you have created a Analysis services project ie cube.
you can create one using "create datasource from other object" from add data
source.
Amarnath
"jhpuddy" wrote:
> Amarnath,
> Thank you for responding.
> But the problem is that I can't create a model from a cube in BI Development
> Studio. I can create one in Management Studio but I can not edit the Model
> after it is created. We were planning on doing all of the formatting,
> grouping and filtering in the model but we can not do that if we can not edit
> it. The only thing that comes up for the model is the source code, can not
> edit the code.
> --
> New user - jhpuddy
>
> "Amarnath" wrote:
> > have you noticed ? both while creating report model and cube you can see
> > something called "Data Source View" nothing but building relationships
> > between tables. so same refer your dw database and create view and you can
> > use report model to create reports using cube and view.
> >
> > Amarnath
> >
> >
> > "jhpuddy" wrote:
> >
> > > I have been told that you can create a Report Model from an Analysis Services
> > > Cube in the Model Designer even though the documentation says you can not.
> > > I can import the Analysis Project that contains the cube into BI Development
> > > Studio but I can not create a model from that project.
> > > Does anyone know how to create then edit a model in the Model Designer(BI
> > > Development Studio not Management Studio or Report Manager) that is based on
> > > an AS Cube?
> > >
> > > --
> > > New user - jhpuddy|||Yes, I know I have done that. It lets you create a data source but does not
recognize that data source when you try to create a data source view. It
puts you into a sort of loop.
--
New user - jhpuddy
"Amarnath" wrote:
> You can do one thing If you have created a Analysis services project ie cube.
> you can create one using "create datasource from other object" from add data
> source.
> Amarnath
> "jhpuddy" wrote:
> > Amarnath,
> >
> > Thank you for responding.
> >
> > But the problem is that I can't create a model from a cube in BI Development
> > Studio. I can create one in Management Studio but I can not edit the Model
> > after it is created. We were planning on doing all of the formatting,
> > grouping and filtering in the model but we can not do that if we can not edit
> > it. The only thing that comes up for the model is the source code, can not
> > edit the code.
> > --
> > New user - jhpuddy
> >
> >
> > "Amarnath" wrote:
> >
> > > have you noticed ? both while creating report model and cube you can see
> > > something called "Data Source View" nothing but building relationships
> > > between tables. so same refer your dw database and create view and you can
> > > use report model to create reports using cube and view.
> > >
> > > Amarnath
> > >
> > >
> > > "jhpuddy" wrote:
> > >
> > > > I have been told that you can create a Report Model from an Analysis Services
> > > > Cube in the Model Designer even though the documentation says you can not.
> > > > I can import the Analysis Project that contains the cube into BI Development
> > > > Studio but I can not create a model from that project.
> > > > Does anyone know how to create then edit a model in the Model Designer(BI
> > > > Development Studio not Management Studio or Report Manager) that is based on
> > > > an AS Cube?
> > > >
> > > > --
> > > > New user - jhpuddy

Creating a report model based on related entities

I created a report model that has two entities. Both entities, in the SQL
terminology, can have an inner join. Now the two tables do not have any
foreign key relationship or anything. ..
Now when i open the report builder and select a field from one of the entity
the other one just dissapears away. What do i need to do to be able to select
fields from both entities ?The above question is for designing ad hoc reports through the report model.|||It is not visible because when you select an entity then that becomes a
primary entity and remaining is not visible. Now the entities related to the
selected or the primary will be visible. As you said that there is no
relation so it doesn't appear on the list and it wont appear. So you need to
have a relation to be able to select other fields as well.
Amarnath
"Tk_Neo" wrote:
> The above question is for designing ad hoc reports through the report model.|||I have a smilar problem. I have a single data source view which contains 3
tables. Each table is a completely denormalized (like a spreadsheet) dataset
from a particular business system. Within the datasource view editor I
created primary keys on each table and established relationships between each
table. However, when I try to create a report in report builder, as soon as
add an entity from one table to my report, the other 2 tables disappear.
What do I have to do to prevent the tables from disappearing? Please be
specific since I am fairly new to the Ad Hoc component of reporting services.
Thanks.
"Amarnath" wrote:
> It is not visible because when you select an entity then that becomes a
> primary entity and remaining is not visible. Now the entities related to the
> selected or the primary will be visible. As you said that there is no
> relation so it doesn't appear on the list and it wont appear. So you need to
> have a relation to be able to select other fields as well.
> Amarnath
> "Tk_Neo" wrote:
> > The above question is for designing ad hoc reports through the report model.

creating a report model based on a view

in my report model project, i'm able to successfully create and deploy a report model based on a data source view that is in turn based on a table object in my data store.

but if i try to create a report model that's based on a a data source view that is in turn based on a view in my data store, well then, the report model that gets created comes up blank - i.e. shows no objects.

What gives? Is it not possible to create a report based on a view? that can't be right!

NewJoizey wrote:

What gives? Is it not possible to create a report based on a view? that can't be right!

It is possible. But it's a little tricky to set up a model.

|||

that doesn't make sense. - i am sure that people must all the time set up a report based on a view that already exists. maybe there's another way that the procedure i'm trying to accomplish here?

|||

NewJoizey wrote:

i am sure that people must all the time set up a report based on a view that already exists.

Yes. You just have to set up a model with the proper relationships for your database first. Otherwise, it doesn't know what your data looks like.

It's like trying to construct a building without drawing up the blueprints.

Have you created a report before using business intelligence studio?

|||

yes I have successfullly created reports across different data stores, but it only seems to work based on tables, not views

I'm confused because I have an existing view that lives in my db. when I click "data source views" in my report project, i can clearly see all my database defined views in the wizard, and so I point the data source view (in my report project) to my desired view (database) I click finish and everything looks fine.

in my report project environment, i set up my report model based on my newly defined data source view, and under where it says "model" there's nothing zero zip nada, whereras my other report models clearly show all of the fields.

If there are extra steps to be able to do this properly, MS certainly doesn't make it very clear!

|||

I recommend this to you:

http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032273699&CountryCode=US

Creating a report model against an SSAS Cube in Visual Studio

I'm trying to create a report model in visual studio. I need the model
to report against an exiting cube. I can easily make the model in SQL
Server management studio. When I try to do the same in Visual Studio I
run up against a problem when I try to create the datasource view. The
steps I'm taking:
- I add a new Report Model Project into the solution that contains my
Analysis Services Project.
- I add a new datasource to the Report Model Project choosing to create
the source on an object and choosing the existing Analysis Services
Project.
- If I try to add a datasource view, the datasource I created doesn't
show up. (I've read in Microsoft documentation that this is designed
functionality)
- I can't find a way to create a report model directly against the
datasource and of course there is no datasource view. It would seem
that I should be able to create a report model directly against the
datasource since that's how both SQL Server Management Studio and the
reporting web interface works but I can't figure it out.
Can someone help me?I'm not sure I really understood what do you want to achieve
The way to create a model with Analysis Services data source is to :
a) open your Reporting Seervices with Mangement Studio
b) Choose your Analysis Services data source
c) Right click and choose "Generate a model..." from the contextual menu
Med Bouchenafa
"krosschell@.rdacorp.com" <talldrink@.gmail.com> a écrit dans le message de
news: 1138217467.115673.224510@.z14g2000cwz.googlegroups.com...
> I'm trying to create a report model in visual studio. I need the model
> to report against an exiting cube. I can easily make the model in SQL
> Server management studio. When I try to do the same in Visual Studio I
> run up against a problem when I try to create the datasource view. The
> steps I'm taking:
> - I add a new Report Model Project into the solution that contains my
> Analysis Services Project.
> - I add a new datasource to the Report Model Project choosing to create
> the source on an object and choosing the existing Analysis Services
> Project.
> - If I try to add a datasource view, the datasource I created doesn't
> show up. (I've read in Microsoft documentation that this is designed
> functionality)
> - I can't find a way to create a report model directly against the
> datasource and of course there is no datasource view. It would seem
> that I should be able to create a report model directly against the
> datasource since that's how both SQL Server Management Studio and the
> reporting web interface works but I can't figure it out.
> Can someone help me?
>|||When you say "Management Studio" I believe you are refering to SQL
Server Management Studio. I agree, creating a reporting model from
there is easy as cake. I'm trying to create a Reporting model from
Business Inteligence Management Studio. There is a project type "Report
Model Project" and I want to create a report model in this environemnt.
(one that uses a cube as it's data source). Does that make more sense?

Creating a Report Model - any doc other than Books Online?

Is there any documentation available on building a report model other than
the SQL Books Online? The subject is usually given about 3-5 pages max in
any Reporting Services book. I'd like to see a whole book on the subject,
with lots of examples.
--
LehrSJOn Sep 12, 6:18 pm, LehrSJ <lehr...@.noemail.nospam> wrote:
> Is there any documentation available on building a report model other than
> the SQL Books Online? The subject is usually given about 3-5 pages max in
> any Reporting Services book. I'd like to see a whole book on the subject,
> with lots of examples.
> --
> LehrSJ
This link might be helpful.
http://www.databasejournal.com/features/mssql/article.php/10894_3598931_1
Regards,
Enrique Martinez
Sr. Software Consultant

Creating a Report Model

I am primarily a web developer as of late utilizing Visual Web Developer 2005 Express with SQL 2005. I'd like to generate some reports from the data stored in SQL and like the options that the Reporting Services provides. However, I need to create a report model which I understand requires the full Visual Studio product.

Do, or will any of the Express editions of Visual Studio 2005 allow me to create a report model? I really don't have a need for Visual Studio 2005 - except it appears, to create a report model.

Thanks for any insight!

Visual Studio 2005 is not required. Model Designer is part of SQL Server 2005.

Creating a Report Model

I am primarily a web developer as of late utilizing Visual Web Developer 2005 Express with SQL 2005. I'd like to generate some reports from the data stored in SQL and like the options that the Reporting Services provides. However, I need to create a report model which I understand requires the full Visual Studio product.

Do, or will any of the Express editions of Visual Studio 2005 allow me to create a report model? I really don't have a need for Visual Studio 2005 - except it appears, to create a report model.

Thanks for any insight!

Visual Studio 2005 is not required. Model Designer is part of SQL Server 2005.

creating a newsgroup database with mssql

Need some idea about designing a model for newsgroup databaseI reccomend you start by learning normalization, lots of links out there, here's one that may help. http://www.sims.berkeley.edu/courses/is202/f98/Lecture12/sld001.htm

Might not be the answer you were looking for but will help you in the long run.

HTH|||Originally posted by rhigdon
I reccomend you start by learning normalization, lots of links out there, here's one that may help. http://www.sims.berkeley.edu/courses/is202/f98/Lecture12/sld001.htm

Might not be the answer you were looking for but will help you in the long run.

HTH

Thank you for the link

Creating a model in Report Manager

Can anyone help me?

I've read the instructions on the following page

http://msdn2.microsoft.com/en-us/library/ms159118.aspx

about how to generate a report model from a cube.

I can set up the cube as a data source but when I look at the properties there is no option to "Generate Model".

I am running SQL 2005 DE SP2(CTP).

The option is just not there for me. Any ideas?

Thanks in advance

Are you saying you don't get the 'Apply', 'Move','Generate Model','Delete' buttons at the bottom of the page?|||

Thanks for the reply. I get the 'Apply', 'Move' and 'Delete' buttons but not the 'Generate Model' one.

Very strange?

|||

The following conditions need to be satisfied for the button to be shown:

1) you must be using a shared data source

2) the data source must point to either a SQL server database, or a SQL Server 2005 Analysis Services cube, or if using SQL Server 2005 SP2 you can also use an Oracle data source.

3) you have read properties on the shared data source (you meet this condition it appears)

4) you have create model permission on the folder you're viewing from the data source from. This permission is in the Manage Models task; it is in the default Content Manager role.

Hope that helps,

-Lukasz

|||

Thanks Lukasz.

I'm not too sure what the exact problem was in the end but when I tried it again it worked.

yayomayn

Creating a MODEL

Is there any possibility to save a REPORT like a MODEL ? I mean for using the
same layout,fonts,etc..
--
TabacaruYes, you can save a report off to the side with basic layout and formatting
and use it as the starting point for creating additional reports.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Tabacaru Teodor" <TabacaruTeodor@.discussions.microsoft.com> wrote in
message news:4B494061-035C-4E75-9280-CE3E09E98D46@.microsoft.com...
> Is there any possibility to save a REPORT like a MODEL ? I mean for using
> the
> same layout,fonts,etc..
> --
> Tabacaru|||And you can add it to the VS template directory to add it to the 'add new
item' list. Several articles have been published which demonstate this.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:uYXEk4m%23EHA.3336@.TK2MSFTNGP11.phx.gbl...
> Yes, you can save a report off to the side with basic layout and
> formatting and use it as the starting point for creating additional
> reports.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Tabacaru Teodor" <TabacaruTeodor@.discussions.microsoft.com> wrote in
> message news:4B494061-035C-4E75-9280-CE3E09E98D46@.microsoft.com...
>> Is there any possibility to save a REPORT like a MODEL ? I mean for using
>> the
>> same layout,fonts,etc..
>> --
>> Tabacaru
>

Creating a dev database

Hi,

I have a test database running on the server. Now what I want to do is to create a dev db that has the exact same data model as the test one so that I can test out my application on the dev db and then migrate it to the test db. Can somebody tell me how I can achieve something like that.

Thanks...

Crazy:

The easiest way to do this is:

create a brandnew "dev" database with the name you wish to retain