sun8426
June 25th, 2008, 01:30 PM
hi,
I just join this company. We use a set of stored procedure import data and dts to export to text files to each month for several companies. I would like automatic that process if I could since I will be the one to do this task each month. I just found this dtsrun command from google search... after looking at the syntax, I have some questions for those who had done it before... How do I pass into the source file and destination file info.? Could someone give me good example of it? thanks.
sun8426
I just join this company. We use a set of stored procedure import data and dts to export to text files to each month for several companies. I would like automatic that process if I could since I will be the one to do this task each month. I just found this dtsrun command from google search... after looking at the syntax, I have some questions for those who had done it before... How do I pass into the source file and destination file info.? Could someone give me good example of it? thanks.
sun8426