donna.harrison (12/22/2009)

---

I have an existing database with the following settings. Data: Initial size: 296mb Log: Initial Size: 11735mb I am sure the log...

Gkhadka (12/22/2009)

---

Yes.....you are right, if he already have installed SQL 2008, then there is no need for new liscense for SSIS. SSIS comes with SQL.

I think the main concern for...

Gkhadka (12/22/2009)

---

CriquedeSQL... I think you missunderstood the question above. I think he is saying that he installed SQL 2008 and SSIS on one server (let it be a DEV box)....

You will still need to install the...

If you can modify the source table to include a column to control synchronization, that would be most excellent.

IsSynched = 1 in source, then SSIS ignores it and does anything...

I second the motion.:cool:

sturner has offered some good advice.

In addition, by doing this up front - you may save yourself some administration time down the road. Before doing, you will need to...

acapucion (12/22/2009)

---

I have a scenario, installed SQL Server 2008 Database Engine and SSIS component into one server.

Developer wanted to have capability to design SSIS, so I installed him BIDS...

tbrun (12/22/2009)

---

thanks.. aware of SMO but just not getting into that now...

the create object isn't the error i'm getting .. but i'll try this anyway.

But...

Jeff Moden (12/22/2009)

---

Heh... nah... "tweeking" is the word that I would chose on the one you're thinking of. 😀 I bashed one that Steve posted...

Jeff Moden (12/22/2009)

---

CirquedeSQLeil (12/22/2009)

---

Bru Medishetty (12/22/2009)

---

CirquedeSQLeil (12/22/2009)

---

Bru Medishetty (12/22/2009)

---

Our good old friend has another doubt anyone care to answer ?

http://www.sqlservercentral.com/Forums/Topic838140-5-1.aspx

Recollect some of his / her famous threads.

Lock Pages in Memory

How...

You're welcome.

Jeff Moden (12/22/2009)

---

GSquared (12/22/2009)

---

Lynn Pettis (12/22/2009)

---

I'm starting to notice a trend in a few questions where people expect tables to store records in a specific order. Anyone else seeing...

As a side-note, it is recommended to upgrade to SMO. Though the Backward compatibility pack exists, it is not guaranteed to be included as an option with future releases...

Sometimes you will need to manually register sqldmo.dll in C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll using regsvr32. For example, if you get the Server.CreateObject Failed message, you will need to register that...