Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
silvershark
Starting Member
48 Posts |
 Posted - 2006-11-13 : 12:52:24
|
| I am using a product called CounterPoint. It is a inventory control and tracking program. When I try to import the .csv files with the data it will not import because it thinks the DTS file is missing. It is clearly there.Step Error Source: Microsoft Data Transformation Services (DTS) PackageStep Error Description:The system cannot find the file specified. (Microsoft Data Transformation Services (DTS) Package (80030002): The system cannot find the file specified.) (Microsoft OLE DB Service Components (80030002): The file could not be found.)Step Error code: 80030002Step Error Help File:sqldts80.hlpStep Error Help Context ID:1100This is the command I am using.Command: "D:\Program Files\Microsoft SQL Server\80\Tools\Binn\DTSRun.exe" /F "D:\CounterPoint\System\Upgrade\Accounts.dts" /L "C:\CPUpgrade\Logs\Accounts.txt"Thanks for any help you can provide. I have tried uninstalling SQL and the CounterPoint product as well as removing all folders/files that are left are uninstall with out any avail. |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2006-11-13 : 15:47:15
|
| Where are these drives? Are D & C both on the server or your local machine or a mix? Where are you trying to run this? From the server or from your local machine?Mike"oh, that monkey is going to pay" |
 |
|
|
silvershark
Starting Member
48 Posts |
Posted - 2006-11-15 : 17:17:41
|
| I am trying to run this from the server. MSSQL is located on Drive D as well as CounterPoint. The c:\CPUgrade\Logs\Account.txt is a default setting. Maybe I just need to repartition my harddrive or use Partition magic and make my C drive my D drive and my D drive my C drive like it normally should be.Right now my boot drive is D instead of C due to a dumb mistake a long time ago, and I have been too lazy to fix it. |
|
|
|
|
|
|
Importing .csv files and DTS error.