As Brain mentioned the only way you can specify MAXDOP from within SSIS is to use it with SQL Query. MAXDOP =1 means disabling parallelism.

Check this ..

http://technet.microsoft.com/en-us/library/ms181007(v=sql.105).aspx

You can do...

Try this ..

http://technet.microsoft.com/en-us/library/cc753510(v=ws.10).aspx

--

SQLBuddy

I don't think there is any alternative method. Just search and replace.

--

SQLBuddy

That error shouldn't cause SQL Server restart. Could be a problem with the I\O Subsystem. Did you check for the SQL Server dump file and analyze it ? You need...

Ford Fairlane (3/25/2014)

---

Guys,

With a system set up that has AlwaysOn groups configured with a number of databases that may or may not be related - and one of the systems...

mike 57299 (3/25/2014)

---

I have a 2012 SQL server. If I am on another machine on the nextwork and run SSMS to login to that server, I can. If...

Check these options ..

http://blog.sqlauthority.com/2010/01/11/the-server-network-address-tcpsqlserver5023-can-not-be-reached-or-does-not-exist-check-the-network-address-name-and-that-the-ports-for-the-local-and-remote-endpoints-are-operational-microso/

--

SQLBuddy

kaplan71 (3/26/2014)

---

Hello --

The third-party backup program can be configured to exclude the directory where the log files reside.

That brings me to another question: Correct me if I am wrong,...

sqlserver12345 (3/25/2014)

---

Lets say they have to be restarted and those moments when the server is getting restarted is when the SQL jobs are scheduled.Is there a configuration which would take...

This is the issue " The statement has been terminated.The INSERT statement conflicted with the FOREIGN KEY constraint "

You are trying to insert a value in your table which...

Yeah, Change it to Don'tSaveSensitive and use Config files.

Check this for PackageProtection levels ..

http://technet.microsoft.com/en-us/library/ms141747.aspx

--

SQLBuddy

vignesh.ms (3/21/2014)

---

Hi Experts,

I'm newbie to SSIS. I just used this for data movement between servers. I wanted to learn more about SSIS ...

What to learn ?

How to learn?

Thanks In...

Are you experiencing any memory pressures on the server or memory related errors ?

--

SQLBuddy

Oracle_91 (3/15/2014)

---

Hi Experts,

Could anybody please suggest me a way to monitor the load on my database server?

What perfmon counters should I monitor on daily basis and confirm that load on...

muthyala_51 (3/20/2014)

---

as alwayson doesn't support cross database transactions and cross server transactions based on the below link. I am trying to understand what would be affect of this in a...