Don't know (been years since I last used DTS and I've forgotten how it works!)

SQL_Surfer (2/13/2012)

---

Connection is pointing to remote server, which is configured to connect through service account.

Stored proc on remote server references a linked server to the calling server (where the package...

The ExecuteSQL task requires a connection. Where is that connection pointing?

Can you also post the full text of the error message which you are getting?

So, in SSIS, you are using an ExecuteSQL task to initiate a stored proc on a different server, is that correct?

Have you configured a connection to the other server?

If not,...

vinodoss57 (2/13/2012)

---

Hello sir,

this is vinoth. i have faced the same issue you have mentioned.I ran the query INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=c:\resource_add.xls;','SELECT...

Derived column sounds like the way to go. What do you mean "couldn't reach the target"? Can you give more detail about what you want the deriived column to contain?

You create the named ranges in Excel, not in SSIS - they are part of the spreadsheet.

It was pretty clear, to be honest.

Which bit don't you understand?

!=

The OR is the problem, I think. Try

Department == "HR" || Department == "IT" || Department == "IG"

Koen Verbeeck (2/8/2012)

---

Phil Parkin (2/8/2012)

---

Koen Verbeeck (2/8/2012)

---

That's a tautology (aka always true).

-1 is never returned by the findstring function, so this expression always...

Actually, I think...

I'm guessing that this is a simplified version of what you are trying to do - so we run the risk of my answer not being sufficient for your real...

Or configure your source comnection to use a query and bring in the name column there - that's probably what I would do.

quillis131 (2/6/2012)

---

Looking for downloading a file (.XYZ extension) from...