thanks!

I am learning so much here it's scary.

Sheesh, I should have known that. Thanks!

I meant that I was now looking for ways to copy several views over rather than re-create them one at a time. Now that I have the tables copied.

thanks

Yes, but having never touched SSIS before yesterday, the "run it like you would any other" idea leaves me hanging.

And is there a way to do this with views,...

OK, I can do that. Two questions, though:

How can I run this saved package again if needed (and it almsot certainly will be)

It gives me a choice of saving to...

I am using OLE, but the tutorial is using a flat file. So I get it now, and have made the correct connections.

However, I have an unrelated follow-up...

Sorry I didn't respond earlier. I was out of town. As it turns out, the error I was getting was not related to my syntax as I thought it was....

I agree joins are better. I was just trying to solve a problem. Sadly, I got the same error when I moved the JOIN criteria to the WHERE clause. Frustrating.

Anyway,...

OK, thanks. So many times, it's a matter of knowing the right words to search for. I did a search in Google for "determine what is hitting a database" (same...

Yeah, looking back, I was clear as mud. My apologies. I have this query working fine when selecting from SQL Server. However, the MSS data isn't current. I can make...

It works for SQL Server, but sadly, not for Progress. I will keep digging. Thanks.

Thanks. I don't really understand all that is in that trace code, but I will try to digest it. I am new at this DBA stuff and don't know all...

It seems to have worked. Thanks.

I think Option 1 is best. I added a column and will now do an update. First, I have to cast the one column (which is numeric) as a varchar.

thanks

that makes a lot of sense. Let me see what I can do with that. Thanks!