When I was was consulting in State government, my manager was enthusiastically nontechnical. I think that he looked at the database as some magical construct from which I apparently...

I was a VB developer for a long time before I began working with T-SQL (and PL/SQL for that matter), but I've yet to find a need for CLR usage...

If you know the fields into which the file is to be parsed, you can use a derived column transformation to validate field contents for type, range, domain, etc. ...

I regularly read the blog of John Halamka, the CIO of Harvard Medical School. Just this week, he posted about taking an un-wired vacation as CIO: http://geekdoctor.blogspot.com/2008/08/connectivity-holiday.html

Sadly,...

While I am of the opinion that what I do in my non-work time is none of my employer's business, I am not so naive as to think the world...

I'm DIY in some areas, and leave others to the pros. I worked summers for a painting and papering contactor in high school, so I picked up a few...

If you have the freedom to add a component to your flow, you might try using the Row Number Transformation, a free component from Konesans (http://www.konesans.com/rownumber.aspx).

In my experience, those who refer to anyone in the hardware and/or software industry as an "IT guy" simply don't understand exactly what it is we do. I've never...

Unfortunately, the 'Keep NULLS' option only applies on an OLEDB destination, not an OLEDB source. That would work going flat file to db, but not db to flat file....

If you want the text 'null' to appear instead of an empty output field, you could send each column through a derived column transform: ISNULL([SomeField]) ? "null" : [SomeField]

If necessary, you could follow the Execute Process task with a File System task to move and/or rename the file. The source and destination paths can be mapped to...

One way that you can control the output location of the file is by exposing the connection manager behind your output flat file as a value in a configuration file....

There's a post about this on the mysql forum that may help:

http://forums.mysql.com/read.php?37,94800,190727#msg-190727

It looks to me like some of the ODBC errors I used to see at a former position. Have you verified your connection string or DSN that you're using...

In our shop use 7-zip (http://www.7-zip.org/), which is a freeware zip utility with command line support. It will likely do what you need if you don't already...