Almost there but....

This is the result of PRINT @tsql followed by the error

select @id = service_ref from OPENQUERY([remoteserver],'select Service_Ref from [remotedb].[dbo].[Service_Request] where service_request_number = '2'')

Msg 102, Level 15, State 1,...

Re: MessageBox.

Great tip, thankyou! I was debugging purely to see the value of a variable for each loop. I had no idea the IDE could present message boxes. It was...

Long story short... values come from a SQL task and are passed to a for each container as an ADO resultset.

Seems the paths are working after all and it was...

Sorry, ignore that. Despite me not doing anything it has decided it does not want to error anymore, doesn't need me to include any additional DLLs and is quite happy...

99% there. But now when I try to run the package (in visual studio) I get errors in the sscript. When I re-open the script all references to Dts are...

Here is what I have so far. Just need to say if File.Exists then go to FTP else skip FTP and loop

public void Main()
{
   ...

Thanks, I'm a little rusty on the script task not having used it since the DTS days

Ok I have dragged a script task into my foreach look and set it...

Sorry for the wild goose chase (and spam!) I have worked it out.

The error alluded to a path in the database but no corrosponding file on the network so it...

I've cut out the complication by doing the concatenation in the SQL so now I am dealing with a single variable for the FTP task.

My sql outputs to a resultset...

Is there a way for me to clear the value of a variable after each iteration?

Clear varible

Populate variable

FTP task using variable

Loop

I can't see a way to set it to ""...

Thanks, that' sort of where I'm heading I think but am getting lost in a sea of variables!

I have split the file path into a variable "theSource" and am getting...

I see it now thanks. I expected to see it in SSIS rather than SSMS!

I see that I can just type in there so I did.

Before A1 (spreadsheet) contained Email, First Name, Last Name....

Now it contains "Email" "First Name" "Last Name"....

What I need is:...

Unfortunately I only see CR/LF, CR, LF, semicolon, colon, comma, tab, vertical bar

Thanks, the previous headaches I've had with SSIS have admittedly been between SQL and SQL and problems with the conversion step to get the destination to accept the source string...