Also 64-bit

Thank you for your quick reply. After installing Business Intelligence Development Studio, I try to launch the DTS Package Migration Wizard. I now get an error stating that I need...

Thanks Ron!:-D

Ron,

Thank you for your reply. Attached is the scripts and sample data. Thanks for the posting etiquette, didn't know. Still getting same error. I included a screen shot also.

Thanks again

Jim

Yes I have. But I am using SQL Server 2000. Any help?

thanks

Jim

I know this is the 2005 forum, but would this work in Server 2000?

Thanks

Jim

Thanks for the info. I am doing something similar already. But you raised a question about archiving to a different server. I am aware of getting data from different db's...

Thanks for the info, yes I am using xp_sendmail and then the light went off. Different database. Go figure.

Thanks again

Jim

As it turns out, I was modifing the wrong table. This is not an issue.

Thanks for your responce and time.

It is just the one field. Now I added a new field and set varchar to 50. I can see the new field in ent mgr but in query analyzer...

In production it is

Microsoft SQL Server 2000 - 8.00.2187 (Intel X86) Mar 9 2006 11:38:51 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition...

No errors, just cant set breakpoints and see local variables.

Jim

Here is the information. Pleae let me know if there is anything else.

Thanks fir looking into this.

Jim

The RTRIM(COMMENTS) does not give me the correct results. The 'header line' that is generated by 'results to file' option is 1000 characters. But I have found a solution with...

An update. I am using XP_SENDMAIL with @QUERY. The results for @QUERY can be sent as an attachment or in the message of the email. In either case the results...