Can you post the text of the error you are receiving?

Try using the inserted table.

I do not think that Ian was taking the **** with his 'strange requirements' comment, just helpful.

ram_kamboz2k7 (2/14/2012)

---

EXEC xp_cmdshell 'bcp "SELECT * FROM TM37_1_2_ONLINE.TM37_1_2_ONLINE.dbo.USERS" queryout "C:\BMW\tsqloutput\gradfive.txt" -T -c -t,'

Well I have changed it around and seems to come up with the same errors.

The users table...

ram_kamboz2k7 (2/14/2012)

---

declare @path varchar(2000)

set @path = 'C:\'

EXEC master.dbo.xp_create_subdir @Path

I have created a directory first and foremost.

EXEC xp_cmdshell 'bcp "SELECT * FROM USERS" queryout "C:\gradfive.txt" -T -c -t,'

I want the...

SQL_Surfer (2/13/2012)

---

Another thing to note is that DTS uses a sql login but SSSI uses a service account. But that still doesn't explain why it wouldn't error out (can't find...

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"