Is your database recovery mode in Simple or Full? check the database properties using EM. If simple, changed to Full, otherwise the truncate might not work. When using the script...

Thanks, I know, I know and that's exactly what I am doing today!!

You are absolutely correct, no disrespect but sometimes .... Enough of that. It seems, so far, that the solution given by Frank worked for them. I talk to one of...

Sorry guys for not being clear enough. What happen is that the stored procs are use in a data base, but insert data into a different one. That is why...

Thanks Frank, I will try. What I don't is to hard code the database name to allow any of my stored procedures to run regardless of the database to be...

Hey Phil, how are you? Are you using SQL Server 2000? If so, the best way is to use DTS. If want to import a table (not necessary to be...

if you are rebuilding the table you might use a step to truncate or delete the records in the table before you run the stored proc. With an empty table...

I got the same issue with some packages. When you tried to go to the transforamtion tab is when SQL Server hangs or closed? That was my case. I ended...

Thank you for the iput in this matter. I read a little more, test a few things and it seems to be working as I needed. Please consider this item...

Thank you for the iput in this matter. I read a little more, test a few things and it seems to be working as I needed. Please consider this item...

I think the best way to do this is to create a DTS job. This will allow you to run the package everyday or as frequent as you might need...

Phil,

That's is exactly what I need. Set up the global variable, so they can save it and use it as they need. I will be sending the package and they...

Running sql server 2K? I had a similar problem with one machien and we reaplied SP3 and it fix that issue. Maybe this could help, good luck though.