tmitchelar (11/12/2010)

---

Two things come to mind. Depending on OS on server, you might need to restart the machine after configuring your environment variable. Second, you need to...

BTW, I was able to setup a job on my local SSMS, but when I copy the files to production, I got the error on the 1st floor, the wrong...

Thanks CEWII & Tmitchelar, I will definitely have the Environmental variable, which is much easier for management.

My problem is:

1. Set the connection string during development stage in VS Business...

Besides, when I build SSIS package on local, I create the configuration file also on Local, therefore, I found this:

<DTS:Property DTS:Name="ConfigurationString">C:\....\....\....\....\DBConnection.dtsConfig</DTS:Property>

Should I also put the same DBConnection.dtsConfg to the same...

Elliott Whitlow (11/11/2010)

---

I'll answer #2 first, From BOL: The SMTP connection manager supports only anonymous authentication and Windows authentication. It does not support basic authentication.

#1, I tend to try and...

Henrico Bekker (11/11/2010)

---

I agree with Elliot.. did you save any passwords or authentication information to data sources?

If you configure dtsx packages with passwords, you need to save them with the...

Ed Zann (7/30/2010)

---

princa (7/30/2010)

---

Ed Zann (7/30/2010)

---

If you only want to update specific rows in your sub-table, you would use a SQL Task in the Control Flow and write a standard...

Thanks a lot David and Mohit, I will keep digging it and you guys rock!!

Thanks a lot Mohit, though you were out of office and you didn't miss anything and I really appreciate for the help and suggestions!!!!!

Just a non-technical question to you Mohit...

David Benoit (8/11/2010)

---

Not sure about the Performance Tuning book. I'm sure it is good though. The e-book that I was referring to can be found HERE on Simple Talk[/url].

It...

First, the optimizer changing the plan with that much of a change in the output is not surprising to me. I would really suggest checking out Grant Fritchey's book on...

David Benoit (8/11/2010)

---

Well, glad that worked - somewhat. Now for my disclaimer - when having to use join hints, index hints, etc it tells me that the optimizer is not...

First, the optimizer changing the plan with that much of a change in the output is not surprising to me. I would really suggest checking out Grant Fritchey's book on...

Hi Mohit,

No, I am not running this query in a stored procedure, just regular select query.

I have primary key index and nonclustered index on age for example, and it's...

multicast?! any simple examples?:D