Found alternate way to do the same thing as word wrap -- control + enter. For anybody who is interested in the same thing.

Cheers SQL Crew...

Thanks,

Issue resolved -- I was able to import the file into SQL 2000 once my IT guy provided me with the correct connection driver.

Thanks,

No it was simply typed in no expression -- Thanks for your response but I just resolved the issue by creating a new connection manager object. I guess I...

Thanks,

Hi Gyanendra,

I appreciate your perserverance. What I have done is in the configure Error option of the flat file source object I have set the offending fields...

I tried the derived column suggestion but the failure actually takes place in the insert of the text file in the flat file source object. Most of the file...

Hi gyanendra

I tried what you said with the truncation ignore but I still got the same error. How do you trim when using the flat file source object?

Appreciate the...

The first issue appeared to be with my source files being imported with different delimeters than what was expected by the package -- Resolved.

I have a new issue now and...

Thanks Michael,

I appear to have something to work with now -- I will let you know the outcome.

Cheers,

Thanks RP

Appreciate the response Gila... I was hoping there was some new short cut available I currently use the method you suggested.

Cheers,

Thanks very much -- I didn't realize the Varchar(max) was the same size as Text column this in itself resolves my issue.

Actually the code is -- select distinct * into table_remove_dups from table_A

so I have several fields and want to make sure all are unique with out duplicate values but one...

Thanks all this is exactly what I needed -- apparently I didn't have correct permsissions -- no wonder I couldn't find it.

Cheers,