Q252987 fail -
09-02-2005
, 09:11 AM
Hi there,
I'm using WinXP Pro SP2, Access 2002, SQL 2000 Dev. IIS 5.
I created a DTS Package that will move the Northwind Customers table into MS
Access database
It's very simple and It's work fine. Also I used the DTS utilities command
line
dtsrun /Smyserver /Usa /Pmypassword /NCustomers as a bat file and it's work
fine
now I used the Microsoft kb q252987 and modify my server name uid pwd and my
dts name
when I'm running the 252987.asp file on IIS I'm getting an error that says:
Step [DTSStep_DTSDataPumpTask_1] failed
Task "Transform Data Task: undefined"
Package [Customers] failed
Done
I'm logging as Administrator and sa for sql in mixed mod.
Also in sql security I added the IIS users for public access.
IUSER and ASPNET accounts.
Could someone solved this issue ?
Thanks an advanced
Oded Dror
Email: odeddror (AT) cox (DOT) net |