Jeff, I think I can answer that one myself.. Low latency and lots of data. Apparently it takes like 40 minutes to re-index the data.. What I'm...

Ok.. At least there is a reason..

DECLARE @UserName varchar(30),

@Password varchar(20),

...

I think I'm going to have to suggest a different tack..

I think you should find out what is wrong with the underlying objects structures. ie, figure out why the...

Do they require sending the mail using SSL? That is all I can think of is that they don't allow you to use port 25.. Does this component...

1. Determine what the proxy users name is domain\username

2. Right click on file you want to check.

3. Go to security tab.

4. See what users have rights to that file.

One issue,...

I don't see much value in doing that, why don't you chage the datatype to varbinary(80) and be done with it.. Storing it as text doesn't buy you anything...

That garbage is the hashed value.. That is what you store..

When you get a username and password you also need to normalize case of the username and password.

DECLARE @UserName...

Steve Jones - Editor (10/20/2009)

---

I received a complaint from the user about some of the postings. While I told him/her that I disagreed with the tact they were taking and...

I agree, depends on what I need and why I need it..

CEWII

Is the package load returning that or while it is running? Is the package you are trying to load in the same solution you are running? Are you...

daphneds (10/20/2009)

---

And I wouldn't try merging dtsx files using any source code system. We treat them like binary files and use SVN locks to prevent two developers from working on...

I'm personally not a fan of that...

What do you see from View|Database Explorer|Right click Data Connections|Add Connection

I see:

Microsoft Access Database File

Microsoft SQL Server Compact 3.5

Microsoft SQL Server Database File

What about you?

CEWII

I agree, 1MB is WAY too small, database growing is a synchronous operation, basically everything has to wait until it is done. So you don't want to have to...

So your parameter table is a name-value pair type of arrangement. For this I can see that. When you build the query for each report how are you...