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!
-
DTSRun.ext Failed to initialize
Yeah, if I re-create the exact same DTS package with the same id and password, it works. It's so strange...- xwbh
- Post #5
- Forum: Microsoft SQL Server: Data Transformation Services
-
DTSRun.ext Failed to initialize
Yes, I can truncate the table.- xwbh
- Post #3
- Forum: Microsoft SQL Server: Data Transformation Services
-
DTSRun.ext Failed to initialize
Help! My DTS package all of sudden failed to run (It has been running well for two years.) When I tried to initialize it manually, I failed in the first step, which is to truncate table. The error message says "only dbo or a member of sysadmin role has right to truncate a table."...- xwbh
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Data Transformation Services
