page break

Hi,
I have a report with multiple pages.
I added a page break but then went to the table properties and unchecked the
page break checkbox.
However, when i run the report from my vb.net application I can see a page
break at the end of each page. How can I delete the page breaks?
Thanks.You can get page breaks from groups, lists, etc... Either search through
the RDL or check each one of the items to ensure your not asking for page
breaks somewhere else...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"collie" <collie@.discussions.microsoft.com> wrote in message
news:ABEEBB6A-A408-48C0-A528-F881D5815A65@.microsoft.com...
> Hi,
> I have a report with multiple pages.
> I added a page break but then went to the table properties and unchecked
the
> page break checkbox.
> However, when i run the report from my vb.net application I can see a page
> break at the end of each page. How can I delete the page breaks?
> Thanks.

page break

I have a matrix and I want to insert a page break on a column group. I dont
see the option under grouping and sorting properties for my column groups
only on the rows?On Nov 2, 10:39 am, RYF <R...@.discussions.microsoft.com> wrote:
> I have a matrix and I want to insert a page break on a column group. I dont
> see the option under grouping and sorting properties for my column groups
> only on the rows?
Unfortunately, this functionality does not exist currently. A
workaround would be to create 2 matrices/matrix controls in the report
and have the columns you want on the odd pages in the first matrix
control (and do a page break after it) and the columns you want on the
even pages in the second matrix control (and do a page break after it
as well). Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Pad Spaces in FFConnection properties?

This is a considerably LOW priority, but is there a way to padd spaces in ssis flat file connection properties? We have cases where a CSV file will read in and throw a truncation error because the field length is greater then defined. However, the CSV file might look like ,"ABC ", where a number of trailing spaces are found. Is there some way to handle this without having to adjust teh field length, maybe ignore whitespace at the source?There is no way at the Flat File Source to ignore trailing whitespace, however there is a work around. Say in this case your field length is 3, and if there are trailing spaces after that, you want to ignore them. You can then use "Ignore Failure" for Truncation Error Disposition. That is, in the Error Output tab for the Flat File Source, for Truncation of this column, choose "Ignore Failure", instead of "Fail Component". By doing this, it will only get the specified characters, and ignore the rest, whether they are trailing white spaces, or some other data there. You have to make sure that this is not causing you to accept some data which you otherwise wanted to fail on really.|||

That is partially the problem, we only want to ignore whitespaces, but if there is actual chars then we would want to throw truncation error.

Thanks for your thoughts...

Package variables "disappear" from job properties

Creating a SQL Agent job to run a package works just fine. On the Step Properties, Set values tab, I can add variables and the values I want for them, no problem. The job runs just fine. If I want to go edit the values however, they're always gone.

Is there some security setting that hides the variables and their values which is on by default?

GregsListAcct wrote:

Creating a SQL Agent job to run a package works just fine. On the Step Properties, Set values tab, I can add variables and the values I want for them, no problem. The job runs just fine. If I want to go edit the values however, they're always gone.

Is there some security setting that hides the variables and their values which is on by default?

Greg,

I don't know the answer to this but regardless, you should stop using the SSIS sub-system and just call teh package usinng the command-line sub-system instead.

There is an article at wiki.sqlis.com that explains the rationale behind this but the site is down so i can't link to it. Basically you don't get any diagnostic info out of the SSIS sub-system.

-Jamie

Package Configuration - XML

Type:
Configuration File

New configuration file will be created.

File name:
C:\Test.dtsconfig

Properties:
\Package.Connections[Flat File Connection Manager].Properties[ConnectionString]

So lets say, I modify the connectionstring for the Flat File connection manager by editing the xml file. Next time, I run the package, it does not grab the new value. Am I misunderstanding the concept of Package Configuration?

No, you're not misunderstanding. This should be working. if the package uses a configuration file then messages will be output to the Output window indicating this. My best guess is tat something is configured incorrectly.

Also, are you using checkpoint files? If so, make sure that no checkpoint file is present to make sure that the package starts from scratch.

-Jamie

|||

Well what I did to get it working was the following:

On my config file i'm putting the values of variables, and i mapped the expressions to the variables. Thus, when I edit the xml file, I can change the value of lets say username to Bob and in return since i have it mapped, it automatically takes that value and applies it according to the connection.

|||The thing that usually gets me with configuration files is case sensitivity. A Source connection is not the same as a source connection. So if you have SuppressConfigurationWarnings attribute in your package set to True, the configuration file property is not used and you're not even aware you have a problem. If I had a dollar for every time...

Package Configuration

Hi All,

I have couple of properties in my package Configuration

(1) Lets me know the Folder path - where I have file processing

(2) Connection String

When working in the Development machine, I am able to play around these values and test the application. I have tried both XML Configuration and SQL Server Configuration

But during deployment in the Test Server, the values in the Configuration are not getting reflected automatically and takes the values assigned during deployment

I tried importing the XML file and it works. But the values are not persistant.After running the package, the value gets resetted to the old value. Every time I run my package, I am reassingning my package variables.

Be it XML Configuration File or SQL Server, I would like to have the variables pulled out from the Configuration I am setting during the deployment. the values should be persistant and should refer the updated values.

Any help will be highly appreciated...thanks

When you move to the test server, do you:
- copy the configuration file to the server
- ensure that SSIS knows to look for the file in the correct place on the new server
- have the configuration file listed in the Package Configurations list? (Right-click Control flow background, select Package Configurations)|||

Phil, Thanks for sharing your thought.

I have configured the XML Package Configuration File during my development and placed the file along with my SSIS Packages in the same folder. But my IS is not picking up the Configuraiton file in my test Environment (new Server.

Any suggestions on how to solve this issue.

Thanks

Evan

|||

Web Explorer wrote:

Phil, Thanks for sharing your thought.

I have configured the XML Package Configuration File during my development and placed the file along with my SSIS Packages in the same folder. But my IS is not picking up the Configuraiton file in my test Environment (new Server.

Any suggestions on how to solve this issue.

Thanks

Evan

Pretty much I have nothing more to add other than the list of things to check above. Is the directory path to the config file exactly the same on the test server compared to the dev server?|||When you open the package on the test server, do you get any warnings? (CTRL-E to open that window if it isn't already)|||

no....I purposely wanted to have the folder structure different in Dev and test Server, because during the actual deployment, we should have the flexibility to change the folder structure accoding to the environment.

I am sure If the directory matches IS is going to pick our files. But I want my setting in the XML Config file to be referred in the test server

Thanks

Evan

|||I dont get any warnings Error. When the package runs, it says that the for each container is empty as its trying to refer a different folder|||

Web Explorer wrote:

no....I purposely wanted to have the folder structure different in Dev and test Server, because during the actual deployment, we should have the flexibility to change the folder structure accoding to the environment.

I am sure If the directory matches IS is going to pick our files. But I want my setting in the XML Config file to be referred in the test server

Thanks

Evan

Right, but you have to understand that SSIS needs to know where to look for the XML configuration file. The path specified cannot change, UNLESS you use an environment variable to define the path to the XML configuration file.|||There are obviously two things going on here.

1 - Can SSIS find the XML configuration file
2 - When it does find the configuration file, is it picking up the values contained within

Assuming SSIS picks up the configuration file in DEV and sets the value accordingly, then it should work in TEST provided it can find the configuration file.|||

Thanks a lot for your useful thoughts.

Finally got this working.

Configured a XML Configuration File and Also configured an Environment Variable.

After deploying the XML configuration file in the test server and configuring the Environment variable, a re-boot is necessary.

I found that after restarting the machine, the test server started to work perfectly.

Thanks a ton for your timely help.

Regards,

Evan

|||Check out this thread of similar problems, for an explanation, perhaps of what was going on with your issue. Specifically my last post.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1347857&SiteID=1

Package Configuration

Hi All,

I have couple of properties in my package Configuration

(1) Lets me know the Folder path - where I have file processing

(2) Connection String

When working in the Development machine, I am able to play around these values and test the application. I have tried both XML Configuration and SQL Server Configuration

But during deployment in the Test Server, the values in the Configuration are not getting reflected automatically and takes the values assigned during deployment

I tried importing the XML file and it works. But the values are not persistant.After running the package, the value gets resetted to the old value. Every time I run my package, I am reassingning my package variables.

Be it XML Configuration File or SQL Server, I would like to have the variables pulled out from the Configuration I am setting during the deployment. the values should be persistant and should refer the updated values.

Any help will be highly appreciated...thanks

When you move to the test server, do you:
- copy the configuration file to the server
- ensure that SSIS knows to look for the file in the correct place on the new server
- have the configuration file listed in the Package Configurations list? (Right-click Control flow background, select Package Configurations)|||

Phil, Thanks for sharing your thought.

I have configured the XML Package Configuration File during my development and placed the file along with my SSIS Packages in the same folder. But my IS is not picking up the Configuraiton file in my test Environment (new Server.

Any suggestions on how to solve this issue.

Thanks

Evan

|||

Web Explorer wrote:

Phil, Thanks for sharing your thought.

I have configured the XML Package Configuration File during my development and placed the file along with my SSIS Packages in the same folder. But my IS is not picking up the Configuraiton file in my test Environment (new Server.

Any suggestions on how to solve this issue.

Thanks

Evan

Pretty much I have nothing more to add other than the list of things to check above. Is the directory path to the config file exactly the same on the test server compared to the dev server?|||When you open the package on the test server, do you get any warnings? (CTRL-E to open that window if it isn't already)|||

no....I purposely wanted to have the folder structure different in Dev and test Server, because during the actual deployment, we should have the flexibility to change the folder structure accoding to the environment.

I am sure If the directory matches IS is going to pick our files. But I want my setting in the XML Config file to be referred in the test server

Thanks

Evan

|||I dont get any warnings Error. When the package runs, it says that the for each container is empty as its trying to refer a different folder|||

Web Explorer wrote:

no....I purposely wanted to have the folder structure different in Dev and test Server, because during the actual deployment, we should have the flexibility to change the folder structure accoding to the environment.

I am sure If the directory matches IS is going to pick our files. But I want my setting in the XML Config file to be referred in the test server

Thanks

Evan

Right, but you have to understand that SSIS needs to know where to look for the XML configuration file. The path specified cannot change, UNLESS you use an environment variable to define the path to the XML configuration file.|||There are obviously two things going on here.

1 - Can SSIS find the XML configuration file
2 - When it does find the configuration file, is it picking up the values contained within

Assuming SSIS picks up the configuration file in DEV and sets the value accordingly, then it should work in TEST provided it can find the configuration file.|||

Thanks a lot for your useful thoughts.

Finally got this working.

Configured a XML Configuration File and Also configured an Environment Variable.

After deploying the XML configuration file in the test server and configuring the Environment variable, a re-boot is necessary.

I found that after restarting the machine, the test server started to work perfectly.

Thanks a ton for your timely help.

Regards,

Evan

|||Check out this thread of similar problems, for an explanation, perhaps of what was going on with your issue. Specifically my last post.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1347857&SiteID=1

Owner missing in Cluster

When I look at properties for FT in cluster administrator the only owner I
see is the node1 owner. Why doesn't owner node2 show up as a selection?
I'm thinking about doing the following below from a MS KB article to fix my
problem, any ideas?
You can reinstall the Full Text resource by manually running Ftsetup.exe.
However, before you can manually run Ftsetup.exe, you must perform the
following cleanup steps.
Note You must perform these cleanup steps on all nodes in the cluster group.
1. Delete the NewInstanceName subkey under the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\G athering
Manager\Applications
2. Delete the NewInstanceName subkey under the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\A pplications
3. Locate the shared data directory of the new clustered instance, and then
delete everything under the FTData folder.
Note Typically, the FTData folder includes some .0 files, some .1 files, and
a SQLServer$NewInstanceName folder.
After you have completed the cleanup steps, you can reinstall the Full Text
resource.
Note Make sure that you only run Ftsetup.exe from the node from which you
originally ran the SQL Server Setup program. Also, make sure that the node
has control of the shared drive.
To manually run Ftsetup.exe, you can use the following command-line
command:
"Path of the new clustered instance Bin folder\ftsetup.exe"
SQLServer$InstanceName SQL Server Account 1 0 1 0
Note InstanceName is the name of the new clustered instance of SQL Server.
SQL Server Account is the account under which SQL Server runs.
This account must have local administrator permissions on the node from
which you run Ftsetup.exe.
Tim,
Before you attempt re-installing the FT Search resource via the steps in KB
article 899580 "Full Text resource fails when you install a new clustered
instance after you apply SQL2K SP3 to an existing clustered instance" at
http://support.microsoft.com/default...;en-us;899580, what do you
see when you failover to the 2nd node (node2)?
As I don't have a clustered server at home <G>, you may want to call in to
PSS Microsoft SQL Server support and open a support case, as cluster issues
can be troublesome...
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Tim" <tim@.nospam.com> wrote in message
news:iTP7f.15378$B73.6907@.news.cpqcorp.net...
> When I look at properties for FT in cluster administrator the only owner I
> see is the node1 owner. Why doesn't owner node2 show up as a selection?
> I'm thinking about doing the following below from a MS KB article to fix
> my
> problem, any ideas?
> ----
> --
> You can reinstall the Full Text resource by manually running Ftsetup.exe.
> However, before you can manually run Ftsetup.exe, you must perform the
> following cleanup steps.
> Note You must perform these cleanup steps on all nodes in the cluster
> group.
> 1. Delete the NewInstanceName subkey under the following registry key:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\G athering
> Manager\Applications
> 2. Delete the NewInstanceName subkey under the following registry key:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\A pplications
> 3. Locate the shared data directory of the new clustered instance, and
> then
> delete everything under the FTData folder.
> Note Typically, the FTData folder includes some .0 files, some .1 files,
> and
> a SQLServer$NewInstanceName folder.
> After you have completed the cleanup steps, you can reinstall the Full
> Text
> resource.
> Note Make sure that you only run Ftsetup.exe from the node from which you
> originally ran the SQL Server Setup program. Also, make sure that the node
> has control of the shared drive.
> To manually run Ftsetup.exe, you can use the following command-line
> command:
> "Path of the new clustered instance Bin folder\ftsetup.exe"
> SQLServer$InstanceName SQL Server Account 1 0 1 0
> Note InstanceName is the name of the new clustered instance of SQL Server.
> SQL Server Account is the account under which SQL Server runs.
> This account must have local administrator permissions on the node from
> which you run Ftsetup.exe.
>
|||What happens when you failover to the other node? The owner name should
change? Is this a multi-instance cluster?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tim" <tim@.nospam.com> wrote in message
news:iTP7f.15378$B73.6907@.news.cpqcorp.net...
> When I look at properties for FT in cluster administrator the only owner I
> see is the node1 owner. Why doesn't owner node2 show up as a selection?
> I'm thinking about doing the following below from a MS KB article to fix
my
> problem, any ideas?
> ----
--
> --
> You can reinstall the Full Text resource by manually running Ftsetup.exe.
> However, before you can manually run Ftsetup.exe, you must perform the
> following cleanup steps.
> Note You must perform these cleanup steps on all nodes in the cluster
group.
> 1. Delete the NewInstanceName subkey under the following registry key:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\G athering
> Manager\Applications
> 2. Delete the NewInstanceName subkey under the following registry key:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\A pplications
> 3. Locate the shared data directory of the new clustered instance, and
then
> delete everything under the FTData folder.
> Note Typically, the FTData folder includes some .0 files, some .1 files,
and
> a SQLServer$NewInstanceName folder.
> After you have completed the cleanup steps, you can reinstall the Full
Text
> resource.
> Note Make sure that you only run Ftsetup.exe from the node from which you
> originally ran the SQL Server Setup program. Also, make sure that the node
> has control of the shared drive.
> To manually run Ftsetup.exe, you can use the following command-line
> command:
> "Path of the new clustered instance Bin folder\ftsetup.exe"
> SQLServer$InstanceName SQL Server Account 1 0 1 0
> Note InstanceName is the name of the new clustered instance of SQL Server.
> SQL Server Account is the account under which SQL Server runs.
> This account must have local administrator permissions on the node from
> which you run Ftsetup.exe.
>
|||Since FTS only has owner of node1 it will not failover to node2, error
message is 'An error occured when attempting to move the SQL Group Group. A
node is not availible for this resource'
"John Kane" <jt-kane@.comcast.net> wrote in message
news:%2328%23C7p2FHA.3300@.TK2MSFTNGP15.phx.gbl...
> Tim,
> Before you attempt re-installing the FT Search resource via the steps in
KB
> article 899580 "Full Text resource fails when you install a new clustered
> instance after you apply SQL2K SP3 to an existing clustered instance" at
> http://support.microsoft.com/default...;en-us;899580, what do
you
> see when you failover to the 2nd node (node2)?
> As I don't have a clustered server at home <G>, you may want to call in to
> PSS Microsoft SQL Server support and open a support case, as cluster
issues[vbcol=seagreen]
> can be troublesome...
> Regards,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Tim" <tim@.nospam.com> wrote in message
> news:iTP7f.15378$B73.6907@.news.cpqcorp.net...
I
> ----
--[vbcol=seagreen]
Ftsetup.exe.[vbcol=seagreen]
you[vbcol=seagreen]
node[vbcol=seagreen]
Server.
>
|||Sounds like SQL FTS is not installed correctly on the second node. Evict the
second node, remove SQL from this node, and then reinstall it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tim" <tim@.nospam.com> wrote in message
news:3K68f.15428$zO3.12361@.news.cpqcorp.net...
> Since FTS only has owner of node1 it will not failover to node2, error
> message is 'An error occured when attempting to move the SQL Group Group.
A[vbcol=seagreen]
> node is not availible for this resource'
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:%2328%23C7p2FHA.3300@.TK2MSFTNGP15.phx.gbl...
> KB
clustered[vbcol=seagreen]
> you
to[vbcol=seagreen]
> issues
owner[vbcol=seagreen]
> I
selection?[vbcol=seagreen]
fix[vbcol=seagreen]
> ----
> --
> Ftsetup.exe.
files,[vbcol=seagreen]
> you
> node
> Server.
from
>
|||Tim,
What errors (if any) are reported in the Cluster log? Additionally, review
the server's application event log for both "Microsoft Search" and MssCi
source events (warnings and errors), and let me know if you have any errors
with the following text: "80070002 - The system cannot find the file
specified".
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Tim" <tim@.nospam.com> wrote in message
news:3K68f.15428$zO3.12361@.news.cpqcorp.net...
> Since FTS only has owner of node1 it will not failover to node2, error
> message is 'An error occured when attempting to move the SQL Group Group.
> A
> node is not availible for this resource'
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:%2328%23C7p2FHA.3300@.TK2MSFTNGP15.phx.gbl...
> KB
> you
> issues
> I
> --
> Ftsetup.exe.
> you
> node
> Server.
>
|||By evicting the 2nd node and uninstalling/reinstalling sql then rejoining
will it break anything? We also have IIS clustered, MSDTC, etc... Is there
a good web site we can refer to, step-by-step instructions for the above
method?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eLded312FHA.3188@.TK2MSFTNGP12.phx.gbl...
> Sounds like SQL FTS is not installed correctly on the second node. Evict
the[vbcol=seagreen]
> second node, remove SQL from this node, and then reinstall it.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Tim" <tim@.nospam.com> wrote in message
> news:3K68f.15428$zO3.12361@.news.cpqcorp.net...
Group.[vbcol=seagreen]
> A
in[vbcol=seagreen]
> clustered
at[vbcol=seagreen]
do[vbcol=seagreen]
in[vbcol=seagreen]
> to
> owner
> selection?
> fix
> ----
the[vbcol=seagreen]
cluster[vbcol=seagreen]
key:[vbcol=seagreen]
key:[vbcol=seagreen]
and[vbcol=seagreen]
> files,
Full[vbcol=seagreen]
which[vbcol=seagreen]
the
> from
>
|||It appears as if your second node is hosed - or the fts part of it is. By
following the sequence I recommended it should rejoin file. I suggest
however that you post to the clustering newsgroup for clarification on what
the best way to proceed is.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tim" <tim@.nospam.com> wrote in message
news:jrx8f.15582$iF4.7525@.news.cpqcorp.net...
> By evicting the 2nd node and uninstalling/reinstalling sql then rejoining
> will it break anything? We also have IIS clustered, MSDTC, etc... Is
there[vbcol=seagreen]
> a good web site we can refer to, step-by-step instructions for the above
> method?
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:eLded312FHA.3188@.TK2MSFTNGP12.phx.gbl...
> the
> Group.
steps[vbcol=seagreen]
> in
instance"[vbcol=seagreen]
> at
[vbcol=seagreen]
> do
> in
to[vbcol=seagreen]
> ----
> the
> cluster
> key:
> key:
> and
> Full
> which
> the
command-line
>

Overwriting text control

Hello,
Is it possible to overwrite a text control in reporting services, so
that I can add two additional properties to it? If possible, do you
have any links/point to resources?
Thanks
/Peterdo you talk about a parameter related textbox?
yes you can... if you develop your own report access interface or if you use
the reportviewer control.
directly in reportserver, you can't
from where you want to add properties in the textbox?
do you want to open a report with some parameters predefined and send in the
URL?
"Peter" <ptrlsn@.gmail.com> wrote in message
news:1178650584.307210.221870@.p77g2000hsh.googlegroups.com...
> Hello,
> Is it possible to overwrite a text control in reporting services, so
> that I can add two additional properties to it? If possible, do you
> have any links/point to resources?
>
> Thanks
> /Peter
>|||On 9 Maj, 04:44, "Jeje" <willg...@.hotmail.com> wrote:
> do you talk about a parameter related textbox?
> yes you can... if you develop your own report access interface or if you use
> the reportviewer control.
> directly in reportserver, you can't
> from where you want to add properties in the textbox?
> do you want to open a report with some parameters predefined and send in the
> URL?
Thanks for the reply
The text in the text box should be retrieved from an external
application based on a property-value that it will pass to said
external application. It will connect to the external app through a
COM connector.
Is this possible programmatically? For example by overwriting the text
control and give it one or two extra properties?
/Peter