Thanks, Phil! I remember something about SQL Search a while back, but haven't tried it yet. I'll check it out, and will give it a shot. = )

Right, this is more along the lines of what I'm trying to do - I want to know if ANYTHING is using those tables before I disable the package.

That sounds like a great method also, and yes .dtsx is the extension I was looking for as well. = )

Thx, yayomayn! This is very cool, and I'll give it a shot now!

What I wound up doing was opening all of the packages and reports in their "xml" format in...

I kept trying different solutions and I kept getting the same results for the counts. Finally determined it was because I had to upload and replace the revised report...

After reading more online and other forum posts, I discovered that I was going about this wrong. I created another query that used a customer list based on the...

What I ask this: I can run the two queries separately in SSRS, but I didn't have a way of joining the same customers that purchased one or more...

The correction I made works now, and it appears that the data is valid. However, the problem I have now that I should have also foreseen is that I now...

Right, and I was trying to be brief although that typically turns out to be vague. Nevertheless, I found the syntax error... when I said there was only one...

One more thing, I did wind up having to add a new column, because as Sean mentioned the original column as varchar is always going to be a thorn in...

yep, that did it! Saves me from having to redo the table and the related queries and inserts. thx again!

hm - thx Scott! Let me give this a shot!

I think you might be right, Sean. As I mentioned in the other reply to Lynn, I'm trying to execute SQL in a package that uses a parameter for date....

I'm putting together a package to truncate and load this table each month, and I'm getting an error when using a parameter ? for the date. I'm using one...

shnikees - I think it worked!!

thx so much! 😀