PaulB-TheOneAndOnly (1/31/2012)

---

SQL Kiwi (1/31/2012)

---

SQLKnowItAll (1/31/2012)

---

As long as you say it with a positive attitude and maybe a little "I really wish I could, but I just can't figure out how...

Koen Verbeeck (1/31/2012)

---

vardan.hakopian (1/31/2012)

---

Thank you guys all for for your responds.

I used Export Data to create SSIS pakage.I saved (file system) then created a Agent job.But job fails.Here is...

You really are not giving enough information here. Did you rebuild the project after saving? Have you verified all the other scenarios in the article I gave you? Is the...

Agreed, if there really isn't time (it happens, but is many times used as an excuse for poor development) it should be truncated at the database layer. However, I have...

Yes, you should rebuild once you change and save properties. Which protection level is it now set at?

Did you click on the link I gave you about troubleshooting SSIS deployments?

SQL Kiwi (1/31/2012)

---

SQLKnowItAll (1/31/2012)

---

Personally... I would tell them no. We don't truncate data at the database level with SQL Server. Tell them it is not possible and that they...

Personally... I would tell them no. We don't truncate data at the database level with SQL Server. Tell them it is not possible and that they simply have to...

Check this out. I believe it probably as to do with ProtectionLevel.

DR and HA are NOT the same thing, nor should they be confused as such. Replication is an acceptable solution for High Availability, but it will not completely recover your...

Ha! Found this.

Thanks for the help!

So basically... The question on page 21 (for anyone using the book) which reads "Which edition of SQL Server supports installing more than one instance of SQL Server on a...

You can do this as an administrator of the site. Go to the report you want hidden and alter its security to not inherit parent security. Then only...

TIMPARROTT (1/31/2012)

---

This reply is some three months too late.

Using a Union Query to merge the data from the two tables will return all projects whether they have actuals and no...

I'm not sure that you are going to find any software that magically does what you want without creating a customized package. SSIS is probably still going to be...