Showing posts with label experienced. Show all posts
Showing posts with label experienced. Show all posts

Friday, March 30, 2012

page break after list not working

Has anyone experienced a problem with page breaks after list's?
I have a list and i have selected for a page break after list but it does
not appear to be working?
How can I force a page break for each row process from the dataset?Dave,
Not sure if this will help but I think when viewing as html, the page break
is not shown, but should work in pdf format or print preview.
cheers,
Batty.
"dave" wrote:
> Has anyone experienced a problem with page breaks after list's?
> I have a list and i have selected for a page break after list but it does
> not appear to be working?
> How can I force a page break for each row process from the dataset?|||I resolved my problem by ensuring that the width of my lists and subreports
were clearly smaller than the page i was trying to print on. When you have a
subreport for example that has a width wider than the page, very strange
things will happen.
Hope this helps.

Monday, March 26, 2012

Package with File System Task doesn't work without sensitive data with user keys

This problem is a bit weird but I'm just wondering if anybody else experienced this.

I have a package that has file system tasks (copying dtsx files actually). Basically the package copies other packages to a pre-defined destination. Thing is, it only works if one of the packages it is configured to copy has some sort of sensitive data (e.g., a connectionstring with a password), otherwise it reports a success message on execution but doesn't actually do anything. I've checked the forcedexecutionresult and it is set to None for that matter.

Just wondering if anybody else experienced this problem and of course if there's a way to solve it.

Thanks.Could the security permissions be different on your packages that are failing to be moved from those that are succeeding?|||No, they're all set to EncryptSensitiveWithUserKey.

However, all of the packages involved have their sensitive information set to obtaining them from Indirect Configuration Files. The only way around that I found so far was to put in a dummy connection object, set up an XML file package configuration for that dummy, and deploy it that way.

I'm suspecting that the user key isn't generated at all when all the packages get their configs from Indirect Configuration Files. For some reason, DontSaveSensitive doesn't work either. My original package insists on the presence of a key. Might have something to do with file read/write/modify permissions that come with the key?

I still want to do away with the dummy though.