Koen Verbeeck (12/12/2011)

---

Elliott Whitlow (12/9/2011)

---

Wow, thats an interesting request.. I question the methodology but ok..

I would use a data-flow task. The rows are generated by a source and...

You can use a script task (in the data-flow it would be considered a script-transform) to take in fields and execute OleDB queries against another connection. It really is...

Hm, have them reboot their desktop..

CEWII

Wow, thats an interesting request.. I question the methodology but ok..

I would use a data-flow task. The rows are generated by a source and a script transform does...

Personally I like the scheduled job idea.. Toggle their access on and off automagically..

CEWII

Well shoot, last time I had to do this those steps fixed it for me..

Re-apply service pack? I know its reaching, but my toolbox for this empty..

CEWII

Your welcome, glad to help.

CEWII

At first blush I wold probably use a normal flat file source but use a script transform. I try not do use Script sources as much as I can...

So true.

CEWII

richj-826679 (12/9/2011)

---

GilaMonster (12/9/2011)

---

I've worked with someone in the past who insisted on everything in her job responsibilities be written down and spelled out exactly with no 'and other duties' listed....

You probably need to copy the files not to

C:\Program Files

But to:

C:\Program Files (x86)

CEWII

michael.french 172 (12/9/2011)

---

FTE does not always translate into more stability. The last three years has taught us that.

Furthermore, just because you have a contract does not mean that they...

I'm not 100% convinced you need to use a script task to do this.

Why don't you explain your needs and we'll help you with a solution as opposed to trying...

sqlfriends (12/8/2011)

---

Thank you, in this case it is not actually a data warehouse ETL, it is just regular database daily upload.

But we need to load data in domain tables...

Yes, unlike DT_STR where a codepage is specified that is why it only specifies length. We force it to DT_STR using the advanced editor.

CEWII