i ran a test and it seems if there is something wrong within the cmd shell you get that error. i fixed the error i had and it worked...

i had this issues before. what i did since this only works on the CMD shell is create a stored proc that will use xp_cmdshell to call the DTEXEC...

if ur not familar with file system task, how about using execute sql task and use xp_cmdshell to get a directory listing and rename the file.

using SSIS you can use your flat fiel as your source file and the SQl table as you destination. in your destination click on mapping to match all columns....

when the memory was upgraded was the server platform upgraded as well from 32 bit to 64 bit?

SET NOCOUNT ON

DECLARE @SQL NVARCHAR(4000)

SET @SQL =

'SELECT ACCT, USERNAME FROM OPENQUERY(CUSTOMER,''SELECT==lcl.ACCT, lcl.USERNAME FROM LOCAL_LOG lcl WHERE lcl.VALUE= '''''+ LTRIM(RTRIM(@VALUE)) +''''' ORDER BY lcl.PROCESS_DATE DESC'')'

--PRINT @SQL

EXEC(@SQL)

how about dynamic sql using openquery

USE DTS

first choose ms ole provider for oracle, then for executing the procedure do this

BEGIN

EXEC proc;

COMMIT;

END;

not sure what you are saying but i think this is what you need:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

create procedure tsst

@tbl_name nvarchar(50)

AS

BEGIN

insert into @tbl_name...

try using openquery instead or EXEC. i know EXEC is much faster but it will work with openquery.

are you trying to import data from a flat file and put it into a database?

are you trying to import data from a flat file and create a table in...

make sure alwaysusedefaultcodepage is set to true

when you are setting up your connection thru connection manager check off save password. also on the main page you have an option to save the password with file...

create table #temp (dbname nvarchar (50), logsize nvarchar(25),logspace nvarchar (25),status int, i int identity)

declare @cmd nvarchar(1024),@cmd2 nvarchar(1024)

set @cmd = 'dbcc sqlperf (logspace)'

insert into #temp execute( @cmd)

declare @min-2 int,...