mmattson (4/12/2011)

---

Scenario

* 20-30 million rows in each 3-5gb CSV file

* SQL Server 2008 SP2

* 4 environments (dev, test, pre-prod, prod)

* All environments running win 2008 ent...

I prefer to use OLEDB Destination, so I will show an example in that.

The SQL Statement is:

Exec mis.dbo.update_loadlog ?,?,?,?,?

In the 'Parameter Mapping', set the first 'Parameter Name' to 0, the...

If you are importing the data from a flat file a source external to SQL Server, you can use SSIS to do that.

Are you loading this via SSIS? Third party? Bulkcopy? Does the data already exist in a 'temp' table and you need a strict SQL solution?

Rob Schripsema (11/18/2010)

---

sqlrunner (11/18/2010)

---

I have a script component that watches 1 or more directories for a file mask i.e. (log*), when it finds it, the information is passed to the...

I have a script component that watches 1 or more directories for a file mask i.e. (log*), when it finds it, the information is passed to the rest of the...

Rob,

I have a question. How many different transformations do you have? That is to say, of the '100' different incoming files, how many SSIS packages would...

In most cases normalization is the proper way to design your system. It used to be that normalization was too resource intensive on database systems, but that is no...

These are all rather complex questions with no simple answers. I suggest you start looking at SQL Server books to build up your knowledge. Once you do that,...

carl.anderson-1037280 (2/11/2010)

---

This article is in regard to indexes with included column on heap tables. This means the table doesn't have a clustered index, right? In our data warehouse,...

I start with some advice from my maternal grandmother 'If you can't fix it, don't worry about it, otherwise (paraphrase here) crap or get off the pot".

-- Fight hard to...

I installed the 2005 version THEN the 2008 version and I have had no issues. Not sure if that matters, but since I never had the issue, I cannot...

You are getting this from your workstation? Do you have 2005/2008 installed on the same system? If so, you have to make sure it is installed in the...

- Get my MCITP for 2005 database developer

- Write my first Erlang program

- Try to be nomiated for MVP

- Continue to blog

- Continue to mentor

- Continue to learn

rahulsony111 (12/21/2009)

---

I have to add a column LAST_UPDT_DT_KEY_NO (whose datatype is NUMBER(10,0) in target) and i have to assign today's date to that column.

So in Derived Columns i wrote LAST_UPDT_DT_KEY_NO...