Hi,
    I have created a DTS package on my SQL server to import data from dbf file.
I am able to execute it directly. ie Data Transformation Services-->Local Packages-->execute package.

But if I am writing an sql statement to execute it i am not able to do that.
EXEC master..xp_cmdshell 'DTSRun /S "Test1" /U "aa" /P "aa" /N "ImportSecond" /G "{D75AFA82-8DC6-4AF3-B48E-6884E97D6BA1}" /W "0"'

I am getting the following error

DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: Create Table [BomNetOperation].[dbo].[branch] Step
DTSRun OnFinish: Create Table [BomNetOperation].[dbo].[branch] Step
DTSRun OnStart: Copy Data from branch to [BomNetOperation].[dbo].[branch] Step
DTSRun OnError: Copy Data from branch to [BomNetOperation].[dbo].[branch] Step, Error = -2147467259 (80004005)
   Error string: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
   Error source: Microsoft OLE DB Provider for ODBC Drivers
   Help file:
   Help context: 0

Please guide.

dvpo24,
It looks like your execution of the package worked because it created the Branch table in your target database; however when it try to copy the data it failed. Your source connection is not defined properly. You need to check you connection attributes. Make sure you choose the appropriate driver and test the connection.

Regards,
Fernando Sanchez

I'm facing the same problem as stated below. Has anybody found a solution for this? Please help.