Viewing 15 posts - 1 through 15 (of 17 total)
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...
September 14, 2011 at 3:32 pm
Alright. Thanks, everyone. I appreciate the help.
August 19, 2011 at 8:11 am
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...
August 19, 2011 at 7:13 am
After reading responses, this is the solution I've come up with so far:
--Initialize Test Data
CREATE TABLE #Address
(
Id ...
April 29, 2010 at 1:52 pm
Garadin (4/29/2010)
Why are you against using a function?
Good question. Not against using a function, but this particular server is a 2000 with a whole host of complicated dependencies already....
April 29, 2010 at 9:04 am
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. ...
April 6, 2010 at 8:32 am
That makes a lot of sense to me. Thanks for the feedback.
March 25, 2010 at 4:07 pm
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...
March 25, 2010 at 2:28 pm
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...
March 25, 2010 at 9:01 am
Hello, after doing some more research into this, still haven't come up with a good solution. Anyone have any good ideas for this?
March 23, 2010 at 9:06 am
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...
March 23, 2010 at 8:56 am
laddu4700 (3/18/2010)
I have uploaded the screenshots...Thanks
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...
March 19, 2010 at 10:25 am
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....
March 18, 2010 at 9:22 am
What step were you able to get to in the wizard?
March 17, 2010 at 1:48 pm
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...
March 17, 2010 at 1:17 pm
Viewing 15 posts - 1 through 15 (of 17 total)