I have tried both dbase III and IV but they dont work.

The problem is i am not a DBA, just a developer. So i can't

download and install just any driver...

i have dbase III and IV but it doest work..

wat about visual foxpro... how to get its free driver?

ya...it would really help if you could post the print @Query here. Otherwise we all would be aiming in the dark.. 😛

The statement

SET @TODAY_DTTM = CONVERT(DATETIME,@TODAY_DATE)

is erroring out with the below message:

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

I don't understand...

try posting the whole error message.

it would be just below the message you have posted.

generally this kind of errors go away when we open the data flow task in the BIDS automatically. don't know why its not happening in this case.

Try using SQL...

you are getting this error because the table is being reference by another table by foreign key. first truncate the dependent table and then truncate this table. this should solve...

i created a table EmailTest with your fields.

Then i created the following code:

Declare @id int,@email varchar(100), @mail varchar(200)

set @id = 1

set @mail = ''

-- Looping through the table to pick...

See the below link for File exists SSIS script task:

http://204.9.76.233/Community/forums/p/3176/17209.aspx#17209

To Execute a job from a stored proc:

--Start Job

EXEC msdb.dbo.sp_start_job N'Weekly Accounts Payable Transaction History'

--Stop Job

EXEC msdb.dbo.sp_stop_job N'NightlyInventoryFeed'

--Info abt Job

EXEC msdb.dbo.sp_help_job

@job_name = N'FinanceBackup',

@job_aspect...

Have you deployed the packages on sysdtspackages90 table of msdb database?

If yes then after changing the packages redeploy them.

The SQL Agent Jobs do not need to be modified.

Thanks

Pankaj

That is the problem i faced too once.

You...

whats happening in the data flow task?

Can you verify if it has completed?

Christopher Stobbs (12/16/2008)

---

one way around it is to declare a local variable and assign the value of the parameter to that variable and use that in your proc rather than...

i have tried this...but to no effect...

i have read some articles on parameters sniffing and they dont really explain how to resolve this. 🙁