I was doing online but issue was on rollback when it had to killed.. Took for ever.. Any other sophisticate way to do index maintenence without having rollback? Does re-org...

Any idea ?

no manual execution on job..it fails on scheduled job and some time it success.

Thats true. It fails 30% of total time of it total execute. i also found out server A and server B has two different port server A 2005 (xxx port)...

Ya I found that file was Handled by net back up.. I have changed bkup schedule... How do I remove that lock with out installing third party tool.. Just incase...

Thanks all for the sharing information. I have regular net back up. but i do local back up/ log back up as well just to make sure the avoid other...

Thanks Lynn and Pradeep for the information. I will investigate on it.

it is resolved. actually i just needed to change debug mode in project for runtime64 bit to false.

Now it is good. 🙂

Thanks

Sager

Any suggestion?

Thanks

Sagar

Hi,

here is the error and connection string that had passed in variable.

[OLE DB Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.

The AcquireConnection method call to the connection manager...

Thanks for the reply john.

error was on source connection which is oracle, i have used olaedb provider for oracle. package is running on same instance where sql server 2005...

Thanks for the reply,

My load from flat file to sql server table was failed, i thought because file contain special character...

record in flatfile is blank, and when i igonered error output it stored in db as null. Date column comes from flat file as 09/02/2009 and some of this...

I added the derived column transformation task right before the date conversion and added expression as below still error

ISNULL([Column 5]) == TRUE || [Column 5] ==...

I have one question though, when there is blank or null value for date in flat file looks like it through error should i ignore the error outupt to ignore...