Hi Philip,

To get rid of the null values, one way is to replace left join(s) with inner join(s).

If the business logic requires left join, then you may have to...

are you sure the logic here are correct?

By the way, the more left or right join you have, the more nulls you may have.

The reason caused null value is not by ISNULL function, it might come with tables join.

Post you complete codes here, it may help.

What does format A mean and do you have a property showing the field type in your layout file?

How do you match fields for importing?

I have a thought.

task 1: use...

Ron,

Hope this link can help you.

http://msdn.microsoft.com/en-us/library/aa173859(SQL.80).aspx

Hi Ron,

If you know how to use bcp or bulk insert, you may want to create an 'Execute Sql Task' to do the same job.

declare @tbname as varchar(128)

declare @column as varchar(128)

set @tbname='your table name'

select @column=name from sys.columns where object_name(object_id)=@tbname and column_id=2

exec ('select '+@column+' from (select top 6 row_number() over( order by getdate()) as row,'...

Can you use the new login to log on the B server, or you just can't use the new login to access some databases?

Please post the error messages you got....

I would suggest you read following articles first.

http://support.microsoft.com/kb/246133

http://support.microsoft.com/kb/274188/

try this out

insert into orderkititems(...)

select a.* from

(select 'item' as item,col1,col2) a,

(select top (select quantity from kitDetails where item='item') '' as row from sys.all_objects) b