Execute SQL TaSk

Hot Topic

Question about data mining features in a relational database?
modify datetime parameter
retreiving connection strings from machine.config
convert keywords to UpperCase
AdventureWorks database not seen by Management Studio Express CTP
Collapse all details in SSRS 2005 report?
What is the ADO DataType for nVarchAR(max)
Microsoft decision tree
SSIS question - database syncrhonization
SQL Server 2005 Trigger fires per statement or per Record

SQL Server

2005 SP1 install, another can't authenticate...
One dataflow for sevral Oracle Instances ?
Cannot insert explicit value for identity column
Deliver to SharePoint
XMLBulkLoad
Inside a project you lose the control??
Forcing Users to log out of SQL 2000
Schedulling Jobs on SQL 2005
Trouble with Iif!
SSIS Send Mail Task - Failure Sending Mail

Execute SQL TaSk

I am trying to run a Direct Input SQL query to SELECT MAX value of ColA. This query when I run on Query Window runs fine - means it is NOT a NULL. I get a max value.

When I run this query on a SSIS package outputing to a variable - I get the error. -

[Execute SQL Task] Error: An error occurred while assigning a value to variable "MAXROWKEYID": "The type of the value being assigned to variable "User::MAXROWKEYID" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object. ".

I need this output to be used for the subsequent steps which follows this.

I am using Value Type as Double. This was the default when I migrated this DTS package from SQL 2000. I use the proper Single Row for the Result Set and for outputing the Result Set, I use the correct Variable Name.

Help will be greatly appreciated...

Thanks.

SAM.




Answer this question

Execute SQL TaSk

  • Torrin Jones

    Obvious first question, what is the type of ColA

    I had some trouble with populating Double variabls recently, I couldn't load it from a field of type decimal. I had to cast the value as a float first.

    -Jamie



  • Romuel

    After debugging the task, I found that the value returned by the MAX function on a bigint column is of type String. Thats why your task failed when you used variables of type Int32, Int64 or Double. I see the same behavior when MAX function is called on a decimal column. However, MAX function on a int column returns Int32 type and float column returns a Double type.


  • CustardMan

    Kept the value type as Double and when I tried to make this as

    SELECT CAST(MAX(ROWKEYID) as FLOAT) from Table on SSIS package, it runs fine, successfully, but the value does not change. I mean, when I run on this Query window -the value is different.

    But when I try -

    SELECT Max(ROWKEYID) FROM Table and making the variable type as Int32 or Int64, the step fails.

    -Sam



  • Ballu2006

    Try making the variable type "Int32" or "Int64".

    -Jamie



  • Joselillo

    ColA is my ROWKEYID - it is bigint datatype.

    -Sam



  • Execute SQL TaSk
Answer this question