Hi, thanks again for your information.

How can I overcome the problem if you do not know the column name where the datepart resides in the selected table. For example I...

Thanks again for your info.

I have another question - how can I pass to the construct above different table names and process them as described above. The table names will...

Thanks for your reply.

Question - what is the correct syntax to pass over a parameter to a stored procedure in the window of an "Execute sql task" in DTS?

e. g....

Thanks a lot for your input - it works well!

By implementing it the question was raised what happens if bcp fails and data is not extracted and deletion of...