Merge and Join

Hi I am a newbie into the world of Microsoft SQL Server Integration Services 2005. I am trying to merge 2 tables using a specified join like equi-join and also having a complex set of critriea. And I know if I use the merge/merge join transformation it can't be done so how to go about doing that other than using the "Execute SQL Task" which doesn't help me in my next "Data Flow task" as an input. As i need the data derive from the complex sql as an input to other transformations.Hi Ken Hu

could you be a bit more specific about what you are trying to achieve ? (eg: by giving us some pseudo-code ?).

This way more people will be able to give you bits of answers.

cheers

Thibaut

Merge a PDF File and SQL Reporting Services Output

Does anyone know how i can go about merging preexisting pdf files and SQL server reporting services output. Can this be done in reporting services? For example, I have 5 pages from a pdf files which is created from another 3rd party software provider. I then i have output from sql reporting services. How can i merge these two outputs and deliver it over .Net/ ASP framework?

thanks

You could print the pdf to an image writer and use the images as background images in your Reporting Services report.

Or if the Reporting Services output is mainly data you could look at using the output data as input into you thrid party application (or vise versa).

hth

-- Leah

|||

I've tried what Leah suggested and the creation of the gif file was identical to the pdf (same width and height). However, when I used it as a background in the VS2005 report designer, the image became larger. How do you maintain the same dimensions of the original image when it is used as a background image?

Thanks

|||I came across a post from a different forum that was the closest to solving this issue. The solution was to scan a document at 96dpi prior to using it as the background. It wasn't perfect but it got me into the ball park where I could adjust positioning of the controls on a case by case basis.

Merge a PDF File and SQL Reporting Services Output

Does anyone know how i can go about merging preexisting pdf files and SQL server reporting services output. Can this be done in reporting services? For example, I have 5 pages from a pdf files which is created from another 3rd party software provider. I then i have output from sql reporting services. How can i merge these two outputs and deliver it over .Net/ ASP framework?

thanks

You could print the pdf to an image writer and use the images as background images in your Reporting Services report.

Or if the Reporting Services output is mainly data you could look at using the output data as input into you thrid party application (or vise versa).

hth

-- Leah

|||

I've tried what Leah suggested and the creation of the gif file was identical to the pdf (same width and height). However, when I used it as a background in the VS2005 report designer, the image became larger. How do you maintain the same dimensions of the original image when it is used as a background image?

Thanks

|||I came across a post from a different forum that was the closest to solving this issue. The solution was to scan a document at 96dpi prior to using it as the background. It wasn't perfect but it got me into the ball park where I could adjust positioning of the controls on a case by case basis.

Merge - Pull Snapshot Error

I'm struggling with this error with one of my subscribers. Both the
publisher and subscriber have the services running under the same account &
password. My subscribers use a dial-up connection. To help
troubleshoot, I had the subscriber get connected to the publisher via RAS
and had them run a directory listing on the snapshot location. They
received an error: Logon failure: unknown user name or bad password.
The RAS user account has full access to the snapshot location. This is the
first subscriber out of 15 that I'm experiencing this problem with. The
difference between this one and the other 14 is that this subscriber is
running a full version of SQL Server where as the rest are running MSDE.
The process could not deliver the snapshot to the Subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
The process could not bulk copy into table '"dbo"."sysmergesubsetfilters"'.
(Source: cookieland (Agent); Error number: 20037)
Unable to open BCP host data-file
(Source: ODBC SQL Server Driver (ODBC); Error number: 0)
This is not a replication problem. It is a problem relating to network connectivity or RAS.
Unfortunately my NT/RAS/dialup skills aren't good enough to help you. I suggest you open a ticket with PSS for Win2k networking, or post this question in one of the networking newsgroups.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Tina Smith" wrote:

> I'm struggling with this error with one of my subscribers. Both the
> publisher and subscriber have the services running under the same account &
> password. My subscribers use a dial-up connection. To help
> troubleshoot, I had the subscriber get connected to the publisher via RAS
> and had them run a directory listing on the snapshot location. They
> received an error: Logon failure: unknown user name or bad password.
> The RAS user account has full access to the snapshot location. This is the
> first subscriber out of 15 that I'm experiencing this problem with. The
> difference between this one and the other 14 is that this subscriber is
> running a full version of SQL Server where as the rest are running MSDE.
> The process could not deliver the snapshot to the Subscriber.
> (Source: Merge Replication Provider (Agent); Error number: -2147201001)
> ----
> The process could not bulk copy into table '"dbo"."sysmergesubsetfilters"'.
> (Source: cookieland (Agent); Error number: 20037)
> ----
> Unable to open BCP host data-file
> (Source: ODBC SQL Server Driver (ODBC); Error number: 0)
>
>
|||Thanks Hilary. I have since learned the credentials are cached in XP and
used when you try to access any
resources in the remote network. The same feature is not present pre XP.
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:8BE474D2-F7A1-414E-9B35-5DD6239B8833@.microsoft.com...
> This is not a replication problem. It is a problem relating to network
connectivity or RAS.
> Unfortunately my NT/RAS/dialup skills aren't good enough to help you. I
suggest you open a ticket with PSS for Win2k networking, or post this
question in one of the networking newsgroups.[vbcol=seagreen]
> --
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
>
> "Tina Smith" wrote:
account &[vbcol=seagreen]
RAS[vbcol=seagreen]
the[vbcol=seagreen]
The
> ----
--[vbcol=seagreen]
'"dbo"."sysmergesubsetfilters"'.
> ----
--[vbcol=seagreen]

Memory Usage

Is there a way to configure the amount of memory that reporting
services uses? and if so can someone point me in the right direction in
regards to the documentation... I apperciate your assistance.
-WHi Wayne,
See the file RSReportServer.config, this file is located in the \Reporting
Services\ReportServer folder. There is a section of Memory Limit. See also
the article "RSReportServer Configuration File" in Reporting Services Books
Online.
Regards,
Armand
<wayne.small@.mbna.com> escreveu na mensagem
news:1130421493.518665.293030@.g14g2000cwa.googlegroups.com...
> Is there a way to configure the amount of memory that reporting
> services uses? and if so can someone point me in the right direction in
> regards to the documentation... I apperciate your assistance.
> -W
>

Memory usage

I have a SQL server with 3.5GB memory. SQL is aquiring about 2.1GB and the OS and other services a few hundred MB. The server is showing over 880MB available bytes. ie not used for anything and yet Windows 2000 is paging like a mad. We are running SQL 2000 Ent edition and Windows 2000 Advanced Server. Server performance appears to be impeded by a disk bottleneck. Has anyone seen this behaviour before? Why isn't Windows/SQL taking all the memory?Jonathan:
I have seen this occur before and is probably due to the
fact that windows limits each process to 2gb of memory
unless you set the AWE flag that allows a process to use
more through the virtualization of memory addresses
greater than 2gb. Also, you may want to look into
setting your paging file at a fixed size or 4gb or larger
rather than setting a lower and then an upper limit for
the page file. Finally, you will need to check the
performance monitor on the server and see what kind of
cache hit ratio you are getting, it may be that sql does
not need any more memory then what it is currently using.
>--Original Message--
>I have a SQL server with 3.5GB memory. SQL is aquiring
about 2.1GB and the OS and other services a few hundred
MB. The server is showing over 880MB available bytes. ie
not used for anything and yet Windows 2000 is paging like
a mad. We are running SQL 2000 Ent edition and Windows
2000 Advanced Server. Server performance appears to be
impeded by a disk bottleneck. Has anyone seen this
behaviour before? Why isn't Windows/SQL taking all the
memory?
>.
>|||> I have seen this occur before and is probably due to the
> fact that windows limits each process to 2gb of memory
> unless you set the AWE flag that allows a process to use
> more through the virtualization of memory addresses
> greater than 2gb.
Not entirely true. AWE is needed on 32-bit Windows platforms in order to
address over *3GB*. Without AWE, a Windows application like SQL Server can
still use up to 3GB if the OS edition supports it and the server is
configured to use it. The /3GB boot.ini switch is needed under Windows 2000
AS in order for applications to address up to 3GB without AWE.
For more information, see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&Product=sql
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Z" <anonymous@.discussions.microsoft.com> wrote in message
news:0b7d01c3b9a3$c97dd2a0$a301280a@.phx.gbl...
> Jonathan:
> I have seen this occur before and is probably due to the
> fact that windows limits each process to 2gb of memory
> unless you set the AWE flag that allows a process to use
> more through the virtualization of memory addresses
> greater than 2gb. Also, you may want to look into
> setting your paging file at a fixed size or 4gb or larger
> rather than setting a lower and then an upper limit for
> the page file. Finally, you will need to check the
> performance monitor on the server and see what kind of
> cache hit ratio you are getting, it may be that sql does
> not need any more memory then what it is currently using.
> >--Original Message--
> >I have a SQL server with 3.5GB memory. SQL is aquiring
> about 2.1GB and the OS and other services a few hundred
> MB. The server is showing over 880MB available bytes. ie
> not used for anything and yet Windows 2000 is paging like
> a mad. We are running SQL 2000 Ent edition and Windows
> 2000 Advanced Server. Server performance appears to be
> impeded by a disk bottleneck. Has anyone seen this
> behaviour before? Why isn't Windows/SQL taking all the
> memory?
> >.
> >