I get the following err # and err description:
-2147220499 No Steps have been defined for the transformation Package
Thanks in advance.
Basir
Can you run the package period ?
Sounds to me like maybe a data pump has been incorrectly defined (Not
defined). Go to the black lines between two connections and check in
there. Go through the tabs and DTS will shout when it falls over.
Allan
Allan Mitchell
www.SQLDTS.com
exec master..xp_cmdshell 'dtsrun /SServerName /Uuser /Ppassword
/NmyPackageName'
produces the following error:
(note that the input text file resides on the same workstation, with full
permissions given to Everyone.)
output
------------------------------------------------
----------------------------------------------------------------------------
-------------DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147217887 (80040E21)
Error string: Error opening datafile: The device is not ready.
Error source: Microsoft Data Transformation Services Flat File Rowset
Provider
Help file: DTSFFile.hlp
Help context: 0
Error Detail Records:
Error: 21 (15); Provider Error: 21 (15)
Error string: Error opening datafile: The device is not ready.
Error source: Microsoft Data Transformation Services Flat File Rowset
Provider
Help file: DTSFFile.hlp
Help context: 0
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun: Package execution complete.
(21 row(s) affected)
"Allan Mitchell" <al...@no-spam-please.sqldts.com> wrote in message
news:3d2b32fb...@news.microsoft.com...
Looks to me like you cannot see the flat file.
Executing xp_cmdshell when a member of the sysadmin group on SQL
Server causes the query to run under the guise of the SQL Server
Service account , if not in the SYSADMIN group then it executes under
the proxy account
Are you a sysadmin ?
Who is your proxy ?
Who is your service account ?
Just because you've mapped a drive to a place doesn't mean anyone else
can see it/ Have permissions to it.
try using UNC for a start
Allan
www.SQLDTS.com
Allan Mitchell
www.SQLDTS.com