So that’s a picture of my headache for today … importing 100GB of shit from an Oracle database into a SQL 2005 database.
Oracle scares the bejesus out of me, and although I’m OK with SQL, I’m new to SQL 2005. 
No amount of whining was going to get me off of this project, so … I’m pretty much praying to the gods that this little SQL wizard keeps right on trucking… (oh please oh please oh please) 
SQL 2005 works very well pulling data from Oracle, if things are setup correctly. SSIS is way faster than DTS, at least on a x64 install of Windows and SQL 2005.
Oracle (PL/SQL) can be annoying when you are used to SQL (T-SQL) though.
SQL DROP TABLE * works great
LOL @ John. I still love this job, so I won’t do that.
@ Michael, we’re still 32-bit for most things here, but the import process was still a lot quicker than DTS. Well, up until the drive filled up. Apparently data takes up more space in MSSQL land? It was an ISCSI drive, so easy enough to expand.
Yeah, some of the equivalent data type is SQL are larger than the Oracle counter part. (Either that or Oracle does compression on some of the data.) SQL 2005 does have an option to compress some data types as I recall, but we haven’t used it yet.