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?

😎

My only problem is may not have the math right. I can't get the same values when using Calculator, so please double check the equation used and provide feedback...

Here is my updated version. Please note that there is now a clustered index on EmpNo and PerDate. This is required for this to work. It is...

Okay. I think you provided incomplete info in your posts, unless I missed it, as I didn't see anything resetting @FinalData to 1 on an employee or year change....

Not going into the code, this is actually a good time for you to also try out writing a recursive CTE (since you are using SQL Server 2005, based on...