It is possible, but I'm not going to write the code for you - unless you want to hire...

How many files are we talking about and also how many different layouts?

Multiple data flows (one per file type) is one way of handling this.

Another is to send all of...

Please explain what you mean by this.

In general, for every different file format, you will need a separate dataflow. Multiple files with...

Can you explain in more detail what do you mean by this bit please?

Scott Coleman (2/6/2014)

---

I was just making the observation that the original post did not say where the data was coming from or where it was going. However clever the...

You seem to be...

battula.ramu6 (2/6/2014)

---

When I use calculation in generating reports, I get Nan,#Error,Infinity values in preview , I wanted to avoid this and display " " if the result of calculation...

chetan.deshpande001 (2/6/2014)

---

Would it be ok for you to use recursive CTE ? ..something like

--Edit

I'm sorry for the formatting/colors ..as this is my first post and do not know how...

Certainly a good opportunity for you to learn. I am no PoSh guru by any...

martin.hock (2/6/2014)

---

Hi Phil,

27 at the moment, number increasing.

The most comfortable solution would be a table stored on a master server, from where the batch file fetches all information, which packages...

Out of interest, how many...

I tried the UNPIVOT transformation for this problem and after pratting about with it for a while in an attempt to make it work, I have come down soundly on...

Evil Kraig F (2/5/2014)

---

Phil Parkin (2/5/2014)

---

+1 to Lempster's answers, I agree with them all. Though I would more strongly recommend using the project model in 2012 - been using it...

+1 to Lempster's answers, I agree with them all. Though I would more strongly recommend using the project model in 2012 - been using it for about a year and...

Can you post the T-SQL of the query from your ExecuteSQL task please?