Hi,

I took that little code snippit out of my dts package.

What to do with those records with bad data? That's the question.

I assume you don't want to just...

Is there somone there FoxLiterate who can help? You are right about deleting those foxpro rows. Once you delete, you have to issue a "pack" command. That really honest to...

Woops,

Maybe if I re-read my ramblings before posting them....

Actually the isdate() verifies something as being able to be converted to a date. The range only applies if you are...

Hi,

Well darnit, this has happened before. I type a long reply answering every question you will ever have; complete with code snippits, URLs and animation. But I click the "Post...

Hi,

I think someone asked almost this same exact question on Wednesday of this week. Someone posted a possible active-x solution. If you are getting the daily emails for this group, check...

Hey,

Ok, this is the last thought for this week. I don't do any thinking on the weekends.

I have done this before so check it.

Sort your packages by date and check the last...

Hi,

Another thought. (I only get them one at a time)

You might check to make sure you are a user with all the appropriate rights on the MSDB database. I'm not sure...

Oh, you mean where does it go physically?

 I found this on Books On Line:

If you save to SQL Server, the DTS package goes into the sysdtspackages table in...

Hi Dana,

You might go back an look for that package again. I have found that SQLServer is sometimes pretty bad about that whole "What you see is what you get"...

Grant is right, you will need to check that "Enable save to Meta Data Services"

In my case, there was also a rights issue; maybe related to SP3 as noted above....

It occured to me that if you DID want to just check for the existence of the .XLS file, you wouldn't want to use that DOS mess. You would want...

Hi Victor,

The short answer: I don't know.

The Long answer: If you want to check for the existence of the .xls file, you could probably use that 'if exist' syntax in...

Someone on this site posted this solution a while ago. I copied it for possible future use but never tested it so I don't know if it actually works or...

Hi,

You may already have your solution. But, if you can get the

abc-2004-04-10.txt  in a folder by itself you could just copy it to a file with a

static name...