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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-20 : 07:32:39
|
| Ashok writes "Hi,When I use DTSRUN command in NT batch script to load data from a flat file into a table in SQL SERVER 2000, I get the following error message:DTSRun: Loading...Error: -2147220438 (8004042A); Provider Error: 0 (0) Error string: The specified Storage File contains multiple Packages; Loading requires a Name or Guid. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 704Error: -2147220438 (8004042A); Provider Error: 0 (0) Error string: The specified Storage File contains multiple Packages; Loading requires a Name or Guid. Error source: Microsoft Data Transformation Services (DTS) PackageFor now, I got around this problem by deleting the existing Structured Storage File and creating the SSF again. PLEASE NOTE THAT I DID NOT MAKE ANY CHANGES TO THE DTS PACKAGE.But, I would like to know the exact cause of this problem.I am using SP3 for SQL SERVER 2000.Thanks for your time,Ashok" |
|
|
|
|
|
DTSRUN error in NT batch script