Thanks for the replies.

I was hoping more that there was a property in my default value statement that I was missing somewhere. I'm familiar with the methods...

Thanks of the suggestion. We aleady tried running the job in 32-bit mode via the job agent.

The big picture is that we have to connect to password protected Samaba...

Hi guys

I understand the basics of the keys and indexes. My question is, in SQL Server 2000, BOL specifically says:

"Note PRIMARY KEY constraints create clustered indexes...

Hi

I was on Vacation so it took me a few days to get back to you. The solution I posted was in regard to the filter in Reporting Services.

However,I...

Thanks for responding. Yes, I have changed the package protection level to DoNotSaveSensitive. I have also, at Microsoft support direction, changed the protection level to have a password....

You are definitely passing a list to your where clause if you are doing the split/join with a multi parameter and you choose more than one parameter. that means...

Hi

Try "Where blob in (" rather than "Where blob = "

You are bringing a list into your sql

Hi JackTheC

I'd need to know more details to help debug your issue. But one idea would be to remove the filter for now, add a text box to display...

I am replying to my own post.

Here's the deal....

Selections from a multi-select parameter are saved in an array.

If you want to filter on a multi-select parameter, you have to first...