Just wanted to post back to let folks know what the resolution was for this.

As it turns out, the expression evaluation was resulting in a string > 4000 characters, which...

Alright. Thanks, everyone. I appreciate the help.

Thanks for the replies & suggestions. Makes sense to me that in a solution where we're wanting to update the config value that a SQL table would be a...

After reading responses, this is the solution I've come up with so far:

--Initialize Test Data

CREATE TABLE #Address

(

Id ...

Good question. Not against using a function, but this particular server is a 2000 with a whole host of complicated dependencies already....

The answer to your question is yes; it just depends on how you want to do it.

One straightforward, but clunky option:

Set up one data flow with one data source. ...

That makes a lot of sense to me. Thanks for the feedback.

There are probably a lot of ways to do what you're wanting to accomplish. The guys who have posted here are much more experienced than I am, so I'm...

If you haven't run the batch job manually on the server, I would suggest you do that. The issue you may be having is the SFTP requires a host...

Hello, after doing some more research into this, still haven't come up with a good solution. Anyone have any good ideas for this?

I use an ODBC driver, but this article seems like a good one for explaining how to connect to a MySQL db.

http://www.ideaexcursion.com/2009/06/04/howto-connect-to-mysql-in-ssis/

Post back to let us know if it worked...

Looks like the package is executing successfully, except for saving the SSIS, which is what you want, so you can look at how it packages...

I would import the text file as a single-column, ragged right flat file source. Then, use the "Derived Columns" transformation to parse out the row and create your columns....

What step were you able to get to in the wizard?

The nice thing about doing the export using the SQL Server Export Wizard is that you can save the export as an SSIS package (it is one of your options...