That is kinda what I was thinking but experience tells me to tread lightly before stomping my foot.

Thanks

I am totally impressed with Dimensional insight's Diver. Great for adhoc analysis and pretty intuitive but it would really depend on your users and how they want to use it....

You can right a sql statement the uses the two tables or use two lookup tasks.

There are two formats for fixed width - one has a extra column for the deliminated row value. Have you tried that? Unfortunately I do not work with fixed width...

Go into the advance tab of your destination (flat file) connection. There is an editor for all of your columns there. You can see what the deliminator is for each...

Your update is comparing one variable to another and never asks which record to update. As long as @status = 'Platinum' or 'gold' etc and @location is...

While the information you are getting is invaluable --why make systables your first stop?  Information_schema views are much more user-friendly. (Table_name vs object_name(id)). And they upgrade better.

Only bugger with Information_Schema views...

If it was a named instance it might need the config file changed. You might double check your config settings any (BOL:Configuring the Integration Services Service)

Is this a default or named instance?

Been working with exports all day

I didn't test this completely but I believe if you go to the columns tab in the flat file...

New Horizon's T-SQL course is pretty good. They are all over the country.

set

nocount on

declare

@col nvarchar(200), @n int

select

@n