Error when clicking OK on edit of task

I've got a package that was imported from SQL 2000 into SQL 2005. I'm trying to edit it in Business Int. Dev Studio. When I open what used to be a data pump step in 2000, I'm able to edit items. However, when I click OK, it puts an error right below the buttons:

"" is not a value type

And it won't let me save my changes. I have no idea where this error is coming from. All the data pumps in this package cause the same error. Your help is appreciated.Found the solution thanks to our server support staff: They noticed that all the global variables (now referred to as inner variables) were missing their type. They had names and values, but no type. To give them a type, we just needed to change the name of the variable and then change it back -- this caused the type dropdown to become active. Then we had a type for each variable as well. I hope this helps others who run into this same issue.|||

arc_dev wrote:

Found the solution thanks to our server support staff: They noticed that all the global variables (now referred to as inner variables) were missing their type. They had names and values, but no type. To give them a type, we just needed to change the name of the variable and then change it back -- this caused the type dropdown to become active. Then we had a type for each variable as well. I hope this helps others who run into this same issue.

Well done for picking this up. Did you use the migration wizard? If so, this is a bug in the migration wizard. Could you report it at Microsoft Connect?

-Jamie

|||I just created a bug report with screen captures of what it does.

error trying to move data from 1 table to another.

Hi I am getting the following error
Syntax error converting the nvarchar value 'null' to a column of data type int
while attempting to move data from 1 table to another with the script,
INSERT INTO [dbase1].dbo.DML$table1
([Data_Item_ID])
SELECT CAST([Data_Item_ID]as int)
from [DML1].dbo.dataitemlog
I have allow not NULL for both source and destination fields, so do not see
how I could be getting this error, also did not see any null values in the
source field. The source data type is
(nvarchar (4) not null)
and the destination field data type is (int, not null)
any suggestions? thanks.
--
Paul G
Software engineer.this problem has been addressed in a previous post. thanks, Paul.
"Paul" wrote:
> Hi I am getting the following error
> Syntax error converting the nvarchar value 'null' to a column of data type int
> while attempting to move data from 1 table to another with the script,
> INSERT INTO [dbase1].dbo.DML$table1
> ([Data_Item_ID])
> SELECT CAST([Data_Item_ID]as int)
> from [DML1].dbo.dataitemlog
> I have allow not NULL for both source and destination fields, so do not see
> how I could be getting this error, also did not see any null values in the
> source field. The source data type is
> (nvarchar (4) not null)
> and the destination field data type is (int, not null)
> any suggestions? thanks.
> --
> Paul G
> Software engineer.