a full backup and restore it the only working option.

A backup and restore wipes out too many things. permissions and so forth.

I...

I just wanted to copy the database to another server on a regular basis because right now SQL 2000 DTS packages are loading the data. I need to...

ok, nobody has responded, so I thought I would add to this pain in my ..... I have 2 dev servers, one is a 2000 server, another...

dont put the files in the database.    save all the files in a directory(like a FTP Directory), and put a PATH of the files and the name of thes in...

using active x put the date 8-8-1999 format in a variable, do a replace of the - to / .  next do a isdate on the field.  if it passes...

thanks!

I would be very interested in the code that executes the packages from an ASP page.   Can you inculde the steps leading to the actual execution of the package?

Great thought!  It cleaned up my code in a massive way, and made this problem go AWAY!   And I learned (again) that there is always a better way!  Now on...

Ok, I changed it so I dont need the double quotes, made every single quote, however it is giving me this error now.  It looks like the string is being used...

if only it was so easy.

As you can see I have single quotes for the fake column I am creating for the SOURCE field.    I can execute the single statements

select...

I tried that in the many versions of this SP and when I do the SET .....OFF and the SP loads fine, but I get this error message.

Server: Msg 203, Level...

that much I know.  how do you sugest I create the query in the begin / end loop?

I thought I figured it out!   As of matter of habit I create SP with the following lines in the begining

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

When I commented out...

when you create source text from a table in the dts package, and you select the destination tab, you should get a window that says DEFINE COLUMNS.  At that point...

ok, i'll bite.....what is openquery?  where do I find this, and what does it do?