There is no support in SSIS for creating PDFs.

However, if you can work out how to create PDFs using .NET assemblies, you may be able to do this by using...

Stored procedure OUTER_TEST calls stored procedure INNER_TEST.

If an error in INNER_TEST, how do I capture the error message (to store in a table). When I have a try-catch...

• This reply was modified 3 years, 3 months ago by Phil Parkin.

Something like this, I think:

DECLARE
    @Route   VARCHAR(50)
,   @USRoute VARCHAR(50);

SELECT
    @Route = 'x'
,   @USRoute = '';

SELECT...

That's useful functionality, for sure. I think you should have mentioned somewhere that this is third-party software available at a price, not something which comes with the product.

OK, that's an example of the source data. Based on that, what do you want to see? I do not see any 'subgroups' in this example.

We have to insert the records for each student key based on type and sub type. but in select we have to use id as with type HOLL and...

Does this utility also transfer environment references and variable mappings?

The content of SSIS packages is encrypted during deployment, so you can't retrieve that. But you can query catalog.packages to see which packages have been deployed. What are you trying...

How about you...

Can you post the XML and your desired results?

Another maybe:

DECLARE @RunDateYr INT;

--SET @RunDateYr = YEAR(GETDATE()) * 100;
--SET @RunDateYr = YEAR('20221010') * 100;
--SET @RunDateYr = YEAR('20231010') * 100;
SET @RunDateYr = YEAR('20241010') * 100;

DECLARE @RangeStart INT
 ...

That looks like the SSMS toolbar. I am talking about the toolbar which is displayed when you create a post here:

I have a query that returns 9 rows of data.  I want to remove the rows that cancel each other out by the amt column.  See current results below...

Hi Frederico,

Thank you so much for your answer. I got a couple of questions before my code, if this ok with you. The first and the second CASE are...

What is your question?