Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: IanMackay123
- Order by date
-
DTS schedule not kicking in
Hi, I have a bunch of repeating DTS packages in SQL server 2000 that I have set to run once every day. When created they run fine on immediate execution, but they do not repeat the execution after this, even though when I right click on them and select "Schedule" the supposed schedule shows up...- IanMackay123
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Data Transformation Services
-
DTS Date Formats
Ah, hang on, I've found the query builder section now - I'll have a crack at that. Thanks for the help! Ian- IanMackay123
- Post #4
- Forum: Microsoft SQL Server: Data Transformation Services
-
DTS Date Formats
Sorry, I don't think I have the option of looking at the SQL queries (or I don't know how to...) I'm using SQL server 2000 and have set up a recurring DTS package through enterprise manager DTS import/export wizard. This creates a package in DTS/local packages, but I don't see how to actually...- IanMackay123
- Post #3
- Forum: Microsoft SQL Server: Data Transformation Services
-
DTS Date Formats
Hi, I'd be really grateful if Someone could help me with this: I have two tables, each with Datetime and boolean fields. I've set up an automated repeating DTS for each table to output the data into CSV files. When I check the CSV files in notepad the dates and Booleans are output in...- IanMackay123
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Data Transformation Services
