<div>
Thanks acperkins<br />
<br />
Okay, xp_cmdshell is no enabled and the DTS runs BUT now I am geeting an error saying login failed for datafile. &nbsp;There isn't any login required to get to the file. &nbsp;You can browse to the file with IE from the SQL Server machine. &nbsp;You can execute the package through the 2000 Designer with out any issues. &nbsp;Only get the error for file access when executing through the xp_cmdshell &nbsp;The DTS package Drops and Creates a temp table, reaches over the network and grabs a flat file to import into the newly created table. &nbsp;Below are the results of the dts run.<br />
<br />
DTSRun: &nbsp;Loading...<br />
DTSRun: &nbsp;Executing...<br />
DTSRun OnStart: &nbsp;Drop table [deal].[dbo].[Temp230] Step<br />
DTSRun OnFinish: &nbsp;Drop table [deal].[dbo].[Temp230] Step<br />
DTSRun OnStart: &nbsp;Create Table [deal].[dbo].[Temp230] Step<br />
DTSRun OnFinish: &nbsp;Create Table [deal].[dbo].[Temp230] Step<br />
DTSRun OnStart: &nbsp;Copy Data from 230 to [deal].[dbo].[Temp230] Step<br />
DTSRun OnError: &nbsp;Copy Data from 230 to [deal].[dbo].[Temp230] Step, Error = -2147467259 (80004005)<br />
&nbsp; &nbsp;Error string: &nbsp;Error opening datafile: Logon failure: unknown user name or bad password.<br />
&nbsp; &nbsp;Error source: &nbsp;Microsoft Data Transformation Services Flat File Rowset Provider<br />
&nbsp; &nbsp;Help file: &nbsp;DTSFFile.hlp<br />
&nbsp; &nbsp;Help context: &nbsp;0<br />
Error Detail Records:<br />
Error: &nbsp;1326 (52E); Provider Error: &nbsp;1326 (52E)<br />
&nbsp; &nbsp;Error string: &nbsp;Error opening datafile: Logon failure: unknown user name or bad password.<br />
&nbsp; &nbsp;Error source: &nbsp;Microsoft Data Transformation Services Flat File Rowset Provider<br />
&nbsp; &nbsp;Help file: &nbsp;DTSFFile.hlp<br />
&nbsp; &nbsp;Help context: &nbsp;0<br />
DTSRun OnFinish: &nbsp;Copy Data from 230 to [deal].[dbo].[Temp230] Step<br />
DTSRun: &nbsp;Package execution complete.<br />
NULL
</div>


<div>
Thanks nmcdermaid but I need a little more clarification. &nbsp;I inherited this site with no documentation so I'm a little in the dark.<br />
<br />
I checked the log ons and both sign on with &quot;.\MSSQL_USER&quot; &nbsp;- the 2000 Server that I'm imgrating from used &quot;.\Administrator&quot; for the server and &quot;Local System Account&quot; for the agent. &nbsp;Question, why does it work using the DTS 2000 Design Tool &nbsp;but not in the xp_cmdshell? &nbsp;The logons are different? &nbsp;<br />
<br />
Thanks
</div>


<div>
&gt;&gt;The logons are different?&lt;&lt;<br />
Yes.<br />
DTS 2000 Design Tool: Uses you login account.<br />
xp_cmdshell: Uses the SQL Server service startup account. If that still ahs the default Local System Account, that would explain the problem.
</div>


<div>
<div class="content wysiwyg-content">
I imported 50 DTS Packages from SQL 2K to SQL 2K5. &nbsp;The packages are now located in the &quot;Legacy&quot; folder. &nbsp;I have the 2000 DTS Design tools installed and now can modify/execute the package. &nbsp;The question, what modifications, if any, need to be made to the line below to execute the DTS package.<br />
<br />
EXEC master..xp_cmdshell 'dtsrun /Slocalhost /NDTS230a /Usa /P*********'<br />
<br />
Also, as a test I &quot;migrated&quot; one of the packages in the Legacy folder to what I thought would be the SQL 2005 version of it. &nbsp;It ran successfully but have no idea where it is, how it is now stored, or how I can modify it. &nbsp;I thought it might create a *.dtsx file, I did a search for the file but it didn't exist. &nbsp;If I try to migrate the same DTS package it comes up that it already has been migrated. &nbsp;Need Help Badly.<br />
<br />
Thanks in Advance
</div>
</div>


I imported 50 DTS Packages from SQL 2K to SQL 2K5.  The packages are now located in the "Legacy" folder.  I have the 2000 DTS Design tools installed and now can modify/execute the package.  The question, what modifications, if any, need to be made to the line below to execute the DTS package.

EXEC master..xp_cmdshell 'dtsrun /Slocalhost /NDTS230a /Usa /P*********'

Also, as a test I "migrated" one of the packages in the Legacy folder to what I thought would be the SQL 2005 version of it.  It ran successfully but have no idea where it is, how it is now stored, or how I can modify it.  I thought it might create a *.dtsx file, I did a search for the file but it didn't exist.  If I try to migrate the same DTS package it comes up that it already has been migrated.  Need Help Badly.

Thanks in Advance

Run a 2000 DTS Package in SQL 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.