Excellent news! You both deserve it and I can't say I am not jealous...

Every time I see Jeff's work, I am amazed how well he understands the internals of...

Respectfully, the chair example is just wrong. You might take four tries to get the first one right, but you can easily replicate the other three chairs assuming that...

I have to agree with Steve, but I want to agree with Jeff!

We are often asked to work on something as "Priority One!". This usually means you...

Who is this Jennifer, and does she have a swimsuit layout?

I think it would be prudent to keep your tape system around until media such as DVDs get enough capacity...

I sent you a message through this site with my email address in it.

Let's start with something simple. Insert this line right before the Next statement:

Set oTransformation = Nothing

So let me understand this... Is this For loop not working? If so, what is the error message? If there is no error message, what is the...

Not necessarily. You can use the BCP utility.

Look it up on BOL. If you don't have BOL, then here is a link:

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Then why don't you just build a sql command to do this for you?

INSERT INTO DestDB.dbo.Table1

SELECT * FROM SourceDB.dbo.Table1

GO

INSERT INTO DestDB.dbo.Table2

SELECT * FROM SourceDB.dbo.Table2

GO

{And so forth}

Then you can use one...

Will the destination fields be a straight copy from the source fields with the same datatypes?

Use UNC format instead \\{server}\{share}\DATA\PT_61_DOWNLOADS\formatfile-f-c.fmt

This is tricky. You will have to read up on adjusting the DTS CustomTask SQLStatement properties using ActiveX. Or if the create table command will never exceed 255...

We have frequent network drops here. I've learned through experience that any remote file that I have to access as a source file in DTS, to always wrap the...

There's a funny behavior that I've noticed in DTS:

The same result as the ActiveX CreateObject can be obtained if you delete the Excel XLS file using the FSO...

You're right if this is, in fact, called by a sp. And also assuming he is not massaging the data with ActiveX on his transform.

It would be helpful to...