Without knowing more about dbo.[spAmount_V1], I can't do that.

Please post the 'signature' of that proc. That is, the following bit

CREATE PROCEDURE <procname> <parameters>

AS

In particular, you should have an OUTPUT parameter...

Stored procedures return results differently from functions. Here is an example proc and how to call it:

CREATE PROCEDURE dbo.DuffProc @RetValue VARCHAR(50) OUTPUT
AS
BEGIN
    SET @RetValue...

Try changing this part

(SELECT BirthYear = n + 1921, Age = YEAR(GETDATE()) - n - 1921) calcs

JOIN GroupInfo g

ON calcs.Age

BETWEEN g.StartAge AND g.EndAge

ORDER BY Tally.n DESC;

to this

(SELECT...

Hi @SSC Guru

I Just get a list of Distinct birth years from Customer table. So then based on that list I need to further calculate the other values

            
June 7, 2021 at 2:48 pm
            
#3893006

            
            
                                                
        

As you have not provided any DDL or sample data, and your sample results do not appear to include a single reference to your customer data, I had to guess:

I cannot not see any question here.

OK, understood. Unfortunately, I do not have time today to help any further. If no one else answers in the meantime, I will try to get back to you in...

Are there embedded carriage returns in that file?

Have you set a text qualifier? (")

As packages usually run within the context of an unattended process, message boxes within them should be avoided (unless developing or debugging).

I notice you mentioned users running this. For them...

Also, how is the value of ColumnType determined?

OK, that helps.

So you are looking for a routine which imports only the first row of a spreadsheet/CSV file, transposes that row of data into separate rows and adds them...

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

How are you displaying the popup? You need to display it from Excel, not from within the package.

The columns in the spreadsheet do not appear to correspond to the columns in your screenshot, making this a bit of a puzzle.

Why not just hit 'TRANSPOSE' in the spreadsheet,...

Please give an example of what you...

I just played around with this scenario for an hour and I was unable to come up with a solution which works in all cases. Very irritating.

Automating an export to...