Your welcome. Just to follow-up though, do you know why I made the suggested change in your WHERE...

He should be able to if he takes the time to read your article. That is where I came up with the idea for this solution.

😎

Can any of the values in the denominator be negative, or are all values greater than or equal to zero?

😎

I'd do the following instead (notice change in the where clause):

select

UniqueID,

sum(case termcd when 'BM' then 1 else 0 end) as BM,

...

Use this and what John posted to get you going:

create table dbo.TableB (

UniqueID int,

termcd char(2),

calldate datetime

)

insert...

With VERY LIMITED test data, this is what I did and it works:

CREATE TABLE [dbo].[Table_name] (

[Key_m] [int] IDENTITY (1, 1) NOT FOR...

Let me get this straight. You imported the data into a table with all varchar columns, and you are now trying to modify the data type of the columns...

Matt,

Here is the code I was using to do my testing:

CREATE PROCEDURE dbo.usp_ProductPagesA @firstrow int = 1, @sort varchar(50) = 'ListPrice'

AS

BEGIN

SET NOCOUNT ON

...

I am assuming that the data value provided is a sample of the data you are importing. Also, what error messages are you getting during the convert process? ...

Here is one way with dynamic sql. It uses exec (@SQLCmd). There is another way using the sp_executesql, but I didn't research it yet. I would actual...

What you are trying to do may require using dynamic sql. How is the column selected for sorting and how many columns can b this column be selected from?

😎

Do the other Execute SQL tasks work okay?

This part of your post is critical in determining what is wrong:

Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not...

Okay, so you are using an Execute SQL task; that doesn't fully answer my question regarding your SSIS package. How is your package setup? What else is in...

Can you provide more information regarding your SSIS package? How are you executing the Sp in SSIS?

😎