dbTalk Databases Forums  

Q252987 fail

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Q252987 fail in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Oded Dror
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.