navecomp (2/22/2011)

---

what I'm trying to implement is to be able to load certain columns from a flat file which is tab delimiter dinamically, I don't need all the columns from...

Craig Farrell (2/22/2011)

---

Koen Verbeeck (2/22/2011)

---

Craig Farrell (2/22/2011)

---

I assume you've dropped it to a Recordset Destination? The short answer is: you can't, not easily.

You create a foreach loop (the way...

I've done the MCTS BI exam in November 2010 and the MCITP BI exam this January, and I didn't notice anything abnormaly difficult. Maybe different region equals different questions?

Maybe there is a blocking issue because you are updating and inserting in the same table at the same time, while one of the processes has a table lock?

Check the properties of the connection manager. There is a property ConnectionString. Look into that one, it normally has the provider listed.

Craig Farrell (2/22/2011)

---

I assume you've dropped it to a Recordset Destination? The short answer is: you can't, not easily.

You create a foreach loop (the way that's built in to...

Let's just conclude that the question could have been phrased better 🙂

george sibbald (2/22/2011)

---

Koen Verbeeck (2/22/2011)

---

That is not true.

Not in Primary is the same as saying: on every server that is not the...

I'd argue to give the ETL team read...

They are called "client" tools for a reason 🙂

Does the contractor have a real valid reason to go sit before the server and do some work with SSMS and BIDS?

What...

Yes, if you have a large production environment with over 100+ packages, good luck with opening them with notepad to change the provider, every time you want to deploy them.

You...

Phil Parkin (2/21/2011)

---

Koen Verbeeck (2/21/2011)

---

If...

Phil Parkin (2/21/2011)

---

You are correct. But bear in mind that the person posting the question was an ultra-newbie and your advice was directed at them, not at an experienced user....

That is not true.

Not in Primary is the same as saying: on every server that is not the primary server. This could...

Nice easy question, thanks.