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

😛

Thank you Howard!

Cadavre (12/12/2011)

---

Phil Parkin (12/12/2011)

---

Thanks, but that returns the current user - not quite what I am after.

I want the name of the user which is running the SQL Server service...

Thanks, but that returns the current user - not quite what I am after.

I want the name of the user which is running the SQL Server service for the particular...

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 a script...

Is there a longer error message available?

Does the package ever fail when run in Visual Studio?