Viewing 15 posts - 16 through 30 (of 66 total)
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...
November 24, 2014 at 8:51 pm
no manual execution on job..it fails on scheduled job and some time it success.
May 9, 2014 at 7:58 am
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)...
May 9, 2014 at 7:35 am
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...
November 21, 2010 at 6:27 am
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...
November 19, 2010 at 10:42 am
Thanks Lynn and Pradeep for the information. I will investigate on it.
November 17, 2010 at 10:12 am
it is resolved. actually i just needed to change debug mode in project for runtime64 bit to false.
Now it is good. 🙂
Thanks
Sager
October 24, 2010 at 7:09 pm
Any suggestion?
Thanks
Sagar
October 24, 2010 at 5:30 pm
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...
October 24, 2010 at 7:59 am
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...
October 23, 2010 at 3:00 pm
Thanks for the reply,
My load from flat file to sql server table was failed, i thought because file contain special character...
January 18, 2010 at 8:33 am
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...
December 3, 2009 at 8:21 am
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] ==...
December 2, 2009 at 11:39 pm
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...
December 2, 2009 at 1:02 pm
Viewing 15 posts - 16 through 30 (of 66 total)