hmm... DOS/CMD instead?

for %f in (*.sql) do @osql -Sserver -E -i"%f"

This works very similarly with the ODBC .net classes instead of the OleDb classes - same GetSchema & GetTableSchema methods, same/similar result sets, etc. (been there, done this)....

The BIML engine does some of the same kind of "invisible hand" stuff that the SSIS designer does for you when you wire up objects in a data flow.

If...

I came across the Quirky Update initially just last week in one of Phil Factor's "Speed Phreak" challenges, where in the lengthy commentary regarding posted candidate solutions, someone did compare...

Re: 64-bit ACE & 32-bit Office apps...

If you install this, and you have 32-bit Office apps, it will probably mess things up for the Office apps. At least that's...

Ooops... my bcp commands should include the -c option...

C:>for /f %f in (proclist.txt) do @bcp "select text

from sys.syscomments where id=OBJECT_ID('%f')" queryout "%f.txt" -S server

-d database -T -c

Hmm... this is working for me...

c:>bcp "select text from sys.syscomments where id=OBJECT_ID('procname')" QUERYOUT "procname.sql" -S server -d database -T

Even better, if I create a text file of proc (or view,...

Yeah...but it is in here now, so just another place for the Google bots to pick it up..:w00t:

Now if there's somewhere handy with all the options for IBMDASQL... from...

Let's say the name of the linked server to the DB2 database is "IBM", and the DB2 database it's connected to is "TheData".

You can run this query to look...

Plus, now you've messed with the vendor's code. Say they push an update expecting to modify the table, but now it is a view...and the update fails. you've just fallen...

Here's some of the obscure info regarding working with connection managers in a package programmatically, to get the AcquireConnection() method to actually work:

OleDB: http://blogs.msdn.com/b/mattm/archive/2008/08/22/accessing-oledb-connection-managers-in-a-script.aspx

there's another article there too for doing...

Export to delimitted flat file, then bulk insert each file row to a table field big enough to handle each row?

It is the dynamic remapping of input & output fields in data flow tasks that bites...

Look at BIFuture.blogspot.com for C# code to add a derived column to ssis article...

The technet...

Effecting dynamic stuff like that in SSIS can be painful.

You somehow have to make the changes to the package at "design" time. Which can mean programatically creating a package ...

mailto://yourphonenumber@cellphoneprovider.com

Most cell phone companies have an email-sms gateway.

It used to be you'd hang a modem off of a box and send text to a pager number.