Last place I was at we just used Putty and executed it in the job. Worked just fine. You do have to install Putty and the keys locally...

What data type is the field? It almost looks like a rounding error.

Thanks. Looking for \r did the trick.

And not mixing up what goes where in the FINDSTRING didn't hurt either. ~facepalm~

I did this using the brute force method of multiple tables.

1. Copy existing table into 'new' table (yesterday's data)

2. Update the main table (today's data)

3. Run T-SQL to compare the...

Thanks. Got it back.

I'm working on a remote box and have had other odd issues. I'll keep this in my toolbox of fixes. ~sigh~

I'm not a guru but have suffered through the same learning curve you're hitting now.

You can't think of SSIS in the same way as DTS or T-SQL. It just...

Seems to be a unicode text file.

The location would change based on the connection manager information at the job step.

The DBAs would then have control over which servers send mail from a process without having to...

I must not have been clear. I don't want to set the location with a variable. I want to use the location in the connection string as a...

Sweet. Nothing that I need to worry about then.

Thanks for the quick response!

OK - here's the short answer on how I did this.

Create a Derived Column transformation, create a new column, and put this in the expression field. Use your own...

Sorry to revive an old thread but I'm having the exact same problem and didn't see that a final 'Hey - this worked!' was posted.

I double-checked all my data and...

Enclose them in square brackets and SQL syntax won't format them blue.

I fell prey to one of my most common failings here - overexplaining what I want to do.

In the most simple terms, I want to set a variable value within...

The first thing I do when I have to shepherd someone into the strange and wonderful world of writing SQL code is force them to turn off whatever GUI they're...