MissyDaisy (4/12/2012)

---

Your suggestion will work optimally. Unfortunately, I can't implement it as the service account does not have write permissions on Database2 tempdb and never will.

So I...

For the client operating system follow this article.

For the server, since you've posted in the...

Agreed! SQL 2012 makes it much easier to have them too, although I have...

DeusExDatum (4/11/2012)

---

I totally agree opc.three; I guess it depends on why you need to change the Connection. If your looking at it from an infrastructure perspective, and it's to...

Awesome! Two outspoken anti-RBAR-advocates in one thread threatening to learn SSIS, I might fall over :hehe:

EDIT: to...

Brandie Tarvin (4/11/2012)

---

Because if sa is disabled, then scheduled...

Sorry, I misspoke, I use PowerShell with a WMI query, not Policy Based...

Lynn Pettis (4/11/2012)

---

Okay, who has the...

You're unbelievable....

Using variables, expressions and command line parameters is overkill in a sense. For the record though, you can set the property of anything in the package directly using command line...

sanj_love89 (4/10/2012)

---

what are the setting to avoid the authetication

or how to allow the windows authetication

Settings for SQL server so i can allow windows authetication and the authentication not failed

Thanxs...

Raunak Jhawar (4/11/2012)

---

opc.three (4/10/2012)

---

The 1TB in 30 minutes example was leveraging parallelism within SSIS. If you're using a foreach loop then you're making SSIS single-threaded. Since you have a varying...

Any chance it turns your world inside-out and gets you away from using BULK INSERT and xp_cmdshell, and instead onto using an OLE DB Destination with fast-load and the Execute...

Whoa,...

SQLKnowItAll (4/10/2012)

---

Perry Whittle (4/10/2012)

---

rename windows server, then use sp_dropserver followed by sp_addserver.

Note you cannot rename the instance...