You could use an Execute SQL Task before the data flow.

In the SQL Task, you retrieve the data and put it in a variable.

Inside the data flow, you use a...

Right now @TotalRows will always be 1 at the end. Is that the idea?

If you want the rows not updated, you'll need to do a rowcount (there are many ways...

The event log usually has nothing useful to say.

We either need the job history from the jobstep itself, or the SSIS logging.

Easy one to finish the week, thanks Steve!

Didn't you get any warning or error when you went through the wizard.

I remember the wizard disabling the run immediately when there was some sort of issue the wizard couldn't...

You're right, it didn't help 🙂

Normally SSIS wouldn't just lose rows. Even if it's a bad connection. TCP/IP connections are used, so they are pretty reliable.

A bad connection could slow...

Sean Lange (8/8/2013)

---

This whole English thing is the reason we American's don't know any other languages. All the others have actual rules that you follow all of the time. In...

I think you need to define a drillthrough action in SSAS:

Defining and Using a Drillthrough Action

Sean Lange (8/8/2013)

---

I was reading a post from Wayne Sheffield and he explained that in order to understand set programming in sql you need to "stop thinking about what you...

Sean Lange (8/8/2013)

---

Koen Verbeeck (8/8/2013)

---

Sean Lange (8/8/2013)

---

Koen Verbeeck (8/8/2013)

---

Hmmm,...

Sean Lange (8/8/2013)

---

Koen Verbeeck (8/8/2013)

---

Hmmm, this might be the...

Hmmm, this might be the language gap. I was...

jbm6401 (8/8/2013)

---

Are there any examples out there that can export data from a query into a text file using BIML? I am searching the interweb and cannot find any...

Jeff Moden (8/8/2013)

---

Koen Verbeeck (8/8/2013)

---

I think one of my first "eureka" moment - as Jeff calls it - was when I read Jeff's article about the Tally table 😀 The...

Sean Lange (8/8/2013)

---

Here is another way which doesn't required a sequential identity column.

with MyCTE as

(

select col1, col2, ROW_NUMBER() over(PARTITION by col1, col2 order by (select null)) as RowNum

From SomeTable

)

DELETE MyCTE

where...