Dynamic Page Header Height...

Group,
Does anyone know how to set the height of the Page Header dynamically, it's
not letting me set the Height property of the Page Header to an Expression
[something like = IIf(Globals!PageNumber = 1, 1.5in, 1in)?
Or is there any other way to achieve the following:
I want a certain page header on page 1 and then a different one (shorter in
height) to appear on all subsequent pages without the extra header
whitespace.
Thanks group.As far as I know report header is static - I think it is on the wish list for
the next release. [I saw a post on this from msft - search around & you will
see it]
"Terry Mulvany" wrote:
> Group,
> Does anyone know how to set the height of the Page Header dynamically, it's
> not letting me set the Height property of the Page Header to an Expression
> [something like = IIf(Globals!PageNumber = 1, 1.5in, 1in)?
> Or is there any other way to achieve the following:
> I want a certain page header on page 1 and then a different one (shorter in
> height) to appear on all subsequent pages without the extra header
> whitespace.
> Thanks group.
>
>

Dynamic Oledb Destination

Hello,

I am a beginner for the SSIS and would like to know how to modify the OLDEB Destination connectionString property at run time like using "for each loop container".

My requirement is that I have a single source which would be Sql Server 2005 and my destination is in MS-Access database residing in 100 places. I do not want to manually design in the data flow to these 100 destinations.

I have all the destinations stored in a table and would like to pick these destinations from the table and loop through the same at run time by modifying destination connection string.

I have planned using dts but the for each loop container does not work through as it works with flat file connection manager , but does not go well with OLDEB connection.

Highly appreciate any help in this regard.

Regards

Sameer

Sameer,

The OLE DB Destination does not have a connection string property however the OLE DB Connection Manager that it uses DOES. You can change this connection string so that you are pointing at (e.g.) a different server or a different .mdb file.

What you cannot do however is change the name of the table in the OLE DB Destination that you are inserting into. Well actually you can but the metadata (i.e. column names, types) of the table into which you are inserting must be the same as that selected at design-time.

If you are inserting into 100 identical MS Access databases then you can do this by modifying the connection string property of the OLE DB Connection Manager and looping using the For Each Loop container. If you want to insert to 100 different tables then you need 100 different data-flows.

-Jamie

|||

Jamie,

Thanks for the reply. Yes you are right it is the OLEDB Connection manger.

My requirement is that the these are 100 identical MS access tables which needs to be loaded with production data after every 1 hour. Would like to know the details of looping the For Each loop container using my Configuration table, which holds information about MDB file locations. How do I configure the For each loop container to point to the Configuration table. I have now started feeling that connection manager goes well only with the flat file and does not go well with OLEDB.

Can you provide me a small example which loops the files. Also these access files are spread across the network, and many time the network connectiion goes down, hence I have made an extra column in my table which updates that the data has reached/Unreached to final destination. How do i capture the same in SSIS. In old traditional way of DTS I remember I used to have privledge of doing the

Set oPkg = DTSGlobalVariables.Parent through which I could find out the execution result like this, which is oPkg.steps(i).ExecutionResult. How do I achieve the same in SSIS.

Again if you could provide me an hint or working example that would be great. I do have working example for flat file connection manager , but I am unable to replicate the same using OLEDB destination.

Thanks in advance for the suggestions

Regards

|||

Greetings Sameer,

I am working on a similar issue. have you found any resolutions for dymanic configuration of an oledb connection?

my task is smiliar. I plan to dymanically change (table drive) oledb connection "servernames" and query each of these servername, which will in turn write to a single datasource. I am stuck on the dynamic configuration of these oledb sources.

Any feedback you can provide would be greatly appreciated.

Thanks

|||

bowmandba wrote:

Greetings Sameer,

I am working on a similar issue. have you found any resolutions for dymanic configuration of an oledb connection?

my task is smiliar. I plan to dymanically change (table drive) oledb connection "servernames" and query each of these servername, which will in turn write to a single datasource. I am stuck on the dynamic configuration of these oledb sources.

Any feedback you can provide would be greatly appreciated.

Thanks

You need to use expressions.

SSIS>>Expressions

(http://blogs.conchango.com/jamiethomson/archive/tags/SSIS/Expressions/default.aspx)

Any questions, reply here.

-Jamie

Dynamic Oledb Destination

Hello,

I am a beginner for the SSIS and would like to know how to modify the OLDEB Destination connectionString property at run time like using "for each loop container".

My requirement is that I have a single source which would be Sql Server 2005 and my destination is in MS-Access database residing in 100 places. I do not want to manually design in the data flow to these 100 destinations.

I have all the destinations stored in a table and would like to pick these destinations from the table and loop through the same at run time by modifying destination connection string.

I have planned using dts but the for each loop container does not work through as it works with flat file connection manager , but does not go well with OLDEB connection.

Highly appreciate any help in this regard.

Regards

Sameer

Sameer,

The OLE DB Destination does not have a connection string property however the OLE DB Connection Manager that it uses DOES. You can change this connection string so that you are pointing at (e.g.) a different server or a different .mdb file.

What you cannot do however is change the name of the table in the OLE DB Destination that you are inserting into. Well actually you can but the metadata (i.e. column names, types) of the table into which you are inserting must be the same as that selected at design-time.

If you are inserting into 100 identical MS Access databases then you can do this by modifying the connection string property of the OLE DB Connection Manager and looping using the For Each Loop container. If you want to insert to 100 different tables then you need 100 different data-flows.

-Jamie

|||

Jamie,

Thanks for the reply. Yes you are right it is the OLEDB Connection manger.

My requirement is that the these are 100 identical MS access tables which needs to be loaded with production data after every 1 hour. Would like to know the details of looping the For Each loop container using my Configuration table, which holds information about MDB file locations. How do I configure the For each loop container to point to the Configuration table. I have now started feeling that connection manager goes well only with the flat file and does not go well with OLEDB.

Can you provide me a small example which loops the files. Also these access files are spread across the network, and many time the network connectiion goes down, hence I have made an extra column in my table which updates that the data has reached/Unreached to final destination. How do i capture the same in SSIS. In old traditional way of DTS I remember I used to have privledge of doing the

Set oPkg = DTSGlobalVariables.Parent through which I could find out the execution result like this, which is oPkg.steps(i).ExecutionResult. How do I achieve the same in SSIS.

Again if you could provide me an hint or working example that would be great. I do have working example for flat file connection manager , but I am unable to replicate the same using OLEDB destination.

Thanks in advance for the suggestions

Regards

|||

Greetings Sameer,

I am working on a similar issue. have you found any resolutions for dymanic configuration of an oledb connection?

my task is smiliar. I plan to dymanically change (table drive) oledb connection "servernames" and query each of these servername, which will in turn write to a single datasource. I am stuck on the dynamic configuration of these oledb sources.

Any feedback you can provide would be greatly appreciated.

Thanks

|||

bowmandba wrote:

Greetings Sameer,

I am working on a similar issue. have you found any resolutions for dymanic configuration of an oledb connection?

my task is smiliar. I plan to dymanically change (table drive) oledb connection "servernames" and query each of these servername, which will in turn write to a single datasource. I am stuck on the dynamic configuration of these oledb sources.

Any feedback you can provide would be greatly appreciated.

Thanks

You need to use expressions.

SSIS>>Expressions

(http://blogs.conchango.com/jamiethomson/archive/tags/SSIS/Expressions/default.aspx)

Any questions, reply here.

-Jamie

Dynamic Filter, Group, and Sort Report Builder Template

I have prepared a report by using report builder. And I want that user can
change filter, group, and sort property of this report template when running
report. How can it possible?I am also looking for similar funcationality in 2005 Reporting Services...Any
help is greatly appreciated!!
-Brian
"Yuksel" wrote:
> I have prepared a report by using report builder. And I want that user can
> change filter, group, and sort property of this report template when running
> report. How can it possible?

Dynamic embedded image...

Hey all,

I am trying to add an image object to a report that has its value property set dynamically and am not being very successful. I have two images embedded in the report called greyFlag and orangeFlag. When I try to add the condition:
...
=IIf(Fields!DateFilled.Value >= DateTime.Now.AddMonths(-12), "orangeFlag", "greyFlag")
...
I get the error:
...
The value of the value property for the image ‘image2’ is "greyFlag", which is not a valid value.

...

What am I doing wrong here?

Regards,

Stephen.

You need to put the code in the visible expression field.

in the Hidden for Greyflag field add the expression

=IIf(Fields!DateFilled.Value >= DateTime.Now.AddMonths(-12), true, false)

ANd do the opposite for the orangeFlag

=IIf(Fields!DateFilled.Value >= DateTime.Now.AddMonths(-12), false,true)

|||

OK. I was hoping to use just one image and replace its source, but I've used your technique by overlaying two images.

Thanks for the help!

Regards,

Stephen.

Dynamic columns

I am setting visible property for column based on user input. This works
fine. However, I need to be able to change the width to 0 for the column as
well so the report will not print blank pages. A matrix is NOT an option.
Report is too complicated. Unfortunately there is no expression option for
the column width. Is there any way of setting this to 0 or autosize' Also
need to adjust the body width dynamically.On May 29, 3:32 pm, Sherminator
<Shermina...@.discussions.microsoft.com> wrote:
> I am setting visible property for column based on user input. This works
> fine. However, I need to be able to change the width to 0 for the column as
> well so the report will not print blank pages. A matrix is NOT an option.
> Report is too complicated. Unfortunately there is no expression option for
> the column width. Is there any way of setting this to 0 or autosize' Also
> need to adjust the body width dynamically.
Unfortunately, there are not very many options available if a matrix
control is not an option. You could try putting the table control(s)
in a rectangle. Also, you could try to rearrange the columns according
to the ones most likely to be invisible. Sorry that I could not be of
greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||It's not a matter of the columns not showing, so the order doesn't matter.
They do hide, however blank pages print because the body is over 18 inches
when all columns are populated. Unfortunately, the tablecolumn element is not
available thru the ReportItems collections. If it were I could reset the
width of the empty columns to 0 using a function and adjust the body width if
it too were available thru the ReportItems collection, however, those
elements are not available to my knowledge.
"EMartinez" wrote:
> On May 29, 3:32 pm, Sherminator
> <Shermina...@.discussions.microsoft.com> wrote:
> > I am setting visible property for column based on user input. This works
> > fine. However, I need to be able to change the width to 0 for the column as
> > well so the report will not print blank pages. A matrix is NOT an option.
> > Report is too complicated. Unfortunately there is no expression option for
> > the column width. Is there any way of setting this to 0 or autosize' Also
> > need to adjust the body width dynamically.
>
> Unfortunately, there are not very many options available if a matrix
> control is not an option. You could try putting the table control(s)
> in a rectangle. Also, you could try to rearrange the columns according
> to the ones most likely to be invisible. Sorry that I could not be of
> greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>