If you could follow the second link in my signature on posting code and data for the best help I'm sure we can get to some working solution

We would need...

And thank you for the information, never seen that before so will add it to the list of gotcha's.

jghali (5/31/2012)

---

Hi all,

I'm having an issue to create a linked server connection to netsuite on the cloud.

They supplied me with an ODBC driver.

With the ODBC, I was able to connect...

The problem will most likely be down to 32 vs 64.

As you see the DSN in SysWOW64 that means the DSN is a 32bit DSN not a 64 bit DSN,...

The QRG has a table on page 2 titled how to license.

In that table is shows the following information

1. License all the cores in the hardware

2. A minimum of 4...

Not nessesarily, we used the exchange SMTP server as the relay, when we wanted to add a host to setup mail we had to add the servers IP in as...

Depending on the model number of the processor and how many of them you have in the server depends on the number of licenses you need.

You have to license 1...

As with anything surrounding licensing, it is best to speak to MS directly, please do not take what people say on the matter as litteral that is the way to...

DTS is another one to use

No, only points 1 and 3

Index and statistic maintenance should be done

Good practise, 2 of the points are BAD practise

Rebuild/Reorg indexes - Do this yes

Shrinking the files - Bad idea

sp_updatestats - This is partily done in the Rebuild/Reorg

Restarting the server -...

Take a look in the stairways section, for the stairway to integration services also there is plenty on the internet if you use a defined search term like using ssis...

create a data flow task

drag in a ole-db ado.net source connector, up to you which

drag in an excel destination connector

create the connection strings in both of the connectors to the...

If something can be done in SQL do it in SQL not CLR is my mantra.

String splitting can be done in either format, just depends on the load your putting...

Yes, that is correct, if the db is sized at 100GB but only has 50GB used then the backup would be around 50GB (give or take), same again, if the...