Thanks, Steve.

I tested INSERTs with both VARCHAR & your DATETIME convertion into my DATETIME field and the results are the same. So I guess it doesn't matter.

Thanks Markus and Steve! You guyes are great! That works!

But since @mydate is declared as varchar(20), can I still INSERT it into a TABLE's field that is defined as DATETIME?...

Sorry, but in the DATA...

I found the matching format in the Data Conversion Tool and my limited test worked.

Thanks for the hints. I have A LOT to read since I'll receive no format training/classes.

I'm...

I'm trying to use the Data Conversion Tool and no matter what i select I get an error such as this:

Validation error. Data Flow Task: SQL Server Destination [1060]: The...

Modifying the DESTINATION COLUMN is NOT an Option

The data comes from an EXCEL file that gets created. It was previously being IMPORTED into SQL2000 via DTS. I just need to...

Thanks, Alan.

But what do I do about

Now I'm getting CONVERSION ERRORS that I did NOT get in SQL 2000

"CANNOT BE INSERTED BECAUSE THE CONVERSION BETWEEN TYPES DT_R8 AND DT_I4...."

Also, should...

Trust me, I've been Googling and playing with BIDS. I've gotten a little further.

Now I'm getting CONVERSION ERRORS that I did NOT get in SQL 2000

"CANNOT BE INSERTED BECAUSE THE...

I'm trying to work in BIDS.

How do I SKIP HEADERS of the EXCEL FILE?

I'm also getting a conversion error (DT_R8 & DT_14) or is that because of the EXCEL COLUMN...

Correct, SSC is a great resource. As is the Web. I've been looking at both and am overwhelmed.

I guess I have to use SSIS or BIDS to build, modify...

Thanks Shawn.

I've gone thru some tutorials and created a Package via BIDS.

If I create a Package via SSMS and save it, what UI do I use to view it's properties,...

Lynn / Gail

thanks very much for the quick response. I've already made the change!

This is frustrating. To this novice's mind, I can NOT DENY a User's or Database Role's ability to DROP TABLEs if I GRANT them ALTER (which appears to be needed...

Here are the results from your questions:

serverCONNECT SQL

serverVIEW ANY DATABASE

databaseCREATE TABLE

databaseCONNECT

In the meantime, I'm doing a slow process of trial and error.

The User is a member of a Database Role...

I seem to have read, too, that a DENY will NOT OVERRIDE a Fixed Server Role Permissions. But, for the life of me I can not find the Microsoft MSDN...