Eureka! i finally got it to work. looks like it was Rtrim only that finally made it find the lookup values.

thanks to all!

-js

okay! small victory thanks to all on this thread (esp Vani). i was able to get the tutorial to work and have been playing around with it, trying...

i started a brand new dummy package so that i can be sure it's nothing with the data that's causing the hiccup (see attachments). i created a table called...

when i try to trim the lookup columns it tells me:

Connection Manager attributes have changed. The mappings of previous columns are invalid.

then when i try to get to the...

how would i go about trimming from a flat file source? would that option be in the connection manager or in the flat file source transform? i looked...

this is going to have to take a back seat for a few days while i work on quarterly reporting. i appreciate your assistance thus far and plan on...

i took the package you sent and all i did was adjust the connection managers since i don't have the same paths as you did. i am getting this...

the package doesn't make it that far. not sure if it needs to get that far and break in order for me to obtain anything for that. i'm...

thanks but unfortunately she doesn't like that either. still not evaluating.

definitely seems to be something with the BuildingID var because this evals fine.

@[User::filepath] + "Report-"+".xls"

first off let me say thank you! i can tell that once i am able to get this to work it will be a valuable package for me. ...

trim did it! gotta give it to you on that one. thanks a ton.

thanks for the responses. i tried another route, just to see if i can get it to write to different tables, as opposed to different excel files. i...

gotta give thanks to both of you. i used the brute force method, combined with COALESCE command since i'm comparing NULLs.

thanks!

Hello again Phil.

You have a single table containing all that stuff? Sounds like it might be in need of some normalisation ...

this particular table does not come from the live...

Msg 1023, Level 15, State 1, Line 2

Invalid parameter 1 specified for datepart.

i changed it to

set dateYear = DATEPART([year],[datestamp])

and it works fine.

thanks Phil!