I am trying to execute an DTSX for Exporting data from SQL 2005 to Access Database. From SQL Wizard, the Export process is running fine.
When I tried to execute the same using an Stored Procedure (
XP_CMDShell 'dtexec /F E:\Shared\Export\Export_Fame_Entity.dtsx') it is getting executed for long time.. but never gets completed and thus, not giving any error also.
Help required.........
regards,
Ravi K
Mascon Global Limited
Problem with DTSX
Hot Topic
- Regenerating Package ID programmatically
- SQL installation Error...
- ReportViewer with Authentication
- SqlDeveloper/SqlExpress Conflict.
- It seems SQL editor do not support "Format" function. Is it right?
- Good SSIS Example tutorial - User Variables
- Connection Issues
- ODBC Text file to SQL conversion
- ISO 8601 complient week numbering
- Pb with group and lost of informations in the report
SQL Server
- transfer a sheet from excel in to sql table
- Sql stored procedure call hangs from .net
- OLEDB Datasources and parameters
- is it possible to know whether report still executing
- Does a checkpoint file record a package's state
- Could not find stored procedure 'msdb.dbo.xp_sqlagent_notify'
- SQL Express user permissions?
- Handle TEXT FIELDS in Recordset Using ASP
- TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host
- Login failed for user '<<domain>>\<<server>>$'.
Problem with DTSX
mac318
In SQL Server 2005 the xp_cmdshell is disabled in new installations. This may be your problem. The Books Online topic, Surface Area Configuration for Features, rovides more information about enabling xp_cmdshell.
Also it looks like your command line is missing quotes. Try using "E:\Shared\Export\Export_Fame_Entity.dtsx"
I ran a package successfully from the Query window in SQL Server Management Studio using the following syntax
xp_cmdshell 'dtexec /f "C:\UpsertData.dtsx"'
The SQL Server 2005 Books Online topic, dtexec Utility, provides a wealth of information about running packages by using dtexec.
Marianne
SQL Server User Education
This posting is provided "AS IS" with no warranties, and confers no rights.