Please post the error message, if there is one.

Add a derived column in your dataflow and set it to the value of the variable containing the file name.

Then map the new column to your database column as usual.

Wow.

Even the requirement of knowing whether or not the moon is gibbous is catered for 🙂

No problem, thanks for posting back.

I see. OK - I put an ASCII 30 character into a Word document, then copied that to the clipboard, then pasted it into BIDS.

Did you try?

I just set up a source connection and it *seemed* to work.

apatel 80451 (12/16/2011)

---

I want my YTD to be summed up by Zone column YTD:

Zone 2011 YTD

Tango ...

apatel 80451 (12/16/2011)

---

Hi,

I am trying to calculate YTD totals for the following data, at the moment I'm getting a varchar field for my date e.g. '201101'. I will therefore be...

Roughly how many integers are going to be held in the variable?

If you persist with this approach, then one way or another you're going to find yourself looping. But maybe...

The wording in your question demonstrates that you know the answer, as far as I can see.

Have you considered Cozyroc software? It includes a dynamic data source component, from what...

Powichrowski Marek (11/28/2007)

---

It is not good practice to issue SELECT * FROM statement (btw it can take the long time for the huge table). I think the best way...

The question was about remote users, not remote data sources.

For future info.

With the simple stuff, you should find it's faster to Google and use what's already been written than writing out a post and waiting for people to respond.

herladygeekedness (12/12/2011)

---

Can't use a script task, this is in the data flow. I cannot just update or merge join.

Specifically, I have payments that must be attributed to...

That's not a link. This is a link

😛