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 strongm 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: SFreilinger
- Order by date
-
SQL 7 DTS - Network Resource
OK, I have read a bunch of stuff around this and thought I had it figured out. Here is what I have I have a non-sysadmin user (User1) running a Scheduled Job. User1 is the owner of the scheduling job (so he can see it). The Scheduled job kicks off a DTS Job that is owned by a second user...- SFreilinger
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Data Transformation Services
-
SP to kick off a DTS??
Don't have that one either. Now, I do have SQL 7.0 and am using MSDE for development...if that makes a difference.- SFreilinger
- Post #9
- Forum: Microsoft SQL Server: Programming
-
SP to kick off a DTS??
Was the following ever answered? "I tried your code but its looking for sp_displayoaerrorinfo which it can't find. Is this your own procedure?" - osjohnm I am having the same problem. -Shawn- SFreilinger
- Post #7
- Forum: Microsoft SQL Server: Programming
-
Setting up a Proxy account
I have a similar situation but I have SQL 7.0 (currently doing development with MSDE). I have unchecked "Only users with sysadmin..." under Non-SysAdmin job step proxy account, but I do not get a box that indicates username and password. Details of my situation: I have saved a dts package as a...- SFreilinger
- Post #4
- Forum: Microsoft SQL Server: Programming
