-
Can you help with DTS pakage?
Hi,
In our travelinsure1 database, I used DTS to create a package which needs to run on a daily base.
The major task is import data from a text file to a database (CMC_test) table tis_StudyUSA_dataEase_test.
But before I do the import, I need to flush the data in tis_StudyUSA_dataEase_test.
So I need to execute" Delete from tis_StudyUSA_dataEase_test" then the import.
But I just don't know how to set up in DTS package to let this statement run first, not after the import.
Otherwise it will just have empty table.
I just start to learn how to use DTS. Any clue will be very helpful.
Betty
-
You can create two tasks in the package, one for truncating table and the other for loading data. Then click on truncate table task, holding shift key while click on data loading task, and choose on success from workflow. That will generate workflow from truncate table task to data loading task.
-
Thank you for the quick response
rmiao,
I tried, it is successful.
I tried to enable the package execution log. So Later on I can look at the log file to see if the import is successful or not.
When I clicked on package logs, it comes up a window:
DTS package available on the travelinsure1 server
on the drop down list, it is empty and it won't let me input anything and I cannot see anything on
DTS package versions and log tree.
What's going on?
Thank you.
Betty
-
I think I get it, please confirm
hi,
base on server book on line.
it states that
"Package logging is only available on servers running an instance of SQL Server 2000".
My testing database is runing on an instance of MSDE.
Probably that's why. Right?
Betty
-
You log to file? Did you run the package yet? Did you find log file with windows explorer?
-
yes, I ran the DTS package already
Rmiao,
What will be the default name for the log so I can search it.
I didn't set anything.
-
You need specify log file name when you enable package logging. By the way, how did you enable logging?
-
I didn't create DTS package directly. In DTS, I first select all task and import data and then save this import data action as DTS package. I Don't remeber exactly I did see somewhere ask me if I need to log it or not. I probably did n't choose to do anything. But now in this DTS package, it seems there is no
where I cano choose to log it any more. I will give one more try again.
Betty
-
You can enable logging by editing the package and go to package -> properties -> logging tab.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|