I'm not sure this is possible.

The name of the erroring component is not made available in the event handlers. Only the name of the dataflow is made available (System::TaskName).

No, I haven't had the issue before.

Where are you installing from? Download, DVD?

You also need to give him read permission (db_datareader) on the source and write permission on the destination (dt_datawriter).

If the user needs to use the TRUNCATE TABLE statement, he also...

Connect to a Remote Integration Services Server (SSIS Service)

Normally no, but you have to configure your connection as read-intent. (Readable secondaries accept only read-only connections).

Client Connection Access to Availability Replicas (SQL Server)

Availability Group Listeners, Client Connectivity, and Application...

What's the error?

Make sure DCOM permissions are set-up correctly so SSIS can accept remote connections.

Connect to a Remote Integration Services Server (SSIS Service)

Let's be clear here:

cursors are sloooooooooooow.

Only use them if you have a very good reason to use them.

Great question to close the week, thanks!

Watching it right now. He've made some cool jokes so far.

"Don't type in demo's"

"Fat and thin are relative"

"It's like...

I'll ask it again. You said you configure your destination in the dataflow dynamically.

My question was: how?

OK, and how do you configure the tablename?

Brandie Tarvin (11/8/2012)

---

Koen Verbeeck (11/7/2012)

---

Lee Crain (11/7/2012)

---

I'm between jobs right now. I had an interview today for a contract position. The first question out of the Lead DBA's mouth was:

"Can...

derek.colley (11/8/2012)

---

...

Of course, if this argument doesn't apply to DATETIME2 (rather than DATETIME) then I offer you a hearty apology and withdraw my comments.

Still a great QotD. Thank...

kuppurajdpm (11/8/2012)

---

hi

It's actually char(1) column only.I am not asking abt that.

I am asking batch processing is better or any other option will be better.

Because I am going to delete...

It shouldn't be.

Take a look at the query plans to find out what's wrong.