Microsoft took an intuitive, easy-to-use tool (DTS), and turned into a needlessly complicated, buggy disaster called SSIS. I believe Microsoft has completely lost touch with who their customers really...

This is my biggest problem with 2005.  They took an extremely intuitive product (DTS), and Microsoftized it.  By that I mean they added a boatload of features (most of which...

I think Microsoft really dropped the ball with SSIS.  They took an easy-to-use and very intuitive product, and turned it into a needlessly complex nightmare.  Primarily because of the SSIS...

SQL 2000 is meeting our business needs, and after taking a look at SQL 2005, I see a ton of work in re-engineering DTS packages into SSIS (it would seem...

I finally threw in the towel, and added an output parameter with the return code, because I already have code that works to get a value from an output parameter.

One...

Does anyone have an example that is vbscript, not pure vb?  All the examples I find are vb, and nothing I'm trying is working.

Well, in this particular case, I'm talking about a quasi-data warehouse that gets refreshed each week using bulk loading processes.  During the week, it just gets queried, with no updates...

I have had enough strange problems importing from Excel, that I no longer do it.  I save the Excel sheet out as a tab-delimited text file, and import from that.

Thanks!  How does this compare to using the Oracle Instant Client?

I use "Professional SQL Server 2000 DTS", but mostly as a reference rather than a manual.  It's a decent book.

It seems putting all of these steps in a DTS package, and then scheduling it is the way to go.  Perhaps the only problem might be if the ERP application...

Well, I think my response to this would be similar to another response I just posted.

I don't think you could do this all in one step.  Nor would you want...

Well, I don't see a way to do this in one easy step.  So, I would load the AS400 data into a staging table.

From the staging table, you may need...

I'd like to suggest that in your Plan A, you not only copy the backup files to a test server, but you take the additional step of restoring them on...

If these strategies don't work, you could export the data to another table, drop the table, re-create it with the column defined the way you want it, then copy the...