1. You read the line and store it inside a string.

2. You read the first 3 characters and depending on the result, you decide what to do.

...

I remembered that it is sometimes called a "primary key constraint", so the question was easy enough.

Still I expect some flaming in this topic 🙂

Another vote for the view.

The DSV has the tendency to hide things for you, while a view is more straightforward.

Also, if the database is in source control it is more...

I would get all the dates that need to be processed and put them in an object variable.

In a for each loop, I would loop over all of the dates...

Thanks for the question.

If you put zippedFile in the variable mappings, the for each loop will overwrite that variable each iteration of the loop with the current filename.

If you want the for each...

Where exactly do you use the datePart variable in your for each loop container configuration?

Iulian -207023 (7/15/2014)

---

Koen Verbeeck (7/15/2014)

---

Indeed, the file is formatted quite well in the sense that it is very predictable.

How I would do it:

* read the file in line by line...

Indeed, the file is formatted quite well in the sense that it is very predictable.

How I would do it:

* read the file in line by line as one giant column...

Very interesting question, thanks.

No, there is no such parameter.

You would need to execute a TRUNCATE TABLE first before you call bcp.

Well, it would be easier to verify if you provided table DDL, sample data and desired output. (see the first link in my signature on how to do this).

The data...

I would suggest you pick up a good book about dimensional modelling, such as The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling and especially Star Schema The Complete...

If you export, how can you overwrite a table?

Maybe something like this:

SELECT Hole_ID, NAT_East, NAT_North, NAT_RL, Max_Depth, SUM(Interval) AS Sum_Intervals

FROM dbo.BCI_Step1_Test

WHERE (Fe_pct > 57)

GROUP BY NAT_East, NAT_North, NAT_RL, Max_Depth, Hole_ID

UNION ALL

SELECT Hole_ID, NAT_East, NAT_North, NAT_RL, Max_Depth, 0 AS...